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