CDS deep level association - expose to service - p...

rosenpetrov · ‎2025 May 14

Hello i have 3 cds views and would like to expose the main view ZTEST_R1_ORD_MAIN as a service.
My aim is when the service is being executed to be able to return the data related to all items (view ZTEST_R1_ORD_VBAP) related to the root view and all schedule lines (view ZTEST_R1_ORD_VBEP) related to the items.
I.e. the structure is 3 levels deep:
ZTEST_R1_ORD_MAIN -> ZTEST_R1_ORD_VBAP -> ZTEST_R1_ORD_VBEP
and relations are performed via associations.
I export the root entity ZTEST_R1_ORD_MAIN via @odata.publlish:true

I perform tests via transaction /IWFND/GW_CLIENT.
I do have an access (via @expand=) to association which relates the 1st to the 2nd view (ZTEST_R1_ORD_MAIN -> ZTEST_R1_ORD_VBAP), i.e. association _item. And i can read the entries in _item association.
The problem is that i can NOT access association which relates 2nd to the 3rd view (ZTEST_R1_ORD_VBAP -> ZTEST_R1_ORD_VBEP), i.e. association: _schline. And i can NOT read the entities in _schline association.

I don't know if this is restriction of @odata.publish:true...
I have tried also with manually creating service and service binding - again without success.
Sap returns message like: _schline is not a recognizable object.

Here are the view definitions:

1st level view is exposed as a service via @odata.publish:true

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'x'
@Metadata.ignorePropagatedAnnotations: true
define root view entity ztest_r1_ord_main as select from vbak
association [1..*] to ztest_r1_ord_vbap as _item on $projection.vbeln = _item.vbeln
{
    key vbeln,
    vkorg,    
     
     _item
}

2nd level view

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'x'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #X,
    sizeCategory: #S,
    dataClass: #MIXED
}
define view entity ztest_r1_ord_vbap as select from vbap
association [1..*] to ztest_r1_ord_vbep as _schline on $projection.vbeln = _schline.vbeln and $projection.posnr = _schline.posnr

{
    key vbeln,
    key posnr,
    matnr,
    
    _schline    
}

3rd level view

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'VBEP'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #X,
    sizeCategory: #S,
    dataClass: #MIXED
}
define view entity ztest_r1_ord_vbep as select from vbep
{
    key vbeln,
    key posnr,
    key etenr,
    
     @Semantics.quantity.unitOfMeasure: 'vrkme'
    bmeng,
    vrkme    
}

Please, give me an advice how to solve this.

junwu · ‎2025 May 14

how does your url look like? when you ask for third level data.

CDS deep level association - expose to service - problem

Know the answer?

Need more details?