Select Option - CDS Hana Studio

f_allocca · ‎2023 Mar 14

Hi Experts,

I have a CDS with PARAMETERS see below:

but I need also a simply SELECT-OPTION for the LFA1-LIFNR field

Please, can you show me the example of code for 1 field?

Thanks

Best Regards

Francesco

FredericGirod · ‎2023 Mar 14

You cannot, or you have to use tips&trick like

ThorstenHoefer · ‎2023 Mar 14

Hello,

You should create a SQL statement outside of the CDS view:

Therefore you can use class CL_SHDB_SELTAB.

Please check the following example:

Regards

Thorsten