Skip to Content
0
Apr 24, 2018 at 06:30 AM

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

100 Views

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