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: 

How to get association name and association column name of cds view ?

0 Kudos
174

Hi,

I need to get association name and association column name of cds view.

For example, if I have the CDS view below, I want to get "_sc" and _sc's column name's from here.

--------------------------------------------------------------------------------------------------

define view entity zzcds_association1 as select from spfli as _sp

association[1..1] to scarr as _sc

on $projection.carrid = _sc.carrid

{

key _sp.carrid,

key _sp.connid,

_sp.countryfr,

_sp.cityfrom,

_sp.airpfrom,

_sc

}

--------------------------------------------------------------------------------------------------

Which table can I get this from?

Which function module can I get it from?

Thanks and best regards,

Shunsuke

0 REPLIES 0