KDS_NODE SAP (Node Table for General Structure Storage) Table details

Dictionary Type: Table
Description: Node Table for General Structure Storage




ABAP Code to SELECT data from KDS_NODE
Related tables to KDS_NODE
Access table KDS_NODE




Table field list including key, data, relationships and ABAP select examples

KDS_NODE is a standard SAP Table which is used to store Node Table for General Structure Storage data and is available within R/3 SAP systems depending on the version and release level.

The KDS_NODE table consists of various fields, each holding specific information or linking keys about Node Table for General Structure Storage data available in SAP. These include TREE_ID (Unique ID - 32 characters), EXTENSION (Structure enhancement ID), NODE_ID (Unique ID - 32 characters), EXT_KEY (External key).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: E - Control table, SAP and customer have separate key areas
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP KDS_NODE table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
TREE_IDUnique ID - 32 characters HIER_GUIDCHAR32SYCHAR32
EXTENSIONStructure enhancement ID HIER_NAMESCHAR15Assigned to domainHIER_NAMES
NODE_IDUnique ID - 32 characters HIER_GUIDCHAR32SYCHAR32
EXT_KEYExternal key HIER_TREECHAR12HIER_TREE
PARENT_IDUnique ID - 32 characters HIER_GUIDCHAR32SYCHAR32
BROTHER_IDUnique ID - 32 characters HIER_GUIDCHAR32SYCHAR32
REFNODE_IDUnique ID - 32 characters HIER_GUIDCHAR32SYCHAR32
REFTREE_IDUnique ID - 32 characters HIER_GUIDCHAR32SYCHAR32
NODE_TYPEValid Node Types in Structure Repository HIER_NODETCHAR4Assigned to domainHIER_NODET
LOCAL_FLAGLocal use: Must not be referenced HIER_LOCALCHAR1HIER_YESNO
VALID_F_RRelease of SAP System SYSAPRLCHAR4SYCHAR04
VALID_T_RRelease of SAP System SYSAPRLCHAR4SYCHAR04
VALID_F_DSystem Date SYDATUMDATS8SYDATS
VALID_T_DSystem Date SYDATUMDATS8SYDATS
W_SUBNODESFlag with values ' ' and 'X' HIER_YESNOCHAR1HIER_YESNO
APPL_FLAG1Flag: Use by application only HIER_AFLAGCHAR1CHAR1
APPL_FLAG2Flag: Use by application only HIER_AFLAGCHAR1CHAR1
APPL_FLAG3Flag: Use by application only HIER_AFLAGCHAR1CHAR1
COPY_NODEUnique ID - 32 characters HIER_GUIDCHAR32SYCHAR32
COPY_TREEUnique ID - 32 characters HIER_GUIDCHAR32SYCHAR32
COPNODFRSTUnique ID - 32 characters HIER_GUIDCHAR32SYCHAR32
COPTREFRSTGUID for Structure HIER_TREEGCHAR32SYCHAR32S_TREE_ID
COMPONENTTechnical Description of Logical Components SYSDLVUNITCHAR30Assigned to domainSYSDLVUNIT
SYSTEMINSTCode for an Assigned System Landscape in Project SYSTEMINSTCHAR20Assigned to domainSYSTEMINST
COMPRELFRSAP Release SAPRELEASECHAR10CHAR10
COMPRELTOSAP Release SAPRELEASECHAR10CHAR10
DEFAULTFLGFlag with values ' ' and 'X' HIER_YESNOCHAR1HIER_YESNO
PRDVERSFRComponent Release SBORPV_FRMCHAR20SBORPVNR
PRDVERSTOComponent Release SBORPV_TOCHAR20SBORPVNR
FUSERCreated by HIER_FUSERCHAR12HIER_USER
FDATECreated on HIER_FDATEDATS8SYDATS
FTIMECreated at HIER_FTIMETIMS6SYTIME
FRELEASERelease of SAP System SYSAPRLCHAR4SYCHAR04
LUSERLast changed by HIER_LUSERCHAR12HIER_USER
LDATELast Changed On HIER_LDATEDATS8SYDATS
LTIMETime of Last Change HIER_LTIMETIMS6SYTIME
LRELEASERelease of SAP System SYSAPRLCHAR4SYCHAR04

Key field Non-key field



How do I retrieve data from SAP table KDS_NODE using ABAP code

The following ABAP code Example will allow you to do a basic selection on KDS_NODE to SELECT all data from the table
DATA: WA_KDS_NODE TYPE KDS_NODE.

SELECT SINGLE *
FROM KDS_NODE
INTO CORRESPONDING FIELDS OF WA_KDS_NODE
WHERE...

How to access SAP table KDS_NODE

Within an ECC or HANA version of SAP you can also view further information about KDS_NODE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!