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: 

CDS Associations Select into deep structure

msadik
Explorer

Hi;

Is it possible to select from a cds which contains associations, into a deep structure with path expressions. for example we have a cds which selects from vbak and it has an association with vbap and vbap exposed in the cds. can we select this cds into a deep structure like below.

types begin of ty_orders.

types vbeln type vbak-vbeln.

types items type standard table of vbap.

types end of ty_orders.

1 ACCEPTED SOLUTION

horst_keller
Product and Topic Expert
Product and Topic Expert
0 Kudos

For accessing CDS entities with Open SQL SELECT the same holds for the INTO clause as for all other database entities. See the documentation. No nested tables. What we would need were a connection to meshes.

1 REPLY 1

horst_keller
Product and Topic Expert
Product and Topic Expert
0 Kudos

For accessing CDS entities with Open SQL SELECT the same holds for the INTO clause as for all other database entities. See the documentation. No nested tables. What we would need were a connection to meshes.