SAP table BUT_HIER_NODE_BP (Business Partner Hierarchy Group - Bus. Partner Assignment)
SAP table BUT_HIER_NODE_BP 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 | ||
| HIER_TYPE_GUID | GUID for Hierarchy Category of BP Group Hierarchy | RAW | 16 | 0 | BUT_HIER_TYPE | BU_HIERARCHY_TYPE_GUID | |
| PARTNER_GUID | Business Partner GUID | RAW | 16 | 0 | BU_PARTNER_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 | ||
| NODE_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_NODE_BP foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 BUT_HIER_NODE_BP | CLIENT | T000 | Clients | MANDT |
| 1 BUT_HIER_NODE_BP | HIER_TYPE_GUID | BUT_HIER_TYPE | Business Partner Group Hierarchy Category (GUID) | CLIENT |
| 0 BUT_HIER_NODE_BP | NODE_GUID | BUT_HIER_NODE | Business Partner Hierarchy Group | NODE_GUID |