SAP SIC_NODE_FIELDS Definition of Fields per Node Table data and field list

SIC_NODE_FIELDS is a standard SAP Table which is used to store Definition of Fields per Node data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The SIC_NODE_FIELDS table consists of various fields, each holding specific information or linking keys about Definition of Fields per Node data available in SAP. These include OWNER (Owner of Table Entries (Namespace Separation)), APPLICATION (Application), OBJECT_TYPE (Object Type), OBJECT_SUBTYPE (Object Subtype)... 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. .

SIC_NODE_FIELDS table Technical Details:

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

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

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the SIC_NODE_FIELDS table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
OWNER	Owner of Table Entries (Namespace Separation)	SIC_OWNER	CHAR	3			SIC_OWNER
APPLICATION	Application	SIC_APPLICATION	CHAR	20	SIC_NODE_STRUCTV		CHAR20
OBJECT_TYPE	Object Type	SIC_OBJECT_TYPE	CHAR	30	SIC_NODE_STRUCTV		CHAR30
OBJECT_SUBTYPE	Object Subtype	SIC_OBJECT_SUBTYPE	CHAR	30	SIC_NODE_STRUCTV		CHAR30
NODE_NAME	Node Name	SIC_NODE_NAME	CHAR	30			CHAR30
COUNTER	Counter	SIC_COUNTER	NUMC	4			NUMC4
TABLENAME	Table Name	TABNAME	CHAR	30	Assigned to domain		AS4TAB	DTB
FIELDNAME	Field Name	FIELDNAME	CHAR	30	Assigned to domain		FDNAME	DFD
PRIMARY_ID	Primary ID	SIC_FLAG_PRIMARY_ID	CHAR	1			CHAR1
SECONDARY_ID	Secondary ID	SIC_FLAG_SECONDARY_ID	CHAR	1			CHAR1
INTTYPE	ABAP data type (C,D,N,...)	INTTYPE	CHAR	1			INTTYPE
LENG	Length (No. of Characters)	DDLENG	NUMC	6			DDLENG
DECIMALS	Number of Decimal Places	DECIMALS	NUMC	6			DDLENG
PROPERTY	Field Property	SIC_FIELD_PROPERTY	CHAR	1			SIC_FIELD_PROPERTY
LFIELDNAME	Field name	FNAM_____4	CHAR	132			DYNFNAM

Key field

Non-key field

< SIC_INDEX_PROFT - Text table for the profiles to be used for indexing SIC_NODE_STRUCT - Definition of the node hierarchy >

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

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

SELECT SINGLE *
FROM SIC_NODE_FIELDS
INTO CORRESPONDING FIELDS OF WA_SIC_NODE_FIELDS
WHERE...

How to access SAP table SIC_NODE_FIELDS

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

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