The COMM_HIERARCHY table in SAP ERP or S/4HANA stores Hierarchy data. There are total 13 fields in COMM_HIERARCHY table. The Hierarchy table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of COMM_HIERARCHY table. It is in Category: Definition of Hierarchies (COM_HIERARCHY) ABAP package and is part of the Central Part of Product Master (AP-MD-PRO) module.
SAP COMM_HIERARCHY Table Fields
Following is the list of fields that are available in SAP COMM_HIERARCHY table. The primary key fields of the table are CLIENT (Client), HIERARCHY_GUID (Category Hierarchy GUID).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | * | CLNT (3) |
| HIERARCHY_GUID | Category Hierarchy GUID | COMT_HIERARCHY_GUID | RAW (16) | |
| HIERARCHY_ID | Category Hierarchy ID | COMT_HIERARCHY_ID | CHAR (10) | |
| ROOT_CAT_GUID | Category GUID | COMT_CATEGORY_GUID | RAW (16) | |
| SCHEME_GUID | Numbering Scheme GUID | COMT_SCHEME_GUID | RAW (16) | |
| CAT_AUTONUMBER | Automatic Number Assignment | COMT_CAT_AUTONUMBER | CHAR (1) | |
| MULTI_SYS | Hierarchy Contains Categories from Multiple Systems | COMT_MULTI_SYS | CHAR (1) | |
| STANDARD_SCHEMA | Standard Schema Type | SCHEMA_TYPE | BBP_CT_SCMTYPE | CHAR (10) |
| VALID_FROM | Valid From (Time Stamp) | COMT_VALID_FROM | DEC (15) | |
| VALID_TO | Valid To (Time Stamp) | COMT_VALID_TO | DEC (15) | |
| UPNAME | Name of the User Who Last Changed the Set | COMT_UPNAME | CHAR (12) | |
| HISTEX | History Exists | COMT_HISTEX | CHAR (1) | |
| LOGSYS | Original System | COMT_LOGSYS | * | CHAR (10) |
