Price List and Discount List Read with Pagination ...

murthy_v · ‎2020 Nov 03

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>