About product data synchronization
  • 07 Oct 2024
  • 2 Minutes to read
  • Dark
    Light

About product data synchronization

  • Dark
    Light

Article summary

Synchronize product data between SAP ERP and Zilliant CPQ, including:

  • Units of measurement
  • Basic product data (for example, product ID)
  • Product classification data, including classes and their characteristics
  • Product sales text
  • Product variants
  • Sales area
  • Attachments

Zilliant CPQ uses URIs as unique IDs for each object. Such URIs consist of a SAP ERP hostname and a product or object ID. The hostname is defined in the ECC_RFC_DESTINATION destination.

Example

The http://host.prod/800/Product#000000000000123456 product URI consistes of:

  • host.prod—SAP ERP hostname from jco.client.ashost or jco.client.mshost
  • 800—Client from client.client
  • Product—Object type name
  • 123456—Product ID

For products integrated from SAP ERP, the link with their unit of measure is based on the URI. Unit of measure has a similar URI. To link the two together, you must integrate the unit of measure from SAP ERP before integrating the product data.

List of data points extracted from SAP ERP

  • Unit of measure
    • Short text (label) in all maintained languages
    • All units of measurements maintained in SAP ERP
  • Material hierarchy
    • Material hierarchy maintained in SAP ERP
    • Short text (label) in all maintained languages
    • Hierarchy ID mapped to objectERPId
  • Material
    • Products (materials) maintained in SAP ERP
    • Short text (label) in all maintained languages
    • Base texts (description) in all maintained languages
    • Sales text (if enabled)
    • Unit of measurement
    • Product hierarchy (product category)
    • Deletion flag (product status)
    • Material number (mapped to objectERPId)
    • Last change date
    • Division
    • Sales area, including sales org and distribution channel
    • Attachments
  • Classifications
    • Knowledge base classifications in SAP ERP
    • Short text (label) in all maintained languages
    • Long text (description) in all maintained languages
    • Class name mapped to objectName
    • Last change date
  • Characteristics
    • Characteristics in SAP ERP
    • Short text (label) in all maintained languages
    • Characteristic name mapped to objectName
    • Last change date
  • Characteristic values
    • Short text (label) in all maintained languages
    • Characteristic value mapped to objectName
  • Custom table view—Not part of product data synchronization, but useful for syncing any custom or standard table from ERP. For more details, read Internal pricing engine.

List of BAPIs used for product data synchronization

  • RFC_READ_TABLE
  • BAPI_MATERIAL_GET_PRODUCTHIER
  • BAPI_CHARACT_GETDETAIL
  • BAPI_CLASS_READ
  • BAPI_MATERIAL_GETALL
  • CLAF_CLASSIFICATION_OF_OBJECTS
  • COM_CFG_READ_PRODUCT_VARIANT
  • COM_CFG_READ_ALL_PROD_VARIANTS
  • RFC_READ_TEXT

Table used for product data synchronization

MVKE (to get Sales Area information for a product)

Limitations

  • Only hierarchy nodes referenced by products are fetched.
  • Only one material class (class type 001 or another) is considered for classification.
  • Product variants are considered separately.
  • No relationship between hierarchy nodes is maintained during product synchronization.
  • Long texts aren't fetched for characteristic values.
  • Units aren't fetched for characteristics.
  • Class hierarchy information isn't fetched.
  • Inherited characteristics aren't considered during product integration.
  • Time and date characteristics are fetched as string values only.
  • Only binary file attachments are synchronized from SAP ERP.

Terminology relationship between Zilliant CPQ and SAP ERP

Zilliant CPQSAP ERP
Unit of measureUnit of measure
Dynamic attributeCharacteristic
Knowledge baseClassification
Product categoryMaterial hierarchy
ProductMaterial

Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.