I have a requirement to display query based on a custom table.
The fields in my custom table would be as below
Category, User ID, Department, Feedback, Issue, Comments
Example of data stored in the table would be, if the category is "A" the data is stored in fields "Department & Feedback" and if category is "B" the data gets stored in fields "Issue & Comments".
Now my SAP query will have the option to input Category and User ID.
The output of my query should have the below fields,
Category, User ID, Parameter1, Parameter2
Logic:
If the Category is "A", the parameter1 & parameter2 should display data from fields Department & Feedback
If the category is "B", the parameter1 & parameter2 should display the data from fields Issue & Comments
please guide how I can achieve this through SAP Query