- 25 Sep 2024
- 1 Minute to read
- Print
- DarkLight
Synchronize products
- 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 products, in SAP ERP, create a database view Z_ISS_MAT with columns MANDT, MATNR, and LAEDA based on the MARA table. This view pre-filters products and materials in SAP ERP for Zilliant CPQ synchronization.
The following image shows a sample Z_ISS_MAT database view:
Apply necessary filter conditions based on the business case to optimize synchronization performance.
Synchronize specific products
- 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 MATERIAL.
- In the ERP IDs field, enter one or multiple product IDs.
- Select Synchronize.