Skip to Content
Product Information
Author's profile photo Murthy V
Murthy V
November 3, 2020 7 minute read

Price List and Discount List Read with Pagination in SAP Business ByDesign Cloud ERP

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>

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.