CDS Associations Select into deep structure

[msadik]

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.

[msadik]

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.

[retired_member]

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.