SAP SIC_NORM_SETTING Settings for Normalization Table data and field list

SIC_NORM_SETTING is a standard SAP Table which is used to store Settings for Normalization data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The SIC_NORM_SETTING table consists of various fields, each holding specific information or linking keys about Settings for Normalization data available in SAP. These include SETTING (Settings for Normalization), BRF (Basic Rule Factory is Singleton), CONDF (Condition Factory is Singleton), CONDRULEF (Conditional Rule Factory is Singleton)... 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_NORM_SETTING table Technical Details:

Delivery Class: S - System table, maint. only by SAP, change = modification
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP SIC_NORM_SETTING 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_NORM_SETTING 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
SETTING	Settings for Normalization	SIC_NORM_TV_SETTINGS	CHAR	5
BRF	Basic Rule Factory is Singleton	SIC_NORM_TV_SGLTON_BRF	CHAR	1			XFELD
CONDF	Condition Factory is Singleton	SIC_NORM_TV_SGLTON_CONDF	CHAR	1			XFELD
CONDRULEF	Conditional Rule Factory is Singleton	SIC_NORM_TV_SGLTON_CONDRULEF	CHAR	1			XFELD
RULEEXPLENG	Rule Explosion Engine is Singleton	SIC_NORM_TV_SGLTON_RULEEXPLENG	CHAR	1			XFELD
ATTRNORMRUL	Attribute Normalizing Rule Factory is Singleton	SIC_NORM_TV_SGLTON_ATTRNORMRUL	CHAR	1			XFELD
OBJNORMST	Object Normalizing Strategy Factory is Singleton	SIC_NORM_TV_SGLTON_OBJNORMST	CHAR	1			XFELD

Key field

Non-key field

< SIC_NORM_REGEXT - Descriptions for Regular Expressions SIC_NORM_TOKEN0 - Rules for Simple Tokenization (CL_SIC_NORM_SIMPLE_TOKENIZE) >

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

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

SELECT SINGLE *
FROM SIC_NORM_SETTING
INTO CORRESPONDING FIELDS OF WA_SIC_NORM_SETTING
WHERE...

How to access SAP table SIC_NORM_SETTING

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

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