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

 You would like to know how to query a Campaign Specific Price List via the Web Service QuerySalesPriceListIn.

SAP Business ByDesign

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. 

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>

More details can be found in the help documentation:

1. Go to the Application and User Management work center. 
2. Select the Service Explorer view. 
3. Select the Service QuerySalesPriceListIn. 
4. In the Details section, click on the Link for Documentation. 

Query; Campaign, Price Specification; CND_SALES_ORG_ID; Web Service; Price List; QuerySalesPriceListIn , KBA , AP-PMD-SPL , Sales Price List , Problem