SAP table TNODEIMG (Node table for the new IMG)
SAP table TNODEIMG has 4 primary key fields being TREE_ID,EXTENSION,NODE_ID,EXT_KEY.
| Field |
Description |
Data Type |
Length |
Decimals |
Checktable |
Data Element |
|
| TREE_ID |
Unique ID - 32 characters |
CHAR |
32 |
0 |
|
HIER_GUID
|
|
| EXTENSION |
Structure enhancement ID |
CHAR |
15 |
0 |
*
|
HIER_NAMES
|
|
| NODE_ID |
Unique ID - 32 characters |
CHAR |
32 |
0 |
|
HIER_GUID
|
|
| EXT_KEY |
External key |
CHAR |
12 |
0 |
|
HIER_TREE
|
|
| PARENT_ID |
Unique ID - 32 characters |
CHAR |
32 |
0 |
|
HIER_GUID
|
|
| BROTHER_ID |
Unique ID - 32 characters |
CHAR |
32 |
0 |
|
HIER_GUID
|
|
| REFNODE_ID |
Unique ID - 32 characters |
CHAR |
32 |
0 |
|
HIER_GUID
|
|
| REFTREE_ID |
Unique ID - 32 characters |
CHAR |
32 |
0 |
|
HIER_GUID
|
|
| NODE_TYPE |
Valid Node Types in Structure Repository |
CHAR |
4 |
0 |
TNODEH
|
HIER_NODET
|
|
| LOCAL_FLAG |
Local use: Must not be referenced |
CHAR |
1 |
0 |
|
HIER_LOCAL
|
|
| VALID_F_R |
Release of SAP System |
CHAR |
4 |
0 |
|
SYSAPRL
|
|
| VALID_T_R |
Release of SAP System |
CHAR |
4 |
0 |
|
SYSAPRL
|
|
| VALID_F_D |
System Date |
DATS |
8 |
0 |
|
SYDATUM
|
|
| VALID_T_D |
System Date |
DATS |
8 |
0 |
|
SYDATUM
|
|
| W_SUBNODES |
Flag with values ' ' and 'X' |
CHAR |
1 |
0 |
|
HIER_YESNO
|
|
Not valid; not selected |
| X |
Valid; selected |
|
| APPL_FLAG1 |
Flag: Use by application only |
CHAR |
1 |
0 |
|
HIER_AFLAG
|
|
| APPL_FLAG2 |
Flag: Use by application only |
CHAR |
1 |
0 |
|
HIER_AFLAG
|
|
| APPL_FLAG3 |
Flag: Use by application only |
CHAR |
1 |
0 |
|
HIER_AFLAG
|
|
| COPY_NODE |
Unique ID - 32 characters |
CHAR |
32 |
0 |
|
HIER_GUID
|
|
| COPY_TREE |
Unique ID - 32 characters |
CHAR |
32 |
0 |
|
HIER_GUID
|
|
| COPNODFRST |
Unique ID - 32 characters |
CHAR |
32 |
0 |
|
HIER_GUID
|
|
| COPTREFRST |
GUID for Structure |
CHAR |
32 |
0 |
|
HIER_TREEG
|
|
| COMPONENT |
Technical Description of Logical Components |
CHAR |
30 |
0 |
*
|
SYSDLVUNIT
|
|
| SYSTEMINST |
Code for an Assigned System Landscape in Project |
CHAR |
20 |
0 |
*
|
SYSTEMINST
|
|
| COMPRELFR |
SAP Release |
CHAR |
10 |
0 |
|
SAPRELEASE
|
|
| COMPRELTO |
SAP Release |
CHAR |
10 |
0 |
|
SAPRELEASE
|
|
| DEFAULTFLG |
Flag with values ' ' and 'X' |
CHAR |
1 |
0 |
|
HIER_YESNO
|
|
Not valid; not selected |
| X |
Valid; selected |
|
| PRDVERSFR |
Component Release |
CHAR |
20 |
0 |
|
SBORPV_FRM
|
|
| PRDVERSTO |
Component Release |
CHAR |
20 |
0 |
|
SBORPV_TO
|
|
| FUSER |
Created By |
CHAR |
12 |
0 |
|
HIER_FUSER
|
|
| FDATE |
Created On |
DATS |
8 |
0 |
|
HIER_FDATE
|
|
| FTIME |
Created at |
TIMS |
6 |
0 |
|
HIER_FTIME
|
|
| FRELEASE |
Release of SAP System |
CHAR |
4 |
0 |
|
SYSAPRL
|
|
| LUSER |
Last Changed By |
CHAR |
12 |
0 |
|
HIER_LUSER
|
|
| LDATE |
Last Changed On |
DATS |
8 |
0 |
|
HIER_LDATE
|
|
| LTIME |
Time of Last Change |
TIMS |
6 |
0 |
|
HIER_LTIME
|
|
| LRELEASE |
Release of SAP System |
CHAR |
4 |
0 |
|
SYSAPRL
|
|
TNODEIMG foreign key relationships
| Table |
Field |
Check Table |
|
Check Field |
| 0 TNODEIMG |
NODE_TYPE |
TNODEH |
List of valid node types |
NODE_TYPE |