Prepare and sync product dynamic attributes

Zilliant CPQ retrieves product dynamic attributes, known as material characteristics in SAP ERP, using predefined database views. These views define which records should be synchronized. They also help limit data volume to improve performance.

To synchronize dynamic attributes:

1. Prepare dynamic attributes for sync.

2. Synchronize dynamic attributes.

Prepare dynamic attributes for sync

Note

Since this procedure is performed in SAP, not in CPQ, the following steps offer only a high-level overview. For detailed instructions, read the official SAP ERP documentation.

To prepare dynamic attributes for synchronization, create a database view in SAP ERP. This view filters data before you synchronize it to CPQ. Note that database filters might return duplicate records, since SAP ERP views do not support DISTINCT. CPQ deletes duplicates during synchronization.

To create a database view:

1. In SAP ERP, create a database view named Z_ISS_CHARAC using the transaction SE11. This view is based on the standard ERP table CABN.

2. Include the following fields:

   • MANDT—Client number

   • ATINN—Internal characteristic (dynamic attribute) number

   • ADZHL—Characteristic version number

   • ATNAM—Characteristic name

   • VDATU—Changed-on date

3. Apply filters to limit the characteristics (dynamic attributes).

The following images show a sample Z_ISS_CHARAC database view:

The following image shows filters set in the Z_ISS_CHARAC database view:

Synchronize dynamic attributes

Use one of the following methods to sync dynamic attributes:

• Synchronize dynamic attributes automatically with the product

• Synchronize specific product dynamic attributes

Synchronize dynamic attributes automatically with the product

When you synchronize products, CPQ can also automatically retrieve their dynamic attributes. To enable this functionality:

1. Sign in to Zilliant CPQ with your administrator credentials.

2. From the left navigation area, select Administration.

3. From the top navigation bar, select Master Data Management.

4. Move through or search to locate Setting Boolean and select it from the list.

5. Select SettingProductSyncDownloadClassification.

6. Set the Setting Value Boolean switch to YES.

7. Select Save.

Tip

When you enable the SettingProductSyncDownloadClassification setting, CPQ also automatically retrieves each product’s knowledge bases.

Synchronize specific product dynamic attributes

To synchronize a specific dynamic attribute or a list of attributes:

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 CHARACTERISTIC.

6. In the ERP IDs field, enter one or multiple material characteristic IDs (product dynamic attribute IDs) from SAP ERP.

7. Select Synchronize.