The DFTNODE01 table in SAP ERP or S/4HANA stores Structure repository for process model objects: Node table data. There are total 37 fields in DFTNODE01 table. The Structure repository for process model objects: Node table 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 DFTNODE01 table. It is in Maintenance of Reference Structure and Processes (SDFM) ABAP package and is part of the Business Navigator (BC-CUS-TOL-NAV) module.
SAP DFTNODE01 Table Fields
Following is the list of fields that are available in SAP DFTNODE01 table. The primary key fields of the table are TREE_ID (Unique ID – 32 characters), EXTENSION (Structure enhancement ID), NODE_ID (Unique ID – 32 characters), EXT_KEY (External key).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| TREE_ID | Unique ID – 32 characters | HIER_GUID | CHAR (32) | |
| EXTENSION | Structure enhancement ID | HIER_NAMES | * | CHAR (15) |
| NODE_ID | Unique ID – 32 characters | HIER_GUID | CHAR (32) | |
| EXT_KEY | External key | HIER_TREE | CHAR (12) | |
| PARENT_ID | Unique ID – 32 characters | HIER_GUID | CHAR (32) | |
| BROTHER_ID | Unique ID – 32 characters | HIER_GUID | CHAR (32) | |
| REFNODE_ID | Unique ID – 32 characters | HIER_GUID | CHAR (32) | |
| REFTREE_ID | Unique ID – 32 characters | HIER_GUID | CHAR (32) | |
| NODE_TYPE | Valid Node Types in Structure Repository | HIER_NODET | TNODEH | CHAR (4) |
| LOCAL_FLAG | Local use: Must not be referenced | HIER_LOCAL | CHAR (1) | |
| VALID_F_R | Release of SAP System | SYSAPRL | CHAR (4) | |
| VALID_T_R | Release of SAP System | SYSAPRL | CHAR (4) | |
| VALID_F_D | System Date | SYDATUM | DATS (8) | |
| VALID_T_D | System Date | SYDATUM | DATS (8) | |
| W_SUBNODES | Flag with values ‘ ‘ and ‘X’ | HIER_YESNO | CHAR (1) | |
| APPL_FLAG1 | Flag: Use by application only | HIER_AFLAG | CHAR (1) | |
| APPL_FLAG2 | Flag: Use by application only | HIER_AFLAG | CHAR (1) | |
| APPL_FLAG3 | Flag: Use by application only | HIER_AFLAG | CHAR (1) | |
| COPY_NODE | Unique ID – 32 characters | HIER_GUID | CHAR (32) | |
| COPY_TREE | Unique ID – 32 characters | HIER_GUID | CHAR (32) | |
| COPNODFRST | Unique ID – 32 characters | HIER_GUID | CHAR (32) | |
| COPTREFRST | GUID for Structure | HIER_TREEG | CHAR (32) | |
| COMPONENT | Technical Description of Logical Components | SYSDLVUNIT | * | CHAR (30) |
| SYSTEMINST | Code for an Assigned System Landscape in Project | SYSTEMINST | * | CHAR (20) |
| COMPRELFR | SAP Release | SAPRELEASE | CHAR (10) | |
| COMPRELTO | SAP Release | SAPRELEASE | CHAR (10) | |
| DEFAULTFLG | Flag with values ‘ ‘ and ‘X’ | HIER_YESNO | CHAR (1) | |
| PRDVERSFR | Component Release | SBORPV_FRM | CHAR (20) | |
| PRDVERSTO | Component Release | SBORPV_TO | CHAR (20) | |
| FUSER | Created By | HIER_FUSER | CHAR (12) | |
| FDATE | Created On | HIER_FDATE | DATS (8) | |
| FTIME | Created at | HIER_FTIME | TIMS (6) | |
| FRELEASE | Release of SAP System | SYSAPRL | CHAR (4) | |
| LUSER | Last Changed By | HIER_LUSER | CHAR (12) | |
| LDATE | Last Changed On | HIER_LDATE | DATS (8) | |
| LTIME | Time of Last Change | HIER_LTIME | TIMS (6) | |
| LRELEASE | Release of SAP System | SYSAPRL | CHAR (4) |
