SAP Knowledge Base Article - Public

3303062 - Unable to read the price list ID using Odata service.

Symptom

When using OData service, it is not possible to obtain price list details.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Application and User Management work center
  2. Under Input and Output Management view, select OData Services subview
  3. In the drop-down menu, select Custom OData Services
  4. Select service XYZ (Where XYZ refers to the service)
  5. Click in Edit button

Under the OData Service, SalesPriceList is selected.

Cause

The material ID and price it is not present in the single node, hence we need to navigate with association to get the details.

This is the standard system behaviour so it's not possible to get the details in one go in ODATA services.

Resolution

As a workaround, in order to get the data together, please use the below SOAP service below:

<n0:SalesPriceListFindByIDQuery_flt_sync xmlns:n0="http://sap.com/xi/SAPGlobal20/Global">
<SalesPriceList>
<UUID></UUID>
<ID>YOUR_PRICE_LIST_ID</ID>
<SalesPriceSpecificationProcessingConditions>
<QueryHitsMaximumNumberValue>1</QueryHitsMaximumNumberValue>
<QueryHitsUnlimitedIndicator>false</QueryHitsUnlimitedIndicator>
<LastReturnedObjectID></LastReturnedObjectID>
</SalesPriceSpecificationProcessingConditions>
</SalesPriceList>
</n0:SalesPriceListFindByIDQuery_flt_sync>

Otherwise, since this would be a new requirement, please refer to the Influence Forum.

 

Keywords

KBA , AP-PMD-SPL , Sales Price List , Problem

Product

SAP Business ByDesign all versions