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-AF) module.

Top 10 tables in Application Framework.

TableDescription
USMD0080Relevancy of Entity Types per Change Request Type and WFS
USMD2003Personalization: Default UI Model for Each Data Model
USMD0070CStatus of an Entity Type
USMD201T_SSWService Name Definition in RBWF: Text Table
USMD6822Higher-Level Fields Node
USMD203CStored Search Criteria (by User and Entity Type)
USMD201C_SSWService Name Definition in RBWF
USMD101TUI Model: Layout of Web Interface
USMD2044Search Apps: Assignment of Search Help - Model - Entity
USMD100TUI Model: Text Table

List of tables in Application Framework.

TableDescription
USMD0080Relevancy of Entity Types per Change Request Type and WFS
USMD2003Personalization: Default UI Model for Each Data Model
USMD0070CStatus of an Entity Type
USMD201T_SSWService Name Definition in RBWF: Text Table
USMD6822Higher-Level Fields Node
USMD203CStored Search Criteria (by User and Entity Type)
USMD201C_SSWService Name Definition in RBWF
USMD101TUI Model: Layout of Web Interface
USMD2044Search Apps: Assignment of Search Help - Model - Entity
USMD100TUI Model: Text Table
USMD100CUI Model: Check Table
USMD1102Define Service Level Agreement for Change Request Types
USMD6800Selection Condition
USMD_CMM_CONFIGConfiguration
USMDWDPARAMParameter Passing in WebDynpro
USMD680GSelection Condition
MDG_MDF2002Basis Characteristics in Master Data Environment
USMD0016Prefix for Temporary Keys
MDG_TR_TXT_KKey Table for Generic Texts
USMD050THierarchy Version: Text Table
MDG_MDF1010Template for Master Data Attributes at Hierarchy Edges
USMD020UEdition
USMD001TData Model: Text Table
USMD0021Data Model: Permitted External Entity Types in Hierarchies
USMD101CUI Model: Layout of Web Interface
USMD004MAssignment of SMT Mappings to Entity Types
USMD610CReplication Service
USMD0041Packages and Namespace for Generated Structures per Model
MDG_LG_TCATTLanguage Activation of Objects in Master Data Envir. (Text)
MDG_GN_TGOBJCatalog of Generated Objects
MDG_MDF1005Template Structures for Master Data Tables to be Generated
USMD6110Download Parameters for Distribution Service
USMD0101Type of Edition
USMD0072CStatus of a Relationship
MDG_MDF2030Restrictions on Master Data Hierarchies
USMD0023Data Model: Relationships of Entity Types
USMD6510Status Table for eSOA Messages
USMD0030Authorizations for Entities of a Data Model
USMD6820Hierarchy Info
MDG_MDF0001Response to Message
USMD202C_SSWStep Definition for SSWF
MDG_MDF1035External Roles in Master Data Hierarchies
USMD0072Obsolete - Do Not Use
USMD010CType of Edition
MDG_MDF300CNames of Master Data Hierarchies
USMD120CChange Request
MDG_TR_TXT_HHeader Table for Generic Texts
MDG_MDFL1022Explicit Text Fields
USMD6821Higher-Level Fields Hierarchy Name
MDG_MDFL1003Predefined Master Data Fields in Local Roles
USMD020CEdition
USMD1215Change Request: Objects (ISR Change Request)
USMD6400Status of Distribution Processes
MDG_MDF9101Local Data Elements (Storage Only)
USMD0043Packages for Customer Includes (CI)
MDG_MDFL1001Local Roles in Master Data Applications
USMD010TType of Edition
MDG_GN_TGOBJTSTime Stamp of the Generated Objects
MDG_MDF1015Template for Master Data Attributes at Network Edges
MDG_MDF1003Master Data Tables of Predefined Fields
MDG_TR_TAPPLTTexts of Master Data Applications
USMD0022TData Model: Attributes of Ent.Types w/Gen.Persistence, Descr
MDG_TMSGAPPL02Messages Are Collected from Message Type per Appl. Context
MDG_TR_TCATDirectory of Transport Objects
USMD1101Entity Types per Change Request
USMD0025Data Model: Relationships for Deriving Hierarchy Attributes
USMD004CGenerated Structures
USMD1221Change Request Block List
USMD2301Action Assignments to Workflow Step Types
USMD0020Data Model: Entity Types
USMD2005Personalization: Role-depend. Personalization per Data Model
MDG_TMSGAPPL01Deviating Message Type (Desired Error Severity) for Appl.
USMD1022UI Model: Sets
USMD6201Master Data Packages: Related Entity Types
USMD0015TActive Area: Text Table
USMD110CType of Change Request
MDG_TR_TXTGeneral Text Table for Master Data Transport
MDG_TR_CC02Management of Table Names for Client Copy (Runtime)
USMD0026Data Model: Foreign Key Definition
MDG_MDF1009Roles Allocated Automatically in Master Data Environment
USMD160TBusiness Activity: Text Table
USMD0022Data Model: Attributes of Ent.Types w/Generated Persistence
USMD0061UI Properties of Entity Types (Technical Entity Type)
USMD0071Obsolete - Do Not Use
USMD2041Search Apps: Assignment of Search Type - Search Help
USMD110TType of Change Request
MDG_MDF0010Area IDs in Master Data Environment
USMD001CData Model: Check Table
MDG_MDFL1011Attributes at Hierarchy Edges in Local Roles
USMD167CBusiness Activity: Determination
MDG_GN_TBPDirectory of Blue Prints
USMD1214Change Request: Objects (Hierarchy Parent Nodes)
USMD220CActions
USMD2042Search Apps: Assignment of Search Type - Model - Entity
MDG_MDFL1021Renaming of Field Names
USMD1210Change Request: Notes
MDG_MDF2100Master Data Generation: Object -> Logical Name
USMD213C_SSWRBWF: Link Change Request Type to Generated BRF+ Appl. ID
USMD0082TWorkflow Step
USMD0090User Interface Dependent on Workflow Step
MDG_TR_CCHGenerated Tables for Client Copy (Header Table)
USMD0020TData Model: Entity Types, Descriptive Text
USMD680CMaster Data of Named Selection Condition
MDG_TR_TCATALTransport Properties of Customizing Objects
USMD600CData Transfer / Variant: Check Table
USMD2010Assignment of Processors to Workflow Step Number
USMD6200Master Data Packages: Steps in Processing
USMD0102Type of Edition: Data Slices
MDG_T_CXT_DEMOPersistent Storage of a Simple Message Context
MDG_TR_DELIVPiecelists for Delivery in Master Data Environment
MDG_MDF1008Master Data Attributes (Needed for Creating)
USMD0051Entity Type to Be Used for Business Object Type
MDG_MDFL1030Restrictions for Master Data Hierarchies in Local Roles
MDG_MDF1030Restrictions on Master Data Hierarchies (SAP)
MDG_MDF1007Master Data Attributes of Roles
USMD6300Assignment of Master Data Packages to Systems
MDG_TR_TCATOAttributes of Obsolete Transport Objects
MDG_MDF2035Time Stamp of Last Change for Master Data
USMD6100Mapping for Distribution Service
MDG_MDFTRTXTText Table for Translation of Master Data Content
USMD0023TData Model: Relationships of Entity Types, Descriptive Texts
MDG_TMSGAPPL0SMessage Type per Message Handler Application
MDG_MDF2001Validity of Master Data Characteristics in Application Areas
MDG_MDF000TMaster Data Applications - Texts
USMD0060UI Properties for Modeled Fields
USMD1020UI Model: Customer-Defined Web Dynpro Component
MDG_MDFL1000Local Roles in Master Data Environment
USMD202T_SSWStep Definition Text for SSWF
MDG_TR_E071KObject List for Client Copy (Key)
MDG_MDFVDY01Validity Versions of Master Data
USMD050CHierarchy Version: Check Table
USMD1240Change Request: Systems
USMD181CPortal: OBN Navigation System Alias
USMD1103Entity Types per Main Entity per Change Request
MDG_GN_TEXBPDirectory of Executed Blueprints
USMD6010Data Transfer: Technical Settings
MDG_TR_TRANSCluster Table for Master Data Transport
MDG_MDFL1045Special Enqueue Fields in Local Roles
USMD220TTexts for Actions
MDG_TR_TCATTText for Transport Object
USMD230CWorkflow Step Types
MDG_MDF2000Defined Master Data Characteristics
MDG_TR_CC01Management of Table Names for Client Copy
USMD0081Relevancy of Attributes per Change Request Type, ET and WFS
USMD003CAuthorizations per Data Model
USMD0082Workflow Step per Change Request
MDG_MDFTRTXT2Text Table for Translation of Master Data Content
MDG_MDF_INDXCluster Table (Class CL_MDG_MDF_FIELDINFO_LOCAL)
MDG_GN_TCONFIGConfiguration of the Generator
USMD0024Data Model: Hierarchy Attributes
USMD1M901CChange Documents for Hierarchies - Dummy Table
MDG_TMSGCONT0CContext Structure of a Message Handler Application
USMD_EDTN_UPGRStatus for upgrade to enhanced edition management
USMD1217Change Request: Entity List
USMD0015Data Model: Reuse Active Areas
MDG_MDF2004Settings per Master Data Characteristic
USMD620TTexts of Master Data Packages
MDG_MDFTRANSCluster Table for Master Data Transport
USMD130CStatus of Change Request
MDG_GN_TMODUSConfiguration of the Generator Mode
MDG_MDF0009General Master Data Settings
MDG_MDF1016Master Data Attributes at Network Edges
MDG_MDF2005Properties of Master Data Fields
USMD2004Personalization: User-depend. Personalization per Data Model
USMD0050Business Object Type for Entity Types
USMD1213Change Request: Objects
MDG_DEMO_TRANSCluster Table for Transport
MDG_MDFL1010Template for Attributes at Hierarchy Edges in Local Roles
MDG_MDF200SMaster Data Characteristics (SID)
MDG_MDF0000Master Data Applications
MDG_MDF_GENENQLock in Generation in Master Data Environment
USMD150CGeneral Settings
USMD202CDefinition of Workflow Steps
MDG_MDF0002Default Classes in Master Data Environment
USMD1021UI Model: Hierarchy Relationships
MDG_MDFL1015Template for Attributes at Network Edges in Local Roles
USMD0031Authorization-Relevant Attributes
USMD140CSingle Processing: Forms
MDG_TR_CCOObject Status Client Copy
USMD1211Change Request: Attachments
USMD1M900CChange Documents for Hierarchies - Dummy Table
MDG_TR_DESTRFC Destinations for Transport Methods
USMD204TSearch Applications: Text Table
MDG_MDF9000Structures to be Generated in Master Data Environment
USMD020TEdition
MDG_TR_TCATATransport Properties of Customizing Objects
USMD204CSearch Applications: Definition
MDG_BS_GIL_MDL_CMapping Customizing Of GenIL Component To MDG Model
MDG_MDF1020Master Data Characteristics (GUID)
USMD600TData Transfer: Texts
MDG_MDFSIDGeneric External Keys for Field Name/Value Pairs (SID)
USMD003PAuthorization Relevance for Primary Persistence
MDG_MDF300TNames of Master Data Hierarchies (Texts)
USMD0071CStatus of an Attribute
USMD203HCSearch Variants (Hierarchy Search only)
USMD0070Obsolete - Do Not Use
MDG_MDF2006Properties of Master Data Fields (Language-dep. Texts)
USMD202T_2Definition of Workflow Steps
USMD211CChange Request: Reason
USMDPARAMFinancial MDM: Customizing Parameters
USMD211TChange Request: Reason
USMD2400Mapping from top workitem to change request
MDG_MDF9100Local Master Data Tables (Storage Only)
MDG_TMSGAPPL0TTexts of Message Handler Applications
USMD2041TSearch Apps: Assignment of Search Type - Search Help TextTbl
MDG_MDF300SNames of Master Data Hierarchies (SID)
USMD230TTexts for Workflow Step Types
USMD620CMaster Data Packages
USMD170TAction Texts
USMD_TXT_FLD_EXCMDG UI text assistant: excluded attributes
MDG_TR_CCMAdministration Client Copy
MDG_MDF1011Master Data Attributes at Hierarchy Edges
USMD1222Change request change list
USMD1601Business Activity: Type of Change Request
MDG_TMSGAPPL0CApplications for Message Handler
USMD6500Status Table for Distribution Steps (with History)
USMD610TDistribution Service Texts
USMD1212Change Request: Content of Attachments
USMD167C_CBusiness Activity: Determination
USMD160CBusiness Activity: Definition
MDG_MDF1000Roles in Master Data Environment
USMD_EDTN_BLOCKBlock for upgrade to enhanced edition management
USMD_TXT_FLD_MAPBuffer table for mapping of text fields in BOL/GenIL UI
MDG_MDF_ENQHRYNDEnqueue/Dequeue Table for Nodes in Master Data Hierarchies
MDG_TR_E071Object List for Client Copy
USMD180CNavigation
USMD6900SMT Mapping - Cluster Table
MDG_MDFL1035Local External Roles in Master Data Hierarchies
MDG_MDF2007Compounds of Master Data Fields
USMD202TDefinition of Workflow Steps
MDG_MDFL1004Attributes of Predefined Fields in Local Roles
MDG_MDFENQOBJMaster Data Table for Enqueue/Dequeue
MDG_BS_GIL_MDLMapping Of GenIL Component To MDG Model
USMD1216Change Request: Receiver Systems
USMD151C_BLBlacklisted MDG UI Applications
USMD2002Personalization: Default UI Model for Each Data Model
USMD1220Change Request: Drafts (Data of Entity)
USMD202C_2Definition of Workflow Steps
USMD_ENQ_HRYNODEFIN-MDM: Enqueue/Dequeue Table for Hierarchy Nodes
MDG_MDF1045Special Master Data Fields for Enqueue
USMD_MC_LIMITMax. number of datasets to be handled by multi-proc. appl.
USMD_CR_BLOCKBlocking of Change Requests After Activation of Data Model
MDG_MDF301CVersions of Master Data Hierarchies
USMD2000Personalization: Default Data Model
USMD151CMDG UI Applications
MDG_MDF301SVersions of Master Data Hierarchies (SID)
MDG_MDF9102Local Domains (Storage Only)
USMD680TSelection Condition Texts
MDG_MDFENQSIDEnqueue / Dequeue Master Data Table (SID)
MDG_MDF1004Master Data Attributes of Predefined Fields
USMD_DM_ACT_LOGChanges During the Most Recent Data Model Activations
USMD210CChange Request: Priority
MDG_MDF1001Roles Allowed in Master Data Applications
MDG_GN_TEXBP_XEnhancement of the Configuration Key of a Blueprint
MDG_MDFL1016Master Data Attributes at Network Edges in Local Roles
USMD130TStatus of Change Request
MDG_MDF2010Generated Master Data Structures (DDIC)
USMD170CAction
MDG_MDF2011Generated Tables of Master Data Characteristics
USMD210TChange Request: Priority
MDG_LG_TCATLanguage Activation of Objects in Master Data Environment
USMD212CChange Request: Reason for Rejection
USMD212TChange Request: Reason for Rejection
MDG_MDF0050Leading Fiscal Year Variant per Client
MDG_MDF2101List of Generated DDIC Elements
USMD6011Data Transfer: Internal Structure
USMD180C_CNavigation
USMD_ARC_RDTChange Request Archiving: Residence Times
MDG_TR_TAPPLMaster Data Applications
USMD2001Personalization: Default Data Model