SAP table BUT_HIER_TREE (Business Partner Group Hierarchy)
SAP table BUT_HIER_TREE has 2 primary key fields being CLIENT,TREE_GUID.
Field |
Description |
Data Type |
Length |
Decimals |
Checktable |
Data Element |
|
CLIENT |
Client |
CLNT |
3 |
0 |
T000
|
MANDT
|
|
TREE_GUID |
GUID of Hierarchy Tree |
RAW |
16 |
0 |
|
BU_TREE_GUID
|
|
HIER_TYPE_GUID |
GUID for Hierarchy Category of BP Group Hierarchy |
RAW |
16 |
0 |
BUT_HIER_TYPE
|
BU_HIERARCHY_TYPE_GUID
|
|
HOME_SYSTEM |
Logical system |
CHAR |
10 |
0 |
|
LOGSYS
|
|
SEARCH_TERM |
Hierarchy Tree ID |
CHAR |
20 |
0 |
|
BU_TREE_SEARCH_TERM
|
|
CREATED_BY |
User Name |
CHAR |
12 |
0 |
|
UNAME
|
|
CHANGED_BY |
User Name |
CHAR |
12 |
0 |
|
UNAME
|
|
CREATED_ON |
UTC Time Stamp in Short Form (YYYYMMDDhhmmss) |
DEC |
15 |
0 |
|
TIMESTAMP
|
|
CHANGED_ON |
UTC Time Stamp in Short Form (YYYYMMDDhhmmss) |
DEC |
15 |
0 |
|
TIMESTAMP
|
|
BUT_HIER_TREE foreign key relationships
Table |
Field |
Check Table |
|
Check Field |
0 BUT_HIER_TREE |
CLIENT |
T000 |
Clients |
MANDT |
1 BUT_HIER_TREE |
HIER_TYPE_GUID |
BUT_HIER_TYPE |
Business Partner Group Hierarchy Category (GUID) |
CLIENT |