Inbound Service Interface (public)

Description	Query Price Specifications
Name	QuerySalesPriceSpecificationIn
Namespace	http://sap.com/xi/A1S/Global
Process Component Description	Price Master Data Management
Process Component Name	PriceMasterDataManagement
Process Component Namespace	http://sap.com/xi/AP/FO/PriceAndTax/Global
Deploymnent Unit Description	Foundation
Endpoint Activation	By Scoping of Process Component
Operations	Find price specifications using property valuation

Definition

To find a sales price specification, by its type code, property ID and property value.

Business Context and Use

This is the only operation available for the web service and is used to query for price specification such as Base Prices and Customer Specific Prices.

Prerequisites

Refer to generic section PREREQUISITES of service documentation

Integration

The Sales Price Specification Query service is used to search and query Prices such as Base Prices and Customer Specific Prices.

Validity Period

You can search within a particular period. TypeCode=1 means date. The sample XML shows a search for the period Jan 1, 2001 to December 31, 9999.

<ValidityPeriod>
  <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode>
  <StartTimePoint>
    <TypeCode>1</TypeCode>
    <Date>2001–01–01</Date>
  </StartTimePoint>
  <EndTimePoint>
    <TypeCode>1</TypeCode>
    <Date>9999–12–31</Date>
  </EndTimePoint>
</ValidityPeriod>

Info

Note: Date should follow the format YYYY-MM-DD

You can query by creation date time as follows:

<CreationDateTimeInterval> 
  <LowerBoundaryDateTime>2001-01-01T00:00:00Z</LowerBoundaryDateTime> 
  <UpperBoundaryDateTime>9999-12-31T23:59:59Z</UpperBoundaryDateTime> 
</CreationDateTimeInterval>

Info

Note :

CreationDateTimeInterval is an optional parameter. This parameter should be filled, if you want to search for a prices with Creation Date and Time. For more information about the global data type GLOBAL_DateTime, please refer to the GDT Documentation section.

Last Changed Date Time

You can query by last changed date time as follows:

<LastChangedDatetimeInterval> 
  <LowerBoundaryDateTime>2010-01-01T00:00:00Z</LowerBoundaryDateTime> 
  <UpperBoundaryDateTime>2012-12-31T23:59:59Z</UpperBoundaryDateTime> 
</LastChangedDatetimeInterval>

Info

Note :

LastChangedDatetimeInterval is an optional parameter. This parameter should be filled, if you want to search for a sales price specification with last changed Date and Time. For more information about the global data type GLOBAL_DateTime, please refer to the GDT Documentation section.

Structure

Mandatory fields to be passed is Validity Period, PropertyValuation related data and possible values are mentioned below:

Extensibility is not supported by Service operation

Wild card(*) search is support by Service operation

The list of possible values for the fields is listed below:

PriceSpecificationElementTypeCode indicates whether the prices are base prices or customer specific prices

Code List	Description
7PS0	Base Price
7PS1	Customer Specific Price

ReleaseStatusCode indicates whether the price specification has been released or not.

Code List	Description
1	Not Released
2	Partially Released
3	Deprecated
5	Release Canceled

ConsistencyStatusCode indicates whether the price list is consistent or not.

Code List	Description
2	Inconsistent
3	Consistent

PriceSpecificationElementPropertyValuation[1,2,3....10]

There are two set of keys which user have to pass while querying:

Base Prices

KEY	Description
CND_PRODUCT_ID	Product ID
CND_PRODUCT_ID_TYPE_CODE	Internal Key and its value is 1
CND_PRODUCT_TYPE_CODE	Product Type code
CND_SALES_ORG_ID	Sales Organization ID
DISTR_CHANNEL	Distribution Channel

Customer Specific Price

KEY	Description
CND_BUYER_ID	Account ID
CND_PRODUCT_ID	Product ID
CND_PRODUCT_ID_TYPE_CODE	Internal Key and its value is 1
CND_PRODUCT_TYPE_CODE	Product Type code
CND_SALES_ORG_ID	Sales Organization ID
DISTR_CHANNEL	Distribution Channel

Info

Note :

It is not mandatory to pass the value of these keys.

Example

Sample payload to query Base Price

<n0:SalesPriceSpecificationFindByTypeCodeAndPropertyIDAndPropertyValueQuery_sync xmlns:n0= "http://sap.com/xi/SAPGlobal20/Global">

</StartTimePoint>

</EndTimePoint>

</ValidityPeriod>

<PriceSpecificationElementPropertyID>CND_PRODUCT_ID</PriceSpecificationElementPropertyID>

</PriceSpecificationElementPropertyReference>

</PriceSpecificationElementPropertyValuation1>

<PriceSpecificationElementPropertyID>CND_PRODUCT_ID_TYPE_CODE</PriceSpecificationElementPropertyID>

</PriceSpecificationElementPropertyReference>

</PriceSpecificationElementPropertyValuation2>

<PriceSpecificationElementPropertyID>CND_PRODUCT_TYPE_CODE</PriceSpecificationElementPropertyID>

</PriceSpecificationElementPropertyReference>

</PriceSpecificationElementPropertyValuation3>

