SAP Knowledge Base Article - Public

3464656 - How to Query a Price List by ID or UUID via the Web Service QuerySalesPriceListIn

Symptom

You would like to know how to query a Price List by Price List ID or UUID via the Web Service QuerySalesPriceListIn.

Environment

SAP Business ByDesign

Cause

Since this service is based on the TypeCode, PropertyID and PropertyValue, you must pass either of the parameters to fetch the query along with PriceListID or UUID.

Type Code 7PL0 is used for Base Price List, Distribution Chain Price List, Customer Specific Price List, Base Price List by Product Category, Distribution Chain Price List by Product Category, Customer Group Specific Price List
Type Code 7PL1 is used for Overall Customer Discount
Type Code 7PL2 is used for Customer Specific Discount Products
Type Code 7PL3 is used for Overall Customer Group Discount
Type Code 7PL4 is used for Customer Specific Discount Product Category

Resolution

Here a sample Payload where the Type Code is 7PL0 since it is a Base Price List and the Price List ID is Base Price List Company X:

<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:SalesPriceListFindByTypeCodeAndPropertyIDAndPropertyValueQuery_sync>

         <SalesPriceList>

            <TypeCode>7PL0</TypeCode>

            <ID>Base Price List Company X</ID>

         </SalesPriceList>

      </glob:SalesPriceListFindByTypeCodeAndPropertyIDAndPropertyValueQuery_sync>

   </soap:Body>

</soap:Envelope>

 

Here a sample Payload where the Type Code is 7PL0 since it is a Base Price List and the  UUID of the Price List is 7fb92382-9129-1ede-b8d5-5db4f0bdc4c9:

<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:SalesPriceListFindByTypeCodeAndPropertyIDAndPropertyValueQuery_sync>

         <SalesPriceList>

            <TypeCode>7PL0</TypeCode>

            <UUID>7fb92382-9129-1ede-b8d5-5db4f0bdc4c9</UUID>

         </SalesPriceList>

      </glob:SalesPriceListFindByTypeCodeAndPropertyIDAndPropertyValueQuery_sync>

   </soap:Body>

</soap:Envelope>

See Also

KBA 3195901 - How to Query Campaign Specific Price List via the Web Service QuerySalesPriceListIn

Keywords

QuerySalesPriceListIn; Web Service; Webservice; Query: Price List;  , KBA , AP-PMD-SPL , Sales Price List , Problem

Product

SAP Business ByDesign all versions