Main SAP Product Hierarchy Tables and Quick Tips

SAP Product hierarchy tables stored the PH is an alphanumeric character string used for grouping materials.

In the standard SAP system, a product hierarchy can be created with up to three levels, each with a specific number of characters. Each level signifies a certain characteristic of the product. (source)

You find here the list of the main SAP Product Hierarchy Tables and some quick tips working with PH.

T179 is a standard SAP Table which is used to store Materials: Product Hierarchies information. This is available within R/3 SAP systems depending on the version and release level.

Here the main field of Materials: Product Hierarchies

  • T179-PRODH: Product hierarchy
  • T179-STUFE: Number of the level in the product hierarchy

SAP Product Hierarchy Description Table

The Description of SAP Product Hierarchy is stored in the standard table T179T by language.

SAP Product Hierarchy Level Table

The Level of Product Hierarchy in SAP ECC is stored also in the table T179. The level corresponds to the field T179-STUFE.

SAP Product Hierarchy Tables in SAP CRM

Regarding SAP CRM (Customer Relationship Management), the main SAP Product Hierarchy tables are:

  • COMM_HIERARCHY: Hierarchy
  • COMM_CATEGORY: Category

You may want to check also How to Update SAP Product Hierarchy Category on SAP CRM with full ABAP Code

List of SAP Product Hierarchy Tables

Here the completed list of SAP Product Hierarchy Tables

SAP Tables Description
T179 Materials: Product Hierarchies
T179T Materials: Product hierarchies: Texts

SAP Product Hierarchy Quick Tips

How to Read All Product Hierarchy Levels with Description in ABAP ?

If you want to read all SAP Product Hierarchy levels with Description, you can use the standard Function module RV_PRODUKTHIERARCHIE_PRED_GET with

  • SPRAS: language on which you want the description
  • NODE: Product hierarchy id

Retrieve SAP Product Hierarchy Description of a Material

If you want to retrieve using ABAP the description of a SAP Material’s Product Hierarchy, just 2 selects are enough to get the information.
The main join is T179 – PRODH = MVKE – PRODH.

Here the ABAP Snippets to do :