Skip to Content
Author's profile photo Former Member
Former Member
Posted on October 2, 2013 Less than a 1 minute read

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

Follow RSS feed
0 Likes 998 Views 2 Comments

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

Assigned tags

Related Blog Posts

    Related Questions

      2 Comments
      You must be Logged on to comment or reply to a post.
      • Author's profile photo Former Member
        Former Member

        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.

      • Author's profile photo Arshad Ansary
        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