- 07 Oct 2024
- 2 Minutes to read
- Print
- DarkLight
About product data synchronization
- Updated on 07 Oct 2024
- 2 Minutes to read
- Print
- DarkLight
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.
The http://host.prod/800/Product#000000000000123456 product URI consistes of:
- host.prod—SAP ERP hostname from
jco.client.ashost
orjco.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 CPQ | SAP ERP |
---|---|
Unit of measure | Unit of measure |
Dynamic attribute | Characteristic |
Knowledge base | Classification |
Product category | Material hierarchy |
Product | Material |