3727137 - Price List Item Details Not Retrieved via API or OData When Using Base Price List Name

When attempting to retrieve Price list item details via API or OData report using the Base Price List Name, the response only returns the Price list name or header-level information.

The item-level pricing details (sales price specifications) are not returned in the response.

SAP Business ByDesign

1. Log in to SAP Business ByDesign.
2. Attempt to retrieve Price list details via API or OData.
3. Use the web service ManageSalesPriceListIn or an OData query.
4. Execute the request using the Base Price List Name as the filter.
5. Check the API/OData response.

Result:
Only the Price list header information (such as the list name) is returned.

Expected Result:
The response should return Price list item details, including product-level pricing information.

The Base Price List Name is not the primary technical identifier used by the API to retrieve detailed Price list information.

The APIs in SAP Business ByDesign require the Price List ID to retrieve the associated sales price specifications and item-level details. When the query is executed using only the Base Price List Name, the system returns only header-level data and does not fetch the related Price list items.

Use the web service ManageSalesPriceListIn with the operation Read Price lists with filter and query the Price list using the Price List ID.

Steps

1. Go to Application and User Management work center.
2. Open Service Explorer.
3. Search for the web service ManageSalesPriceListIn.
4. Select the operation Read Price lists with filter.
5. Use the query SalesPriceListFindByIDQuery_flt_sync and provide the Price List ID.

Sample SOAP Request

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope"
xmlns:glob="http://sap.com/xi/SAPGlobal20/Global">
   <soap:Header/>
   <soap:Body>
      <glob:SalesPriceListFindByIDQuery_flt_sync>
         <SalesPriceList>
            <ID>BASE PRICE LIST</ID>
            <SalesPriceSpecificationProcessingConditions>
               <QueryHitsMaximumNumberValue>100</QueryHitsMaximumNumberValue>
               <QueryHitsUnlimitedIndicator>false</QueryHitsUnlimitedIndicator>
            </SalesPriceSpecificationProcessingConditions>
         </SalesPriceList>
      </glob:SalesPriceListFindByIDQuery_flt_sync>
   </soap:Body>
</soap:Envelope>

Note: In this example, the Price List ID used is "BASE PRICE LIST".

Refer to: Price List and Discount List Read with Pagination in SAP Business ByDesign Cloud ERP.

Price List, Base Price List, API, OData, ManageSalesPriceListIn, Price List Items, Sales Price Specification, Web Service , KBA , AP-PMD-SPL , Sales Price List , How To