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

 CALL FUNCTION 'RV_PRODUKTHIERARCHIE_PRED_GET'
      EXPORTING
           spras               = sy-langu
           node                = lv_prodh
      TABLES
           disp_t179           = lt_prdha
      EXCEPTIONS
           node_does_not_exist = 1
           OTHERS              = 2.

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 :

" Get SAP Product Hierarchy ID for Material
SELECT SINGLE PRODH 
  FROM MVKE 
  INTO LV_PRODH 
  WHERE MATNR = IV_MATNR

" Get Product Hierarchy Description
SELECT SINGLE VTEXT 
  FROM T179T
  INTO LV_VTEXT 
  WHERE PRODH = LV_PRODH
  AND   SPRAS = SY-LANGU.