Field name inside CDS

former_member182337 — Wed, 08 Nov 2017 16:27:11 GMT

Hello,

How can i get run time information of the field name inside CDS. For example: Select a.matnr from mara as a .... I know the field name is Matnr but my requirement is to look the field ( Note : Field and not its value) in another table and if that exists the value should be replaced something like this

select a.matnr....from ( case when a.matnr ( select field from 'TABLE' where fieldname = a.matnr ) then ' Table value' else a.matnr

I can hardcode the fieldname as 'MATNR' in the sub select but the problem is i have more than 200 fields and then i have to do the select as many times. Is there a way to identify the field name without having to hardcode .

Thanks.

Prem

Re: Field name inside CDS

retired_member — Wed, 08 Nov 2017 17:21:13 GMT

No. ABAP CDS SQL is static. And there are also no subqueries in ABAP CDS.

For things like that, try to use SQLScript in CDS table functions or use the dynamic clauses of Open SQL.

Re: Field name inside CDS

former_member182337 — Fri, 10 Nov 2017 16:34:41 GMT

Thank you .

topic Field name inside CDS in Application Development and Automation Discussions

Field name inside CDS

Re: Field name inside CDS

Re: Field name inside CDS