<PriceSpecificationElementPropertyID>CND_SALES_ORG_ID</PriceSpecificationElementPropertyID>

</PriceSpecificationElementPropertyReference>

</PriceSpecificationElementPropertyValuation4>

<PriceSpecificationElementPropertyID>DISTR_CHANNEL</PriceSpecificationElementPropertyID>

</PriceSpecificationElementPropertyReference>

</PriceSpecificationElementPropertyValuation5>

</SalesPriceSpecFindByTypeCodeAndPropertyIDAndPropertyValueQueryElements>

</n0:SalesPriceSpecificationFindByTypeCodeAndPropertyIDAndPropertyValueQuery_sync>

Sample payload to query Customer Specific Price

<n0:SalesPriceSpecificationFindByTypeCodeAndPropertyIDAndPropertyValueQuery_sync xmlns:n0= "http://sap.com/xi/SAPGlobal20/Global">

</StartTimePoint>

</EndTimePoint>

</ValidityPeriod>

<PriceSpecificationElementPropertyID>CND_PRODUCT_ID</PriceSpecificationElementPropertyID>

</PriceSpecificationElementPropertyReference>

</PriceSpecificationElementPropertyValuation1>

<PriceSpecificationElementPropertyID>CND_PRODUCT_ID_TYPE_CODE</PriceSpecificationElementPropertyID>

</PriceSpecificationElementPropertyReference>

</PriceSpecificationElementPropertyValuation2>

<PriceSpecificationElementPropertyID>CND_PRODUCT_TYPE_CODE</PriceSpecificationElementPropertyID>

</PriceSpecificationElementPropertyReference>

</PriceSpecificationElementPropertyValuation3>

<PriceSpecificationElementPropertyID>CND_SALES_ORG_ID</PriceSpecificationElementPropertyID>

</PriceSpecificationElementPropertyReference>

</PriceSpecificationElementPropertyValuation4>

<PriceSpecificationElementPropertyID>DISTR_CHANNEL</PriceSpecificationElementPropertyID>

</PriceSpecificationElementPropertyReference>

</PriceSpecificationElementPropertyValuation5>

<PriceSpecificationElementPropertyID>CND_BUYER_ID</PriceSpecificationElementPropertyID>

</PriceSpecificationElementPropertyReference>

</PriceSpecificationElementPropertyValuation6>

</SalesPriceSpecFindByTypeCodeAndPropertyIDAndPropertyValueQueryElements>

</n0:SalesPriceSpecificationFindByTypeCodeAndPropertyIDAndPropertyValueQuery_sync>

Description	Find price specifications using property valuation
Name	FindByTypeCodeAndPropertyIDAndPropertyValue
Synchronous	yes

Definition

To find a sales price specification, by its type code, property ID and property value.

Business Context and Use

This is the only operation available for the web service and is used to query for price specification such as Base Prices and Customer Specific Prices.

Prerequisites

Refer to generic section PREREQUISITES of service documentation

Integration

The Sales Price Specification Query service is used to search and query Prices such as Base Prices and Customer Specific Prices.

Validity Period

You can search within a particular period. TypeCode=1 means date. The sample XML shows a search for the period Jan 1, 2001 to December 31, 9999.

<ValidityPeriod>
  <IntervalBoundaryTypeCode>1</IntervalBoundaryTypeCode>
  <StartTimePoint>
    <TypeCode>1</TypeCode>
    <Date>2001–01–01</Date>
  </StartTimePoint>
  <EndTimePoint>
    <TypeCode>1</TypeCode>
    <Date>9999–12–31</Date>
  </EndTimePoint>
</ValidityPeriod>

Info

Note: Date should follow the format YYYY-MM-DD

You can query by creation date time as follows:

<CreationDateTimeInterval> 
  <LowerBoundaryDateTime>2001-01-01T00:00:00Z</LowerBoundaryDateTime> 
  <UpperBoundaryDateTime>9999-12-31T23:59:59Z</UpperBoundaryDateTime> 
</CreationDateTimeInterval>

Info

Note :

Last Changed Date Time

You can query by last changed date time as follows:

<LastChangedDatetimeInterval> 
  <LowerBoundaryDateTime>2010-01-01T00:00:00Z</LowerBoundaryDateTime> 
  <UpperBoundaryDateTime>2012-12-31T23:59:59Z</UpperBoundaryDateTime> 
</LastChangedDatetimeInterval>

Info

Note :

Structure

Mandatory fields to be passed is Validity Period, PropertyValuation related data and possible values are mentioned below:

Extensibility is not supported by Service operation

Wild card(*) search is support by Service operation

The list of possible values for the fields is listed below:

PriceSpecificationElementTypeCode indicates whether the prices are base prices or customer specific prices

Code List	Description
7PS0	Base Price
7PS1	Customer Specific Price

ReleaseStatusCode indicates whether the price specification has been released or not.

Code List	Description
1	Not Released
2	Partially Released
3	Deprecated
5	Release Canceled

ConsistencyStatusCode indicates whether the price list is consistent or not.

Code List	Description
2	Inconsistent
3	Consistent

PriceSpecificationElementPropertyValuation[1,2,3....10]

There are two set of keys which user have to pass while querying:

Base Prices

KEY	Description
CND_PRODUCT_ID	Product ID
CND_PRODUCT_ID_TYPE_CODE	Internal Key and its value is 1
CND_PRODUCT_TYPE_CODE	Product Type code
CND_SALES_ORG_ID	Sales Organization ID
DISTR_CHANNEL	Distribution Channel

Customer Specific Price

KEY	Description
CND_BUYER_ID	Account ID
CND_PRODUCT_ID	Product ID
CND_PRODUCT_ID_TYPE_CODE	Internal Key and its value is 1
CND_PRODUCT_TYPE_CODE	Product Type code
CND_SALES_ORG_ID	Sales Organization ID
DISTR_CHANNEL	Distribution Channel

Info

Note :

It is not mandatory to pass the value of these keys.

Example

Sample payload to query Base Price

<n0:SalesPriceSpecificationFindByTypeCodeAndPropertyIDAndPropertyValueQuery_sync xmlns:n0= "http://sap.com/xi/SAPGlobal20/Global">

</StartTimePoint>

</EndTimePoint>

</ValidityPeriod>

<PriceSpecificationElementPropertyID>CND_PRODUCT_ID</PriceSpecificationElementPropertyID>

</PriceSpecificationElementPropertyReference>

</PriceSpecificationElementPropertyValuation1>

<PriceSpecificationElementPropertyID>CND_PRODUCT_ID_TYPE_CODE</PriceSpecificationElementPropertyID>

</PriceSpecificationElementPropertyReference>

</PriceSpecificationElementPropertyValuation2>

<PriceSpecificationElementPropertyID>CND_PRODUCT_TYPE_CODE</PriceSpecificationElementPropertyID>

</PriceSpecificationElementPropertyReference>

</PriceSpecificationElementPropertyValuation3>

<PriceSpecificationElementPropertyID>CND_SALES_ORG_ID</PriceSpecificationElementPropertyID>

</PriceSpecificationElementPropertyReference>

</PriceSpecificationElementPropertyValuation4>

<PriceSpecificationElementPropertyID>DISTR_CHANNEL</PriceSpecificationElementPropertyID>

</PriceSpecificationElementPropertyReference>

</PriceSpecificationElementPropertyValuation5>

</SalesPriceSpecFindByTypeCodeAndPropertyIDAndPropertyValueQueryElements>

</n0:SalesPriceSpecificationFindByTypeCodeAndPropertyIDAndPropertyValueQuery_sync>

Sample payload to query Customer Specific Price

<n0:SalesPriceSpecificationFindByTypeCodeAndPropertyIDAndPropertyValueQuery_sync xmlns:n0= "http://sap.com/xi/SAPGlobal20/Global">

</StartTimePoint>

</EndTimePoint>

</ValidityPeriod>

<PriceSpecificationElementPropertyID>CND_PRODUCT_ID</PriceSpecificationElementPropertyID>

</PriceSpecificationElementPropertyReference>

</PriceSpecificationElementPropertyValuation1>

<PriceSpecificationElementPropertyID>CND_PRODUCT_ID_TYPE_CODE</PriceSpecificationElementPropertyID>

</PriceSpecificationElementPropertyReference>

</PriceSpecificationElementPropertyValuation2>

<PriceSpecificationElementPropertyID>CND_PRODUCT_TYPE_CODE</PriceSpecificationElementPropertyID>

</PriceSpecificationElementPropertyReference>

</PriceSpecificationElementPropertyValuation3>

<PriceSpecificationElementPropertyID>CND_SALES_ORG_ID</PriceSpecificationElementPropertyID>

</PriceSpecificationElementPropertyReference>

</PriceSpecificationElementPropertyValuation4>

<PriceSpecificationElementPropertyID>DISTR_CHANNEL</PriceSpecificationElementPropertyID>

</PriceSpecificationElementPropertyReference>

</PriceSpecificationElementPropertyValuation5>

<PriceSpecificationElementPropertyID>CND_BUYER_ID</PriceSpecificationElementPropertyID>

</PriceSpecificationElementPropertyReference>

</PriceSpecificationElementPropertyValuation6>

</SalesPriceSpecFindByTypeCodeAndPropertyIDAndPropertyValueQueryElements>

</n0:SalesPriceSpecificationFindByTypeCodeAndPropertyIDAndPropertyValueQuery_sync>

Inbound Service QuerySalesPriceSpecificationIn

Overview

Public Solution Model

Documentation

Definition

Business Context and Use

Prerequisites

Integration

Validity Period

Last Changed Date Time

Structure

PriceSpecificationElementPropertyValuation[1,2,3....10]

Example

Sample payload to query Base Price

Sample payload to query Customer Specific Price

Operation Find by Type Code and Property ID and Property Value

Overview

Public Solution Model

Documentation

Definition

Business Context and Use

Prerequisites

Integration

Validity Period

Last Changed Date Time

Structure

PriceSpecificationElementPropertyValuation[1,2,3....10]

Example

Sample payload to query Base Price

Sample payload to query Customer Specific Price