The CUSTNODE table in SAP ERP or S/4HANA stores Node Table for General Structure Storage data. There are total 37 fields in CUSTNODE table. The Node Table for General Structure Storage 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 CUSTNODE table. It is in Info Repository tables for Information Workbench (SIW1) ABAP package and is part of the Knowledge Warehouse (KM-KW) module.
SAP CUSTNODE Table Fields
Following is the list of fields that are available in SAP CUSTNODE 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 | * | 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) |
