Add Multiple T179 Material Product Hierarchies to S/4HANA Embedded Analytics Content

Previously I explained how to create T179 Material Product Hierarchy to S/4HANA Embedded Analytics content. Product hierarchy have multiple hierarchy levels and material leaf node. On reporting users might want to see expanded hierarchy with different number of hierarchy levels above material leaf level. It is only possible with multiple hierarchies. In this blog I will take example from previous blog on a new level adding multiple T179 Material Product hierarchies.

Lets see it action. Here is Level 4 hierarchy

Here the same data for Level 3 hierarchy

To create multiple hierarchies for Material you need to make use of directory:

• Created hierarchy directory CDS view
• Add hierarchy directory CDS view to hierarchy CDS view
• Add hierarchy information to hierarchy node CDS view

Created hierarchy directory CDS view

Add hierarchy directory CDS view to hierarchy CDS view

Add hierarchy information to hierarchy node CDS view

Source for above CDS views can be downloaded from here:

• ZI_MaterialHierDir
• ZI_MaterialHier
• ZI_Material

See also Display Short Material Product Hierarchy Level Keys with ABAP CDS Views blog