Synchronize products
  • 25 Sep 2024
  • 1 Minute to read
  • Dark
    Light

Synchronize products

  • Dark
    Light

Article summary

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.

Note

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:

Sample Z_ISS_MAT database view

Apply necessary filter conditions based on the business case to optimize synchronization performance.

Synchronize specific products

  1. Sign in to Zilliant CPQ with your administrator credentials.
  2. From the left navigation area, select System Processes.
  3. From the top navigation bar, select ERP Synchronization.
  4. Above the list of synchronizations, select .
  5. From the Type dropdown list, select MATERIAL.
  6. In the ERP IDs field, enter one or multiple product IDs.
  7. Select Synchronize.

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.