SAP SIC_S_NODE_FIELDS Node fields and normalization type Table data and field list

SIC_S_NODE_FIELDS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Node fields and normalization type" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_SIC_S_NODE_FIELDS TYPE SIC_S_NODE_FIELDS.

The SIC_S_NODE_FIELDS table consists of various fields, each holding specific information or linking keys about Node fields and normalization type data available in SAP. These include MANDT (Client), OWNER (Owner of Table Entries (Namespace Separation)), APPLICATION (Application), OBJECT_TYPE (Object Type)... 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_S_NODE_FIELDS structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP SIC_S_NODE_FIELDS structure 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_S_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
NORM_TYPE	Normalization Type	SIC_NORM_TYPE	CHAR	20			SIC_NORM_TYPE

Key field

Non-key field

< SIC_S_MESSAGE_TYPE_COUNTER - Counters for messages of all types SIC_S_NORMALIZED_FIELD - Normalized field value >

How do I retrieve data from SAP structure SIC_S_NODE_FIELDS using ABAP code?

As SIC_S_NODE_FIELDS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on SIC_S_NODE_FIELDS as there is no data to select.

How to access SAP table SIC_S_NODE_FIELDS

Within an ECC or HANA version of SAP you can also view further information about SIC_S_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).