Dear experts,
I have a to fetch data from multiple tables and one of the table takes input for one field as an input. I wave to put data into different fields of target based on the value of input filed.
e.g. Table TAB field for input is field_input and data field to be retrieved is field_output.
Values 'A' and 'B' are variable which will be sent from ABAP program. Query in question is like below
Select from TAB where FIELD_INPUT in ( 'A', 'B')
{
case TAB.FIELD_INPUT
WHEN 'A' then FIELD_OUTPT as FIELD_OP1
WHEN 'B' then FIELD_OUTPT as FIELD_OP2
}
Could you please provide your valuable input how to achieve it using ABAP CDS as the volume of data is more than 1.5 millions record at a time.
Thanks
Vishal
