SAP Application Framework. Tables
Are you looking for the right table related to SAP Application Framework. 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 Application Framework. (CA-MDG-CMP-AF) module.
Top 10 tables in Application Framework.
| Table | Description |
|---|---|
| MDC_D_CNFROOT | Root of MDC configuration process - #GENERATED# |
| MDC_PACKAGES | Master Data Consolidation: Packages |
| MDC_CONFIG_BRC | Master Data Consolidation: Configuration for BRC |
| BOB__ASSESS | BoB Assessments |
| MDC_FUZZY_RES | Fuzzy Ruleset result table |
| MDC_KPI_STD_H2 | Historical Table for Address Info Codes |
| MDC_D_CNFSRCSYS | Node SRCSYS of MDC config process - #GENERATED# |
| MDC_MODELCTABLET | Customizing of Texts for Source & Process Data Tables |
| MDC_D_CNFVAL | Node VAL of MDC config process - #GENERATED# |
| MDC_KPI_UPD_H2 | Historical Table for Address Info Codes |
List of tables in Application Framework.
| Table | Description |
|---|---|
| MDC_D_CNFROOT | Root of MDC configuration process - #GENERATED# |
| MDC_PACKAGES | Master Data Consolidation: Packages |
| MDC_CONFIG_BRC | Master Data Consolidation: Configuration for BRC |
| BOB__ASSESS | BoB Assessments |
| MDC_FUZZY_RES | Fuzzy Ruleset result table |
| MDC_KPI_STD_H2 | Historical Table for Address Info Codes |
| MDC_D_CNFSRCSYS | Node SRCSYS of MDC config process - #GENERATED# |
| MDC_MODELCTABLET | Customizing of Texts for Source & Process Data Tables |
| MDC_D_CNFVAL | Node VAL of MDC config process - #GENERATED# |
| MDC_KPI_UPD_H2 | Historical Table for Address Info Codes |
| MDC_ORDER_SRCSYS | MDC: Order of Source Systems for Table |
| MDC_DUPLICATES | Master Data Consolidation: Duplicate Records |
| MDC_CONFIG_ACT | Activation Step Configuration |
| MDC_MATCH_GROUXS | Historical Table for Match Groups |
| MDC_MODEL_SUITE | Model Suites |
| MDC_MAT_CFG_ACTT | Text Table for MDC_MAT_CFG_ACT |
| MDC_MTC_ACTIVE | Group with its minimum active record |
| MDC_D_CNFBRCTAB | Order of Rules per Table - #GENERATED# |
| BOB__ASSESSPLACE | BoB Places Affected By Assessments |
| MDC_BRC_STEP_NO | Master Data Consolidation: Step Number of BRC |
| MDC_R_PROP | Rule Property names |
| MDC_MODEL_TABLET | Texts for Source & Process Data Tables |
| MDC_RULESET_PROP | Search rule set Properties |
| MDC_D_CNFADDRSET | Node ADDRSET of MDC config process - #GENERATED# |
| MDC_D_CNFFUZZY | Node FUZZY of MDC config process - #GENERATED# |
| MDC_MTC_GROUPT | Match groups |
| MDC_IMPORTSTAT | Import Statistics Persistence |
| MDC_D_CNFFIRM | Node FIRM of MDC config process - #GENERATED# |
| MDC_TMPL_ACTROOT | Records Of OTC &OTC, Table &TABLE |
| MDC_RETRY_REF | Remaining references per retry |
| MDC_D_CNFBRCSYS | Order of Source Systems for Table - #GENERATED# |
| MDC_RECENCY_PRC | Precalculated Recencies To Join Into Process Tables |
| MDC_KPI_FAR_H | Historical Table for Filter & Remove KPIs |
| MDC_MATCH_RESULT | Match Results |
| MDC_FABRICPHRASE | Phrases Of Model Related Fabric |
| MDC_MATCH | Master Data Consolidation: Match Groups |
| MDC_D_CNFMTCIMF | IM in HANA firm settings for the Match - #GENERATED# |
| MDC_FABRIC_OTC | Model Related Fabric, BO Type Specific |
| MDC_CONF_MISC | MDC HDB Configuration Miscellaneous System-specific data |
| MDC_D_CNFEVA | Node DQ EVA of MDC config process - #GENERATED# |
| MDC_MATCH_GROU_H | Historical Table for Match Groups |
| MDC_LOADXML | Load Binary XML |
| MDC_PRC_STEPTYPT | MDC Process Step Type |
| MDC_PACKAGES_PRC | Packaged Process Records |
| MDC_CONFIG_EVA_T | Text Table for MDC_CONFIG_EVA |
| MDC_ORDER_RULFLD | MDC: Order of Rules for Field |
| MDC_CONFIG_DES_T | Text Table for MDC_CONFIG_DES |
| MDC_LOAD | Load Persistence |
| MDC_LOADPROCESS | Load Assignment To Process |
| MDC_ANNOTATION | Annotations |
| MDC_TMPL_SRCROOT | Source Root Records Of OTC &OTC, Table &TABLE |
| MDC_D_CNFDEE | Node DEE of MDC config process - #GENERATED# |
| MDC_PRCTYPT | MDC Process Type (Process Template) |
| MDC_DES_PROCESS | Mass Enrichment: Process ID |
| MDC_TMPL_PRCROOT | Process Root Records Of OTC &OTC, Table &TABLE |
| MDC_D_CNFCSTM | Node CSTM of MDC config process - #GENERATED# |
| MDC_CONFIG_FAR | Configuration for Filter & Remove Adapters |
| MDC_RC_ATY | Search rule column attribute types |
| MDC_PRC_STEPTYP | MDC Process Step Type |
| MDC_D_CNFRULTAB | Node RULTAB of MDC config process - #GENERATED# |
| MDC_MATCH_GROUP | Master Data Consolidation: Match Groups |
| MDC_STXH | Table for Storing Long texts |
| MDC_RC_PROP_T | Text Table for MDC_RC_PROP |
| MDC_CONF_DETAIL | MDC HDB Configuration Details |
| MDC_RS_ATTR_T | Text Table for MDC_RS_ATTR |
| MDC_CONFIG_FAR_T | Text Table for MDC_CONFIG_FAR |
| MDC_D_CNFADDR | Node ADDR of MDC config process - #GENERATED# |
| MDC_KPI_UPD_H | Historical Table for Update KPIs |
| MDC_CONFIG_STD_T | Text Table for MDC_CONFIG_STD |
| MDC_RC_ATY_CND_T | Text Table for MDC_RS_ATR_PRP |
| MDC_RECORDTARGET | Targets Of Records In Process |
| MDC_RS_ATTR | Search rule set attributes |
| BOB__ASSESSREALM | BoB Realms Affected By Assessments |
| MDC_FAR_KPIS | Fiilter & Remove Adapter: KPIs |
| MDC_LOADFEED | Load Feed Persistence |
| MDC_NO_MATCH | Master Data Consolidation: Duplicate Records |
| MDC_KPI_VAL_H | Historical Table for Validation KPIs |
| MDC_D_CNFMTCIMA | IM in HANA address settings for the Matc - #GENERATED# |
| MDC_IMPORT | Import Persistence |
| MDC_RULESET_RULE | Search rule set: rules |
| MDC_CONFIG_FUZ_F | Configuration for Fuzzy Rulesets: Fields |
| MDC_MATCH_DES | Mass Enrichment: Search Results |
| MDC_TMPL_PRC | Process Records Of OTC &OTC, Table &TABLE |
| MDC_MODEL_TABLES | Source & Process Data Table Names |
| MDC_D_CNFACT | Node ACT of MDC config process - #GENERATED# |
| MDC_FILTER_KEYT | MDC Step Filter Key Texts |
| MDC_MODELCTABLES | Customizing of Source & Process Data Table Properties |
| MDC_D_CNFBRCFLD | Order of Rules for Field - #GENERATED# |
| MDC_TMPL_STATUS | Status Of Source Records Of OTC &OTC, Table &TABLE |
| MDC_R_PROP_T | Text Table for MDC_R_PROP |
| MDC_RULE_COLUMNS | Search rule columns |
| MDC_RC_ATY_T | Text Table for MDC_RC_ATY |
| MDC_MODIFIED_H | Historical Table for Modified Objects |
| MDC_D_CNFDES | Node DES of MDC config process - #GENERATED# |
| MDC_CONFIG_STD | Configuration for Standardization Adapters |
| MDC_PRCST_BEGRU | MDC Process Step Authorization Group |
| MDC_RS_PROP_VAL | Rule set Property Name & Value Mapping |
| MDC_INJECT_PRC | Inject Data into MDC process |
| MDC_RULECOL_PROP | Search rule column Properties |
| MDC_SCOPETYP | MDC Scope Variant |
| MDC_D_PRCSRC | MDC Process Object Source Node - #GENERATED# |
| MDC_DEFAULTSUSER | Generic User Defaults |
| MDC_RULES | MDC: Rules |
| MDC_TMPL_SRCSTAT | Source Record Status Of OTC &OTC, Table &TABLE |
| MDC_FILTER_VAL | MDC Step Filter Value |
| MDC_MATCH_PKG | Match Groups Package Assignments |
| MDC_PRC_USERS | Process Users |
| MDC_RS_PROP | Rule set Property names |
| MDC_RC_ATY_CND | Rule column Attribute Type & Condition/option names Mapping |
| MDC_MTC_GROUP | Match groups |
| MDC_MODEL_TJOIN | Model Table Joins |
| MDC_D_PRCWLINS | MDC Process Object Work List Insert Node - #GENERATED# |
| MDC_MODIFIED_TAB | Tables For Which Modifications Occured |
| MDC_CONFIG_BRC_T | Text Table for MDC_CONFIG_VAL |
| MDC_D_CNFMTCIMC | IM in HANA cust comp settings for Match - #GENERATED# |
| MDC_TMPL_SRC | Source Records Of OTC &OTC, Table &TABLE |
| MDC_KPI_DES_H | Historical Table for Mass Enrichment: Search KPIs |
| MDC_MTC_LOG | Log matching |
| MDC_D_PRCWLDEL | MDC Process Object Work List Delete Node - #GENERATED# |
| MDC_ORDER_RULTAB | MDC: Order of Rules per Table |
| MDC_KEY_MAP | Key Mapping information for MDG, Consolidation Activation |
| MDC_CONF_HDR_T | Text Table for MDC HDB Configuration Header |
| MDC_PRC_AUDITING | Process Auditing |
| MDC_DEFAULTS | Specification Of Available Defaults Consumers |
| MDC_KPI_EDI_H2 | Historical Table for Field Changes |
| MDC_GOAL_PROP | Process Goal Properties |
| MDC_PRCTYP | MDC Process Type (Process Template) |
| MDC_CONFIG_FUZ | Master Data Consolidation: Configuration for Fuzzy Rulesets |
| MDC_MODEL_SUITED | Model Suite BO Types |
| MDC_PRCTYP_STEPT | MDC Process Type Step Description (Process Template) |
| BOB__REALM | Specifications Of BoB Realms |
| MDC_FABRIC | Model Related Fabric |
| MDC_MISSING_REF | Missing reference IDs (resolvable in process) |
| MDC_CONFIG_FUZ_T | Text Table for MDC_CONFIG_FUZ |
| MDC_PRCST_BEGRUT | MDC Process Step Authorization Group Texts |
| MDC_MTC_SUPDATE | Mapping between source records and update records |
| MDC_RULES_T | MDC: Text Table for MDC_RULES |
| MDC_RULECOL_COND | Search rule column Conditions |
| MDC_CONFIG_UPD | Configuration for Update Adapters |
| MDC_RC_PROP_VAL | Rule column Property Name & Value Mapping |
| MDC_KPI_BRC_H | Historical Table for Best Record Calculation KPIs |
| MDC_FILTER_VALT | MDC Step Filter Value Texts |
| MDC_MODEL_OTC | List Of Modelled OTCs |
| MDC_CONFIG_VAL | Master Data Consolidation: Configuration for Validation |
| MDC_SCOPETYPT | MDC Scope Variant, Description |
| MDC_MODELCOTC | Customizing Of Modelled OTCs |
| MDC_PROCESS_ACT | Activated processes |
| MDC_RULE_PROP | Search rule Properties |
| MDC_MTC_GUPDATE | Old and new match group mapping |
| MDC_CONFIG_VAL_T | Text Table for MDC_CONFIG_VAL |
| MDC_SCOPETYP_FLD | MDC Scope Variant Field |
| MDC_MODEL_FIELDS | Process Data Table Field Names |
| MDC_KPI_ACT_H | Historical Table for Activation KPIs |
| MDC_RC_PROP | Rule column Property names |
| MDC_PRCTYP_STEP | MDC Process Type Step (Process Template) |
| MDC_RS_PROP_T | Text Table for MDC_RS_PROP |
| MDC_MAT_CFG_ACT | Activation Step Configuration for Material |
| MDC_CONFIG_EVA | Configuration for Data Quality Evaluation Results |
| MDC_MODIFD_TAB_H | History of Modifications to Tables |
| MDC_MODEL_FJOIN | Model JOIN Fields |
| MDC_KPI_EDI_H | Historical Table for Edit KPIs |
| MDC_LOADMOD | Load Moderations |
| MDC_D_CNFMTCIMP | IM in HANA person settings for the Match - #GENERATED# |
| MDC_CONFIG_FUZ_R | Configuration for Fuzzy Rulesets: Rules |
| MDC_MTC_UPDATE | Update groups |
| MDC_BPR_CFG_ACTT | Text Table for MDC_BPR_CFG_ACT |
| MDC_D_PRCSTEP | MDC Process Object Step Node - #GENERATED# |
| MDC_BPR_CFG_ACT | Configuration Activation for BP Relationships |
| MDC_D_PRCWLQUERY | MDC Process Object for Worklist Query Node - manual created |
| MDC_MA_GR_CD_MAP | Mapping table for change documents for source system |
| MDC_NOTATION | Annotation contents by notation reference |
| MDC_MTC_RESULT | Match results after indirect matching |
| MDC_D_PRCROOT | MDC Process Objekt Header Node (Root) - #GENERATED# |
| MDC_FILTER_KEY | MDC Step Filter Key |
| MDC_KPI_DEE_H | Historical Table for Mass Enrichment: Enrich KPIs |
| MDC_MODIFIED | Process Keys For Which Modifications Occured |
| MDC_KPI_MTC_H | Historical Table for Matching KPIs |
| MDC_MTC_PCK | Package Info |
| MDC_MODELCFIELDS | Customizing of Process Data Table Field Properties |
| MDC_MTC_SOURCE | Group with minimum source record |
| MDC_D_CNFFAR | Node FAR of MDC config process - #GENERATED# |
| MDC_ADAPT_CONF_T | Text Table for MDC_ADAPTER_CONF |
| MDC_GOAL_STEP | Allowed Step Types Of A Goal |
| MDC_D_CNFPERS | Node PERS of MDC config process - #GENERATED# |
| MDC_CONFIG_ACT_T | Text Table for MDC_CONFIG_ACT |
| MDC_D_PRCWLIST | MDC Process Object for Work List Node - #GENERATED# |
| MDC_DES_ASSIGNED | Mass Enrichment: already assigned records |
| MDC_CONFIG_UPD_T | Text Table for MDC_CONFIG_UPD |
| MDC_D_CNFSCOPE | Node SCOPE of MDC config process - #GENERATED# |
| MDC_KPI_DEE_H2 | Historical Table for Mass Enrichment changes |
| MDC_D_CNFSTDIM | IM in HANA address related settings - #GENERATED# |
| MDC_CONFIG_DEE | Configuration for Mass Enrichment: Enrich Adapters |
| BOB__FOCUS | Specifications Of BoB Focuses |
| MDC_CONFIG_DEE_T | Text Table for MDC_CONFIG_DEE |
| MDC_D_CNFRULFLD | Node RULFLD of MDC config process - #GENERATED# |
| MDC_CONFIG_MTC | Configuration details for Fuzzy Matching |
| BOB__PLACE | Specifications Of BoB Places |
| MDC_D_CNFBRC | Best Record Calculation - #GENERATED# |
| MDC_CONF_HEADER | MDC HDB Configuration Header |
| MDC_ADAPTER_CONF | Master Data Consolidation: Adapters per OTC and Step Type |
| MDC_ACT_ACTS | Timestamps Of Activation Steps Runtimes |
| MDC_DES_DUPL | Mass Enrichment: potential duplicates |
| MDC_CONFIG_DES | Configuration for Mass Enrichment: Search Adapters |
| MDC_KPI_STD_H | Historical Table for Standardization KPIs |