SAP Table SDOKNODE

SDOK: Node table for general structure repository

The table SDOKNODE (SDOK: Node table for general structure repository) is a standard table in SAP ERP. It belongs to the package SDOK.

Technical Information

Table	SDOKNODE
Short Text	SDOK: Node table for general structure repository
Package	SDOK
Table Type	Transparent Table

Fields for Table SDOKNODE

Field Name	Key	Description	Data Element	Type	Length	Check Table
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