MX supports product hierarchy data sync from ERP to MX which integrates the hierarchy structure of products as defined in MX. A product hierarchy is a modelling of the hierarchical relationships between products in a tree structure. This enables the grouping of products and defines the relationship between products and product groups at different hierarchy levels.
This hierarchical structure of product groups is used by MX to define a product category hierarchy where products in MX can be assigned to these product groups while preserving the hierarchical relationships as defined in ERP.
To start a product category data synchronization go to:
Administration-> Data Management -> ERP Data Synchronization -> Product Hierarchy Switch
Product Hierarchy in ERP
Product hierarchy can be defined using transaction code v/76 in ERP that is used to maintain the contents of V_T179 database table.
Levels in the product hierarchy are recorded by the sequence of digits within a hierarchy number. The hierarchy number is the number in the Product Hierarchy column, with each number having a maximum of 18 digits. The number of digits in the hierarchy number decides the level of the product. The hierarchical relationship is defined by the hierarchy number having the same sequence of digits as a prefix. The screenshot above shows the hierarchical relationship between product groups where “00100” is a first level product group and “0010000100” being the second level child of “00100”.
In the sync of product hierarchy data from ERP to MX, the hierarchy number is loaded as the object name of the product category and the description is loaded as the label of this product category. Each level of hierarchy is also preserved by having a parent child relationship between product categories.