Prepare and sync product hierarchy

  • 1 minute(s) read
Prev Next

In SAP ERP, material hierarchies represent structured relationships between materials and material groups, organized in a tree-like format. This structure helps group materials by common attributes, such as brand, category, or market segment.

Zilliant CPQ imports this hierarchy data and converts it into a structured product category model. During synchronization, CPQ preserves the parent-child relationships defined in ERP so that users can navigate and configure products with the same logical groupings used in ERP.

To sync product hierarchy:

  1. Prepare product hierarchy for sync.

  2. Synchronize product hierarchy.

Prepare product hierarchy 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.

In SAP ERP, material hierarchies are maintained in the V_T179 view, which stores the content of the underlying table T179.

To define material hierarchy in SAP ERP, use the transaction V/76. Each hierarchy node is defined using a hierarchy number:

  • The number is segmented into equal-length prefixes.

  • Each prefix segment defines a level in the hierarchy.

For example, in the following image, the hierarchy number is in the Product Hierarchy column, and the product hierarchy level is in the Level no. column. The 00100 value in the Product Hierarchy column is a prefix that represents Level 1 products, and 0010000100 (two prefixes) represents Level 2 products.

Sample product hierarchy in SAP ERP

Synchronize product hierarchy

To synchronize product hierarchy:

  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 Data Management.

  4. In the ERP Data Synchronization section, set the Product Hierarchy switch to YES.

  5. From the bottom button bar, select Synchronize.

When product hierarchy data is synchronized:

  • Each hierarchy number from SAP ERP becomes a product category object name in CPQ.

  • Descriptions from ERP are used as labels in CPQ.

  • Parent-child relationships are inferred based on the prefix structure to maintain the hierarchy depth.