SAP ABAP Table SIC_NORM_ANORMRV (Assignment of Variables in Attribute Normalizing Rules)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-EIM-IQM-IC (Application Component) Information Consistency
     ⤷ S_IC_NORMALIZATION_ENGINE (Package) Information Consolidation Normalization Engine

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SIC_NORM_ANORMRV	Table Relationship Diagram
Short Description	Assignment of Variables in Attribute Normalizing Rules

Delivery and Maintenance

Pool/cluster
Delivery Class	E	Control table, SAP and customer have separate key areas
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	ATTR_NORM_RULE	☑	SIC_NORM_TV_ATTR_NORM_RULE	SIC_NORM_ATTR_NORM_RULE	CHAR	30	0	Attribute Normalizing Rule	SIC_NORM_ANORMRR
3	BASIC_RULE_TYPE	☑	SIC_NORM_TV_BASIC_RULE_TYPE	SIC_NORM_BASIC_RULE_TYPE	CHAR	30	0	Rule Type for Basic Normalizing Rule	SIC_NORM_ANORMRR
4	BASIC_RULE	☑	SIC_NORM_TV_BASIC_RULE	SIC_NORM_BASIC_RULE	CHAR	30	0	Basic Normalizing Rule	SIC_NORM_ANORMRR
5	CONDITIONAL_RULE	☑	SIC_NORM_TV_CONDITIONAL_RULE	SIC_NORM_CONDITIONAL_RULE	CHAR	30	0	Conditional Rule	SIC_NORM_ANORMRR
6	CALL_NR	☑	SIC_NORM_TV_ANORMRR_CALL_NR		INT4	10	0	Call Number of Basic Rule in Attribute Normalizing Rule	SIC_NORM_ANORMRR
7	VAR	☑	SIC_NORM_TV_ANORMRV_VARIABLE	FDNAME	CHAR	30	0	Variable of Basic Rule Type or Conditional Rule	*
8	LOG_VAR	☐	SIC_NORM_TV_ANORMR_VARIABLE	FDNAME	CHAR	30	0	Variable of Attribute Normalizing Rule	SIC_NORM_ANORMRI
9	DEV_NORM_TYPE	☐	SIC_NORM_TV_DEV_NORM_TYPE	XFELD	CHAR	1	0	Deviating Normalization Type
10	NORM_TYPE_IN	☐	SIC_NORM_TV_NORM_TYPE_IN	SIC_NORM_TYPE	CHAR	20	0	Normalization Type
11	NORM_TYPE_OUT	☐	SIC_NORM_TV_NORM_TYPE_OUT	SIC_NORM_TYPE	CHAR	20	0	Normalization Type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SIC_NORM_ANORMRV	ATTR_NORM_RULE	SIC_NORM_ANORMRR	ATTR_NORM_RULE	KEY	1	CN
2	SIC_NORM_ANORMRV	BASIC_RULE	SIC_NORM_ANORMRR	BASIC_RULE
3	SIC_NORM_ANORMRV	BASIC_RULE_TYPE	SIC_NORM_ANORMRR	BASIC_RULE_TYPE	KEY	1	CN
4	SIC_NORM_ANORMRV	CALL_NR	SIC_NORM_ANORMRR	CALL_NR	KEY	1	CN
5	SIC_NORM_ANORMRV	CONDITIONAL_RULE	SIC_NORM_ANORMRR	CONDITIONAL_RULE	KEY	1	CN
6	SIC_NORM_ANORMRV	LOG_VAR	SIC_NORM_ANORMRI	LOG_VAR	KEY	1	CN

History

Last changed by/on	SAP	20110908
SAP Release Created in	710