Enterprise Resource Planning Blogs by SAP
Get insights and updates about cloud ERP and RISE with SAP, SAP S/4HANA and SAP S/4HANA Cloud, and more enterprise management capabilities with SAP blog posts.
cancel
Showing results for 
Search instead for 
Did you mean: 
murthy_v
Advisor
Advisor
3,199
Partners and Customers who are selling lot of products in SAP Business ByDesign and for those products you would maintain price and discount master data and would end up having high volume price list and discount list. In case if you would like to read all the product prices and discounts master data, we now provide a capability to read Price and Discount master data in pages / blocks.



the Demo video covers the following aspects:

  • Enable the consumption of price list and discount list service with pagination

    • Creation of Communication System

    • Creation of Communication Scenario

    • Creation of Communication Arrangement



  • Testing the Price List and Discount List read web-service with pagination options along with live demo.


Capabilities

1.Price List read web service enabled for pagination

2.Discount List read web service enabled for pagination

 

Benefits for Customers

1.High volume price list can be extracted out of system

2.High volume discount list can be extracted out of system

3.Pricing and Discount Analytics enabler, analytics could be done outside the system after extraction out of SAP Business ByDesign

 

Note: This capability has been requested by the improvement request  which achieved 19 votes.

 

Details of the SOAP webservice API:

  • Service Name : Manage Price Lists

  • Operation Name : Read price list with filter

  • Note: in the request payload user have to pass the following information for pagination to work.

    • QueryHitsMaximumNumberValue = Desired Page Size

    • LastReturnedObjectID = Takes UUID of Last returned item record in Price List / Discount list





 







Note : for more detailed documentation please refer to webservice documentation.

 

Sample Initial Request Payload ( with page size 100 records )


<SalesPriceList>
<ID>PRICELIST_DC_PC</ID>
<SalesPriceSpecificationProcessingConditions>
<QueryHitsMaximumNumberValue>100</QueryHitsMaximumNumberValue>
<QueryHitsUnlimitedIndicator>false</QueryHitsUnlimitedIndicator>
<LastReturnedObjectID></LastReturnedObjectID>
</SalesPriceSpecificationProcessingConditions>
</SalesPriceList>

Sample Response Payload:


