Skip to Content
0
Dec 21, 2022 at 12:43 AM

SAP query to display output based on the input values

155 Views Last edit Dec 28, 2022 at 02:56 AM 2 rev

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