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
|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
CALL FUNCTION 'RV_PRODUKTHIERARCHIE_PRED_GET'
spras = sy-langu
node = lv_prodh
disp_t179 = lt_prdha
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
WHERE MATNR = IV_MATNR
" Get Product Hierarchy Description
SELECT SINGLE VTEXT
WHERE PRODH = LV_PRODH
AND SPRAS = SY-LANGU.