Skip to Content

Calling CDS associations in ABAP programs

I'm trying to find the correct syntax to retrieve data from CDS associations from an ABAP program.

This is my CDS view with 3 associations.

define view y_ddl_flights as select from scustom as customer

association [1..*] to sbook as _bookings on customer.id = _bookings.customid { customer.id,

customer.name,

, _bookings[class = 'C'] as business_flights,

_bookings[class = 'Y'] as economy_flights,

_bookings[class = 'F'] as firstclass_flights }

Now how to get data from the association business_flights in an ABAP program.

I tried the following but it shows syntax error.

TYPES:BEGIN OF t_test,
id TYPE s_customer,
name TYPE s_custname,
carrid TYPE s_carr_id,
END OF t_test.

DATA: it_test TYPE STANDARD TABLE OF t_test.

SELECT id,name,\business_flights\_carrid FROM y_ddl_flights
INTO CORRESPONDING FIELDS OF TABLE @it_test
WHERE id = '00000001'.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers