Field Mapping

This section explains how fields are mapped between a sales quote in SAP Cloud for Customer and a quote in SAP CPQ.

Quote ID

The ID of a sales quote is mapped with the quote composite number in SAP CPQ.

Currency, Market and Pricebook

A Distribution Chain Code consists of the Sales Organization Code and the Distribution Channel Code separated by an underscore. The Sales Organization corresponds to the SAP CPQ Market Code and the Distribution Channel corresponds to the same name field on the SAP CPQ pricebook.
The currency contains a currency 3-digit ISO code. The Sales Organization and Currency are used for market determination, and then Distribution Channel is used for pricebook determination.
Market and pricebook resolution is done by respecting SAP CPQ visibility rules for markets and pricebooks. If multiple pricebooks match the criteria, they are sorted by the pricebook level and the one with the highest level (Level 1) is selected.
If the Distribution Chain is empty, the SAP CPQ default market and pricebook will be used, and if the Distribution Chain is provided, but not valid, an error will appear and the CPQ quote will not be created.
The following error messages can appear in connection to the Distribution Chain:

  • Distribution Chain provided, but currency missing: Currency code is not provided.
  • Distribution Chain in invalid format: Distribution Chain is not in valid format.
  • Market not found: Matching market not found for the provided distribution chain and currency.
  • Pricebook not found: Matching pricebook not found for the provided distribution chain and currency.
  • Pricebook found, but not available to the current user: Pricebook matching the provided distribution chain and currency is not available.

Consequently, to enable users to create quotes, administrators should make these adjustments in the SAP CPQ Setup:

  1. Create a currency that exists in SAP Cloud for Customer.
  2. Create a market with the previously created currency. The market’s code should match the code of the Sales Organization in SAP Cloud for Customer.
  3. Create a pricebook in the existing market. Manually enter the Distribution Channel Code on the pricebook. Pricebook entries are replicated via the API from SAP ERP.

Effective Date

ISO formatted date string (YYYY-MM-DD) that is mapped with the Pricing Date in SAP Cloud for Customer.

DocumentTypeCode

The quote standard field DocumentTypeCode is a four letters value (for example, ZCPQ) and refers to the quote document type in SAP Cloud for Customer. This field is not displayed on the user interface, but it can be fetched via the CTX, as <*CTX( Quote.DocumentTypeCode )*>, and via scripting, as Quote.DocumentTypeCode. This field is not used in SAP CPQ, it is only forwarded to SAP ERP when the Place Order to ERP action is called.

Origin

The field Origin contains the name of the external system if a quote is related with an external quote. For quotes that contain SAP Cloud for Customer sales quote reference, the value is C4C-SalesQuote. The field is not visible on the user interface, but it is exposed through scripting as Quote.ExternalQuoteOrigin (retrieves the value of the field).

Cart Comment

Maps to External Note in SAP Cloud for Customer. CPQ quote comment has a limit of 3000 characters, and if the received value is longer, it will be truncated.

Custom Fields

  • PO Number - contains the ID of the external document corresponding to the sales quote, for example, the Order ID from the customer's system. This custom field is editable in SAP CPQ. Maps to External Reference.
  • Requested Date - contains the requested delivery date connected with the shipping. It is an ISO formatted date string (YYYY-MM-DD). This custom field is editable in SAP CPQ. Maps to Requested Date in SAP Cloud for Customer.
  • Quote Expiration Date - maps to Valid To in SAP Cloud for Customer. A custom field in SAP CPQ that already exists on all tenants. It is an ISO formatted date string (YYYY-MM-DD). This custom field is editable in SAP CPQ.

If a custom field is in an invalid format, an appropriate error message will be displayed to the user and the SAP CPQ quote will not be created.
If a custom field cannot be found, the SAP CPQ quote will be created and a warning message will be displayed to the user: Quote custom field FieldName could not be set. Custom field could not be found.

Additional Discount

Additional discount in SAP CPQ is different from the header discount in SAP Cloud for Customer and therefore it is removed from SAP CPQ. The difference is that the additional discount in SAP CPQ is not propagated to items like the discount in SAP Cloud for Customer.
However, the discount feature is still enabled in SAP CPQ. Users can add a discount for product types which is then propagated to items. This value is reflected in the Overall Discount Percent field in the Subtotal section on quotes.

More Information
You are here: SAP Sales Cloud CPQ Online HelpAdmin Page HelpIntegrationsSAP Cloud for Customer IntegrationSAP Cloud for Customer - CPQ IntegrationUser Journey from SAP Cloud for Customer to SAP CPQField Mapping