Symptom
You would like to know how to query a Campaign Specific Price List via the Web Service QuerySalesPriceListIn.
Environment
SAP Business ByDesign
Cause
The Type Code for the Company Specific Price List is 7PL0.
You need to ensure that you include the following Header Key Names in your payload for the <PriceSpecificationElementPropertyID> element:
- CND_SALES_ORG_ID for the value of the Sales Organization.
- DISTR_CHANNEL for the value of the Distribution Channel.
- CND_CAMPAIGN_ID for the value of the Campaign ID.
Resolution
Here a sample Payload where the Sales Organization is P1110, the Distribution Channel is 01 and the Campaign ID is 214:
<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>
<ReleaseStatusCode>3</ReleaseStatusCode>
<TypeCode>7PL0</TypeCode>
<PropertyValuationPriceSpecificationElementPropertyValuation2>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_SALES_ORG_ID</PriceSpecificationElementPropertyID>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<ID>P1110</ID>
</PriceSpecificationElementPropertyValue>
</PropertyValuationPriceSpecificationElementPropertyValuation2>
<PropertyValuationPriceSpecificationElementPropertyValuation3>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>DISTR_CHANNEL</PriceSpecificationElementPropertyID>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code>01</Code>
</PriceSpecificationElementPropertyValue>
</PropertyValuationPriceSpecificationElementPropertyValuation3>
<PropertyValuationPriceSpecificationElementPropertyValuation4>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_CAMPAIGN_ID</PriceSpecificationElementPropertyID>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<ID>214</ID>
</PriceSpecificationElementPropertyValue>
</PropertyValuationPriceSpecificationElementPropertyValuation4>
</SalesPriceList>
</glob:SalesPriceListFindByTypeCodeAndPropertyIDAndPropertyValueQuery_sync>
</soap:Body>
</soap:Envelope>
See Also
More details can be found in the help documentation:
- Go to the Application and User Management work center.
- Select the Service Explorer view.
- Select the Service QuerySalesPriceListIn.
- In the Details section, click on the Link for Documentation.
KBA 3464656 - How to Query a Price List by ID or UUID via the Web Service QuerySalesPriceListIn
Keywords
Query; Campaign, Price Specification; CND_SALES_ORG_ID; Web Service; Price List; QuerySalesPriceListIn , KBA , AP-PMD-SPL , Sales Price List , Problem