Which association is going to be executed .

[BODHISATTWA__20]

Lets say If I have a CDS view with two associations .e.g.

Associations are join on demand , which essentially means , which association to execute is entirely left up to the user .

Now if we call this CDS from a select statement .

SELECT <field1> <field2>  FROM <CDS_VIEW_NAME> INTO CORRESPONDING FIELDS OF TABLE @itab.

In such an above situation which association is going to be executed .

maheshkumar.palavalli

[kyo_choi2]

Only <field1><field2> will be selected in your internal table according to your select statement. Potentially all the fields in table scarr, spfli and sflight should show up with cardinality, if it was defined in the CDS view.

[maheshpalavalli · Accepted solution]

If field1 or field2 belongs to the association then the association view data will be pulled, if those fields are not part of the association then the association won't gets executed.

Is that what you are looking for?

You can also.chefk how to access association in ABAP select query from the belwo helop

https://help.sap.com/doc/abapdocu_752_index_htm/7.52/en-US/abenopen_sql_path.htm