Symptom
When using OData service, it is not possible to obtain price list details.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Application and User Management work center
- Under Input and Output Management view, select OData Services subview
- In the drop-down menu, select Custom OData Services
- Select service XYZ (Where XYZ refers to the service)
- 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