3739090 - RFQ API: $filter in $expand of _RequestForQuotationBidder Returns empty or unfiltered results – API_CE_REQUESTFORQUOTATION_0001

• When calling API_CE_REQUESTFORQUOTATION_0001 and using a supplier filter within the $expand on _RequestForQuotationBidder, the following behavior is observed:
• The parent RequestForQuotation entity is returned successfully.
• The expanded _RequestForQuotationBidder collection is either empty or not filtered as expected.
• RFQs are returned even when the specified supplier is not assigned as a bidder.
• The $filter condition inside $expand does not restrict the parent entity results.
• No error message is triggered during the API call.

 SAP S/4HANA Cloud Public Edition

1. Perform a GET request to the RequestForQuotation entity set of api_ce_requestforquotation_0001.
2. Use $expand for _RequestForQuotationBidder with an inner $filter on Supplier equal to the id.
3. Observe that the main RequestForQuotation data is returned but the expanded _RequestForQuotationBidder list is empty or includes unassigned suppliers.

• Due to OData V2 protocol limitations, applying a $filter inside $expand is not supported; such filters are ignored or not applied as intended.
• Filtering on a navigation property from the main entity does not restrict the main result set unless all related entries match, leading to unexpected or empty expanded data.

1. Avoid placing filters inside $expand for navigation collections.
2. Query bidder data directly:
3. Call the bidder entity set and apply filters for both the RequestForQuotation ID and Supplier to retrieve only relevant bidders.
4. Alternatively, filter the main entity using any():
5. Apply $filter with _RequestForQuotationBidder/any(b: b/Supplier eq 'the id') on the RequestForQuotation entity set.
6. Use $expand=_RequestForQuotationBidder to include only bidders related to the filtered RFQs.
7. Optionally, use $select to limit the response to only the required fields.

api_ce_requestforquotation_0001, rfq api, _requestforquotationbidder, odata expand filter, supplier filter, navigation property filter, empty expand result, expand filter ignored, any() function, odata v2 limitation, rfq bidder, odata query, related entity filtering, expand and filter, procurement api , KBA , MM-FIO-PUR-RFQ-2CL , Fiori UI for RFQ/Quotation (Public Cloud) , Problem