- 25 Sep 2024
- 1 Minute to read
- Print
- DarkLight
Sync product class data
- Updated on 25 Sep 2024
- 1 Minute to read
- Print
- DarkLight
Create a database view in SAP ERP
Zilliant CPQ uses database views in SAP ERP to verify what objects, products, classes, and characteristics to synchronize. To create a view in SAP ERP, use transaction SE11.
Database view filters can return duplicate records, since SAP ERP doesn't support the DISTINCT concept when creating views. Duplicates are removed in Zilliant CPQ.
To synchronize product class data, in SAP ERP, create a database view Z_ISS_CLASSES with columns MANDT, CLINT, KLART, CLASS, and VDATU based on the KLAH standard table. This view controls pre-filtering of classes for Zilliant CPQ synchronization.
The following image shows a sample Z_ISS_CLASSES database view:
You can set filter conditions in the Z_ISS_CLASSES database view:
Synchronize specific product classes
- Sign in to Zilliant CPQ with your administrator credentials.
- From the left navigation area, select System Processes.
- From the top navigation bar, select ERP Synchronization.
- Above the list of synchronizations, select .
- From the Type dropdown list, select CLASS.
- In the ERP IDs field, enter one or multiple product IDs.
- Select Synchronize.