<soap-env:Envelope xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/">
<soap-env:Header />
<soap-env:Body>
<nm:SalesPriceListFindByIDResponse_sync
xmlns:nm="http://sap.com/xi/SAPGlobal20/Global" xmlns:prx="urn:sap.com:proxy:QKQ:/1SAI/TAEA50F1F2292541DBF7E85:803">
<SalesPriceListFindByIDResponseMessage>
<ID>SCALEPRICETEST</ID>
<ReleaseStatusCode>3</ReleaseStatusCode>
<ReleaseStatusName languageCode="EN">Released
</ReleaseStatusName>
<ApprovalStatusCode>4</ApprovalStatusCode>
<ApprovalStatusName>Approved</ApprovalStatusName>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_BUYER_ID
</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2
</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<ID>MC9785</ID>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">Silverstar Wholesale
Corp</Description>
</PropertyValuation>
<TypeCode listID="2">7PL0</TypeCode>
<TypeName languageCode="EN">Price List</TypeName>
<CurrencyCode>USD</CurrencyCode>
<CurrencyName languageCode="EN">US Dollar</CurrencyName>
<ValidityPeriod>
<IntervalBoundaryTypeCode></IntervalBoundaryTypeCode>
<StartTimePoint>
<TypeCode>1</TypeCode>
<Date>2011-08-29</Date>
</StartTimePoint>
<EndTimePoint>
<TypeCode>1</TypeCode>
<Date>2012-12-31</Date>
</EndTimePoint>
</ValidityPeriod>
<Description languageCode="EN">Test scales in Price
</Description>
<PriceSpecification>
<PriceSpecificationElementTypeCode
listID="2">7PR1</PriceSpecificationElementTypeCode>
<PriceSpecificationElementTypeName
languageCode="EN">List
Price
</PriceSpecificationElementTypeName>
<PriceSpecificationElementCategoryCode>1
</PriceSpecificationElementCategoryCode>
<PriceSpecificationElementCategoryName
languageCode="EN">Price</PriceSpecificationElementCategoryName>
<PriceSpecificationElementPurposeCode>1000
</PriceSpecificationElementPurposeCode>
<PriceSpecificationElementPurposeName
languageCode="EN">General</PriceSpecificationElementPurposeName>
<ConsistencyStatusCode>3</ConsistencyStatusCode>
<ConsistencyStatusName languageCode="EN">Consistent
</ConsistencyStatusName>
<ReleaseStatusCode>3</ReleaseStatusCode>
<ReleaseStatusName languageCode="EN">Released
</ReleaseStatusName>
<BaseQuantity unitCode="EA">1.0</BaseQuantity>
<BaseQuantityTypeCode>EA</BaseQuantityTypeCode>
<BaseQuantityTypeCodeName
languageCode="EN">ea</BaseQuantityTypeCodeName>
<Amount currencyCode="USD">99.0</Amount>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_ID
</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2
</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<ID>MCF-0001</ID>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">AHT COMBI 75
</Description>
</PropertyValuation>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_ID_TYPE_CODE
</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2
</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code listID="CND_PRODUCT_ID_TYPE_CODE">1</Code>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">AHT COMBI 75
</Description>
</PropertyValuation>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_TYPE_CODE
</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2
</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code listID="CND_PRODUCT_TYPE_CODE">1</Code>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">AHT COMBI 75
</Description>
</PropertyValuation>
</PriceSpecification>
<PriceSpecification>
<PriceSpecificationElementTypeCode
listID="2">7PR1</PriceSpecificationElementTypeCode>
<PriceSpecificationElementTypeName
languageCode="EN">List
Price
</PriceSpecificationElementTypeName>
<PriceSpecificationElementCategoryCode>1
</PriceSpecificationElementCategoryCode>
<PriceSpecificationElementCategoryName
languageCode="EN">Price</PriceSpecificationElementCategoryName>
<PriceSpecificationElementPurposeCode>1000
</PriceSpecificationElementPurposeCode>
<PriceSpecificationElementPurposeName
languageCode="EN">General</PriceSpecificationElementPurposeName>
<ConsistencyStatusCode>3</ConsistencyStatusCode>
<ConsistencyStatusName languageCode="EN">Consistent
</ConsistencyStatusName>
<ReleaseStatusCode>3</ReleaseStatusCode>
<ReleaseStatusName languageCode="EN">Released
</ReleaseStatusName>
<BaseQuantity unitCode="EA">1.0</BaseQuantity>
<BaseQuantityTypeCode>EA</BaseQuantityTypeCode>
<BaseQuantityTypeCodeName
languageCode="EN">ea</BaseQuantityTypeCodeName>
<Amount currencyCode="USD">100.0</Amount>
<ScaleExistsIndicator>true</ScaleExistsIndicator>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_ID
</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2
</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<ID>MCF-0002</ID>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">AHT COMBI 100
</Description>
</PropertyValuation>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_ID_TYPE_CODE
</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2
</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code listID="CND_PRODUCT_ID_TYPE_CODE">1</Code>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">AHT COMBI 100
</Description>
</PropertyValuation>
<PropertyValuation>
<PriceSpecificationElementPropertyValuation>
<IdentifyingIndicator>true</IdentifyingIndicator>
<PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyID>CND_PRODUCT_TYPE_CODE
</PriceSpecificationElementPropertyID>
<PriceSpecificationElementPropertyDefinitionClassCode>2
</PriceSpecificationElementPropertyDefinitionClassCode>
</PriceSpecificationElementPropertyReference>
<PriceSpecificationElementPropertyValue>
<Code listID="CND_PRODUCT_TYPE_CODE">1</Code>
</PriceSpecificationElementPropertyValue>
</PriceSpecificationElementPropertyValuation>
<Description languageCode="EN">AHT COMBI 100
</Description>
</PropertyValuation>
<ScaleLine>
<FirstDimensionScaleAxisStep>
<ScaleAxisBaseCode>1</ScaleAxisBaseCode>
<ScaleAxisBaseName languageCode="EN">Quantity
</ScaleAxisBaseName>
<ScaleAxisStepIntervalBoundaryTypeCode>1
</ScaleAxisStepIntervalBoundaryTypeCode>
<ScaleAxisStepIntervalBoundaryTypeName
languageCode="EN">Basescale
</ScaleAxisStepIntervalBoundaryTypeName>
<Quantity unitCode="EA">0.0</Quantity>
<QuantityTypeCode>EA</QuantityTypeCode>
<QuantityTypeName languageCode="EN">ea
</QuantityTypeName>
</FirstDimensionScaleAxisStep>
<BaseQuantity unitCode="EA">1.0</BaseQuantity>
<BaseQuantityTypeCode>EA</BaseQuantityTypeCode>
<BaseQuantityTypeName languageCode="EN">ea
</BaseQuantityTypeName>
<Amount currencyCode="USD">100.0</Amount>
</ScaleLine>
<ScaleLine>
<FirstDimensionScaleAxisStep>
<ScaleAxisBaseCode>1</ScaleAxisBaseCode>
<ScaleAxisBaseName languageCode="EN">Quantity
</ScaleAxisBaseName>
<ScaleAxisStepIntervalBoundaryTypeCode>1
</ScaleAxisStepIntervalBoundaryTypeCode>
<ScaleAxisStepIntervalBoundaryTypeName
languageCode="EN">Basescale
</ScaleAxisStepIntervalBoundaryTypeName>
<Quantity unitCode="EA">11.0</Quantity>
<QuantityTypeCode>EA</QuantityTypeCode>
<QuantityTypeName languageCode="EN">ea
</QuantityTypeName>
</FirstDimensionScaleAxisStep>
<BaseQuantity unitCode="EA">1.0</BaseQuantity>
<BaseQuantityTypeCode>EA</BaseQuantityTypeCode>
<BaseQuantityTypeName languageCode="EN">ea
</BaseQuantityTypeName>
<Amount currencyCode="USD">90.0</Amount>
</ScaleLine>
<ScaleLine>
<FirstDimensionScaleAxisStep>
<ScaleAxisBaseCode>1</ScaleAxisBaseCode>
<ScaleAxisBaseName languageCode="EN">Quantity
</ScaleAxisBaseName>
<ScaleAxisStepIntervalBoundaryTypeCode>1
</ScaleAxisStepIntervalBoundaryTypeCode>
<ScaleAxisStepIntervalBoundaryTypeName
languageCode="EN">Basescale
</ScaleAxisStepIntervalBoundaryTypeName>
<Quantity unitCode="EA">22.0</Quantity>
<QuantityTypeCode>EA</QuantityTypeCode>
<QuantityTypeName languageCode="EN">ea
</QuantityTypeName>
</FirstDimensionScaleAxisStep>
<BaseQuantity unitCode="EA">1.0</BaseQuantity>
<BaseQuantityTypeCode>EA</BaseQuantityTypeCode>
<BaseQuantityTypeName languageCode="EN">ea
</BaseQuantityTypeName>
<Amount currencyCode="USD">80.0</Amount>
</ScaleLine>
</PriceSpecification>
<SalesPriceSpecificationProcessingConditions>
<ReturnedQueryHitsNumberValue>100</ReturnedQueryHitsNumberValue>
<MoreHitsAvailableIndicator>true</MoreHitsAvailableIndicator>
<LastReturnedObjectID>0000000000011ED19BA19C9A3983CF4D</LastReturnedObjectID>

</SalesPriceSpecificationProcessingConditions>
</SalesPriceListFindByIDResponseMessage>
</nm:SalesPriceListFindByIDResponse_sync>
</soap-env:Body>
</soap-env:Envelope>

 

Sample Subsequent Request Payload (will return the next page of 100 records)


<SalesPriceList>
<ID>PRICELIST_DC_PC</ID>
<SalesPriceSpecificationProcessingConditions>
<QueryHitsMaximumNumberValue>100</QueryHitsMaximumNumberValue>
<QueryHitsUnlimitedIndicator>false</QueryHitsUnlimitedIndicator>
<LastReturnedObjectID>0000000000011ED19BA19C9A3983CF4D</LastReturnedObjectID>
</SalesPriceSpecificationProcessingConditions>
</SalesPriceList>

Note: repeat the above steps till the response returns <MoreHitsAvailableIndicator>false</MoreHitsAvailableIndicator>