Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Fetch and formatting data using CDS with parameter

VISHAL_JHA
Explorer
0 Kudos

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

1 REPLY 1

fedaros
Contributor
0 Kudos

Hi vishaljha0803,

Please provide a example of input data and output data.

Your description are point me to answer you to repeat selection per where condition, but not sure what you plan to do.

Regards, Fernando Da Rós