Fetch and formatting data using CDS with parameter

VISHAL_JHA — Wed, 18 Oct 2023 08:23:32 GMT

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

Re: Fetch and formatting data using CDS with parameter

fedaros — Wed, 18 Oct 2023 10:02:54 GMT

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

topic Re: Fetch and formatting data using CDS with parameter in Application Development and Automation Discussions

Fetch and formatting data using CDS with parameter

Re: Fetch and formatting data using CDS with parameter