SAP table BUT_HIER_STRUCT (Business Partner Hierarchy Group - Hierarchy Relationship)
SAP table BUT_HIER_STRUCT has 2 primary key fields being CLIENT,RECORD_GUID.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| CLIENT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| RECORD_GUID | GUID of Data Record on Database (ID of Record) | RAW | 16 | 0 | BU_RECORD_GUID | ||
| NODE_GUID | GUID of Hierarchy Node | RAW | 16 | 0 | BUT_HIER_NODE | BU_NODE_GUID | |
| VALID_TO | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | DEC | 15 | 0 | TIMESTAMP | ||
| VALID_FROM | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | DEC | 15 | 0 | TIMESTAMP | ||
| PARENT_GUID | GUID of Hierarchy Node | RAW | 16 | 0 | BUT_HIER_NODE | BU_NODE_GUID | |
| TREE_GUID | GUID of Hierarchy Tree | RAW | 16 | 0 | BUT_HIER_TREE | BU_TREE_GUID |
BUT_HIER_STRUCT foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 BUT_HIER_STRUCT | CLIENT | T000 | Clients | MANDT |
| 1 BUT_HIER_STRUCT | NODE_GUID | BUT_HIER_NODE | Business Partner Hierarchy Group | NODE_GUID |
| 0 BUT_HIER_STRUCT | PARENT_GUID | BUT_HIER_NODE | Business Partner Hierarchy Group | NODE_GUID |