SIC_NORM_NORMSTR SAP (Object Normalization Strategy: Rules) Table details
Description: Object Normalization Strategy: Rules
Related tables to SIC_NORM_NORMSTR
Access table SIC_NORM_NORMSTR
Table field list including key, data, relationships and ABAP select examples
SIC_NORM_NORMSTR is a standard SAP Table which is used to store Object Normalization Strategy: Rules data and is available within R/3 SAP systems depending on the version and release level.
The SIC_NORM_NORMSTR table consists of various fields, each holding specific information or linking keys about Object Normalization Strategy: Rules data available in SAP. These include OBJ_NORM_STRAT (Object Normalizing Strategy), ATTR_NORM_RULE (Attribute Normalizing Rule), CALL_NR (Call Number of Attribute Normalizing Rule in Strategy), ORDER_NR (Position of Attribute Normalizing Rule in Strategy).. 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. .
Delivery Class: E - Control table, SAP and customer have separate key areasDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP SIC_NORM_NORMSTR table fields - Full list of fields found in SAP data dictionary
| 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 | |||
| OBJ_NORM_STRAT | Object Normalizing Strategy | SIC_NORM_TV_OBJ_NORM_STRAT | CHAR | 30 | SIC_NORM_NORMST | SIC_NORM_OBJ_NORM_STRAT | |||
| ATTR_NORM_RULE | Attribute Normalizing Rule | SIC_NORM_TV_ATTR_NORM_RULE | CHAR | 30 | SIC_NORM_ANORMR | SIC_NORM_ATTR_NORM_RULE | |||
| CALL_NR | Call Number of Attribute Normalizing Rule in Strategy | SIC_NORM_TV_NORMSTR_CALL_NR | INT4 | 10 | |||||
| ORDER_NR | Position of Attribute Normalizing Rule in Strategy | SIC_NORM_TV_NORMSTR_ORDER_NR | INT4 | 10 | |||||
| INACTIVE | Attribute Normalizing Rule Inactive | SIC_NORM_TV_ATTR_NORM_RULE_IN | CHAR | 1 | XFELD | ||||
| REM_EMPTY_NTYPES | Remove Empty Tokens | SIC_NORM_TV_REM_EMTPY_NTYPES | CHAR | 1 | XFELD |
| Key field | Non-key field |
How do I retrieve data from SAP table SIC_NORM_NORMSTR using ABAP code
The following ABAP code Example will allow you to do a basic selection on SIC_NORM_NORMSTR to SELECT all data from the tableDATA: WA_SIC_NORM_NORMSTR TYPE SIC_NORM_NORMSTR.
SELECT SINGLE *
FROM SIC_NORM_NORMSTR
INTO CORRESPONDING FIELDS OF WA_SIC_NORM_NORMSTR
WHERE...
How to access SAP table SIC_NORM_NORMSTR
Within an ECC or HANA version of SAP you can also view further information about SIC_NORM_NORMSTR and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects