Anything to Manually Define When Using Navigation To CDS Based EntitySet?

[and23_julius]

Hi.

I have a circumstances as below (mock case just for illustratin):

• "A" is the entity type which is list of PO Numbers from EKKO...
• "C" is an entity type mapped from CDS view to count the number of item for ALL PO number based on storage location (no transparent table, created CDS View with parameter, import structure, map variables to the CDS, get_entityset is relying on super method)
• "ACNav" is the navigation between "A" to "C" in One-to-Many

After doing the above,:

• I tested CSet and it returns the count for all PO based on storage location as expected
• but when I try to use the navigation /ASet('1000000005')/ACNav I get exception from the super GET_ENTITYSET method

Is there anything I need to do to get it working? I read about creating CDS with parameter and usage of SET_QUERY_OPTIONS, I wonder if this is the correct way to do it?

If it is the correct way, how do I retrieve the PO number from the ASet (i.e.: 1000000005')? If it is not can someone please advise on the right way to achieve it? Your expertise is much appreciated

Best Regards

Andre Julius

[and23_julius]

Hi All,

As I dig further today...it seems if I want to associate CDS view-mapped-entity types seamlessly, I have to use CDS Association instead of SEGW Association....can someone please verify whether I conclude correctly?

Best Regards

Andre Julius

[and23_julius]

I'm still looking for answers on this. for now I survived using normal OData instead of CDS Based but I believe it is not the best practice for major cases. Can anyone please help?

Best Regards

Andre Julius