07-24-2020 10:38 AM
Hi,
I know the concept of exposed association. It's a join on demand association but i don't know how to consume exposed association in abap. How can we achieve join on demand while writing select statement.
define view zexposed_cds as select from spfli as sp
association[1] to scarr as _scarr
on sp.carrid = _scarr.carrid
{
key carrid,
_scarr
}
Thanks
Ravi
07-24-2020 12:29 PM
This statement should help you.
https://help.sap.com/doc/abapdocu_752_index_htm/7.52/en-US/abenopen_sql_path.htm
SELECT carrid, \_scarr-carrname as carrname FROM zexposed_cds INTO TABLE @DATA(lt_data).
07-24-2020 12:29 PM
This statement should help you.
https://help.sap.com/doc/abapdocu_752_index_htm/7.52/en-US/abenopen_sql_path.htm
SELECT carrid, \_scarr-carrname as carrname FROM zexposed_cds INTO TABLE @DATA(lt_data).