SAP Information Consistency Tables
Are you looking for the right table related to SAP Information Consistency Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Information Consistency (BC-EIM-IQM-IC) module.
Top 10 tables in Information Consistency
| Table | Description |
|---|---|
| SIC_NORM_TYPES | Normalization types |
| SIC_INDEX_MAIN | Define the art of indexing for business objects |
| SIC_FLDGRP_FIELD | Field grouping |
| SIC_FLDGRP_PROF | Field grouping: profiles |
| SIC_BADI_PROFILE | Profiles for BAS - BAdI implementations |
| SIC_NORM_CASECON | Rules for Case Conversion |
| ICM_DUPL_RULESET | Rulesets for ICM Duplicate Check |
| SIC_NORM_CASECOT | Descriptions for Rules for Case Conversion |
| ICM_DUPL_ENTITYT | Duplicte Check Entity Type |
| ICM_DUPL_ENTITY | Duplicte Check Entity Type |
List of tables in Information Consistency
| Table | Description |
|---|---|
| SIC_NORM_TYPES | Normalization types |
| SIC_INDEX_MAIN | Define the art of indexing for business objects |
| SIC_FLDGRP_FIELD | Field grouping |
| SIC_FLDGRP_PROF | Field grouping: profiles |
| SIC_BADI_PROFILE | Profiles for BAS - BAdI implementations |
| SIC_NORM_CASECON | Rules for Case Conversion |
| ICM_DUPL_RULESET | Rulesets for ICM Duplicate Check |
| SIC_NORM_CASECOT | Descriptions for Rules for Case Conversion |
| ICM_DUPL_ENTITYT | Duplicte Check Entity Type |
| ICM_DUPL_ENTITY | Duplicte Check Entity Type |
| SIC_NORM_ANORMRV | Assignment of Variables in Attribute Normalizing Rules |
| SIC_FLDGRP_PROFT | Field grouping: profiles (text table) |
| SIC_NORM_FORMCCV | Values of Constants for Conditions |
| SIC_BAS_FIELDS | Definition of Fields from BAS for Indexing |
| SIC_NORM_FORMC | Conditions for Condition Types using Formula Editor |
| SIC_NORM_CONDRU | Conditional Rules |
| SIC_NORM_TOKEN0T | Descriptions to Rules for Simple Tokenization |
| SIC_NODE_STRUCT | Definition of the node hierarchy |
| SIC_PROFILE_NAME | Definition of Profile Names |
| SIC_SRC_RETRIEVE | Search: Retrieve fields from the search engine |
| SIC_NORM_REGEX | Basic Rules to Rule Type REGEX (CL_SIC_NORM_REGEX) |
| SIC_NORM_CONDRIT | Descriptions for Variables of Conditional Rules |
| ICM_DISP_DUPL | Display Fields for ICM Duplicate Check |
| SIC_NORM_CONDRUR | Conditional Rules |
| SIC_SRV_PROFTYPE | Definition of Profile Types for Services |
| SIC_NODE_FIELDS | Definition of Fields per Node |
| SIC_NORM_FORMCT | Descriptions for Conditions |
| SIC_PROF_TYPES_T | Descriptive texts for profile types |
| SIC_SERV_CNTTYPE | Definition of Container Content Types for Services |
| SIC_CROSS_INDEX | Definition of cross client object types |
| SIC_SERVICE_DEFT | Definition of ICM Services - Descriptions |
| SIC_FM_PROFILET | Text table for the profiles to be used for fine matching |
| SIC_SRC_PROF | Search: Profiles |
| SIC_INDEX_FIELDS | Define the fields to be indexed for business application |
| SIC_PROF_TYPES | Definition of Profile Types for Services |
| SIC_NORM_NORMSGT | Descriptions for Fieldgroups |
| SIC_NORM_TOKSETV | Table for Sets of Tokens |
| SIC_NORM_FORMCCO | Constants for Condition Types |
| SIC_SERVICE_CMP | Definition of ICM Service Composition |
| SIC_INDEX_PROF | Define the profiles to be used for indexing |
| SIC_FM_PROFILES | Fine Match: Definition of Service Profiles |
| SIC_NORM_ANORMRI | Variables for Attribute Normalizing Rules |
| SIC_NORM_TOKEN0 | Rules for Simple Tokenization (CL_SIC_NORM_SIMPLE_TOKENIZE) |
| SIC_NORM_CONDRUC | Variables Assignment of Conditions |
| SIC_NORM_BRTYIT | Descriptioins for Interface Variables for Basic Rule Types |
| SIC_CONNECTORS | Definition of Connector Implementations |
| SIC_APP_PROFTYPE | Definition of Profile Types for Applications |
| SIC_NORM_NORMSTF | Fieldgroups |
| SIC_CONNECTORS_T | Descriptive texts for connectors |
| SIC_NORM_CONDTIT | Descriptions for Interface Variables for Condition Types |
| SIC_INDEX_CONFIG | Indexing Control in the Duplicate Check |
| SIC_NORM_BRTYT | Descriptions for Basic Normalizing Rule Types |
| SIC_NORM_QUACONT | Descriptions to Rules for Quantity Conversions |
| SIC_PROFILE_DATA | Definition of Profile Data |
| ICM_CUST_CONTENT | Maintain packages for content(CRM, ERP Dupl.Check on HANA) |
| SIC_NORM_TYPEST | Descriptions for Normalization types |
| SIC_PROVIDER | Provider services |
| SIC_NORM_ANORMRR | Attribute Normalization Rules: Rules |
| SIC_SIM_DATA | XML Simulation data for unit test |
| SIC_NORM_CONDTYT | Descriptions for Condition Types |
| SIC_FM_NODE_STRC | Fine Match Profiles for node fields |
| SIC_NORM_ANORMRT | Texttable for SIC_NORM_ANORMR |
| SIC_SRC_PROFT | Search: Profiles (text table) |
| SIC_NORM_CONDRUV | Variables Assignment of Conditional Rules |
| SIC_FM_NODE_FLDS | Fine Match Profiles for node fields |
| SIC_INDEX_PROFT | Text table for the profiles to be used for indexing |
| SIC_NORM_CONDRUI | Variables of Conditional Rules |
| SIC_NORM_REGEXR | Basic Rules to Rule Type REGEX (CL_SIC_NORM_REGEX) |
| SIC_NORM_ANORMIT | Interface Variables for Attribute Norm. Rules: Descriptions |
| SIC_NORM_TOKSET | Table for Sets of Tokens |
| SIC_NORM_TOKEN0R | Rules for Simple Tokenization (CL_SIC_NORM_SIMPLE_TOKENIZE) |
| SIC_NORM_CONDRUT | Descriptions for Conditional Rules |
| SIC_NORM_CONDTYI | Interface Variables for Condition Types |
| SIC_NORM_QUACON | Rules for Quantitiy Conversions (C_SIC_NORM_QUANTITIY_C...) |
| SIC_NORM_MSG | Critical Messages of Normaliztion Framework |
| SIC_NORM_CONDTY | Condition Types |
| SIC_NORM_ANORMR | Attribute Normalizing Rules |
| SIC_NORM_BRTYI | Interface Variables for Basic Rule Types |
| SIC_NORM_BRTY | Basic Normalizing Rule Types |
| SIC_SERVICE_GRP | Application server group |
| SIC_SRC_STRATEGY | Search: strategy |
| SIC_NORM_NORMST | Normalizing Strategty |
| SIC_NORM_FORMCTY | Condition Types using Formula Editor |
| SIC_NORM_QUACONR | Rules for Quantity Conversions |
| SIC_NORM_NORMSTT | Texttable to SIC_NORM_NORMST |
| SIC_NORM_NORMSTR | Object Normalization Strategy: Rules |
| SIC_NORM_NORMSTG | Fieldgroups |
| SIC_NORM_REGEXT | Descriptions for Regular Expressions |
| SIC_NORM_NORMSTV | Assignment of Object Attributes to Rule Variables |
| SIC_NORM_SETTING | Settings for Normalization |
| SIC_NORM_TOKSETT | Descriptions for Sets of Tokens |
| SIC_SERVICE_DEF | Definition of ICM Services |