Skip to Content
Actions

Unable to expand line items using $expand when used along with $filter

October 2, 2013 | 52 Views |
 expand
Follow

Dear Folks,

In my service, I am able to query header collection with a filter. (Delivery_header collection)

Now I want to expand (Delivery_line-items) for each delivery nos. I did the associations of the principal keys of delivery header collection with line item collection fields. I also provided the required navigation property.

I tried the following syntaxes but to no avail.

sap/opu/odata/sap/DELVRY_SRV/DELIVERY_HEADER?$filter=C_Tid eq ‘S0000001284’&$expand=DELIVERY_ITEM,

sap/opu/odata/sap/DELVRY_SRV/DELIVERY_HEADER?$filter=C_Tid eq ‘S0000001284’?$expand=DELIVERY_ITEM,

sap/opu/odata/sap/DELVRY_SRV/DELIVERY_HEADER?$filter=(C_Tid eq ‘S0000001284’)&$expand=DELIVERY_ITEM.

Please provide me some insight in this regard.

Thanks,

Kawish

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Ron Sargeant

    Hi Kawish,

    Can I assume that ‘C_Tid’ is not your primary key for DELIVERY_HEADER? If it is the primary you should use a different URI.

    Could you post up the service metadata, it’s not possible to determine a specific service fault in a customer-space URI without it.

    Regards

    Ron.

    (0) 
  2. Arshad Ansary

    Hi kawish,

    Hope DELIVERY_ITEM is the navigation name that connects DeliveryHeader to DeliveryItem

    One more thing ys you need to implement GET_EXPANDED_ENTITY method in the DPC_EXT class

    (0) 

Leave a Reply