MDG_MDF2005 SAP (Properties of Master Data Fields) Table details
Dictionary Type: Table
Description: Properties of Master Data Fields
Description: Properties of Master Data Fields
Table field list including key, data, relationships and ABAP select examples
MDG_MDF2005 is a standard SAP Table which is used to store Properties of Master Data Fields data and is available within R/3 SAP systems depending on the version and release level.
The MDG_MDF2005 table consists of various fields, each holding specific information or linking keys about Properties of Master Data Fields data available in SAP. These include AREAID (Master Data: Application Area), FIELDNM (Master Data: Field Name), FIELDNAME (Field Name), SID (instead of UG_SID because of package errors).. 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: L - Table for storing temporary data, is delivered emptyDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP MDG_MDF2005 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 |
APPLICATION | Master Data: Application | MDG_MDF_APPLICATION | CHAR | 2 | Assigned to domain | MDG_MDF_APPLICATION | MDG_MDF_APPLICATION | MDG_MDF_APPLICATION | |
AREAID | Master Data: Application Area | MDG_MDF_AREAID | CHAR | 22 | SYSUUID_22 | MDG_MDF_AREAID | |||
FIELDNM | Master Data: Field Name | MDG_MDF_FIELDNAME | CHAR | 30 | Assigned to domain | FDNAME | MDG_MDF_FIELDNAME_BASIC | ||
FIELDNAME | Field Name | FIELDNAME | CHAR | 30 | Assigned to domain | FDNAME | DFD | ||
SID | instead of UG_SID because of package errors | 0 | |||||||
TYPE | Master Data: Field Type: Characteristic or Key Figure | MDG_MDF_FIELDTYPE | CHAR | 1 | MDG_MDF_FIELDTYPE | ||||
ROLE | instead of UG_ROLE because of package errors | 0 | |||||||
ATTR_ORIG | Field Name | FIELDNAME | CHAR | 30 | Assigned to domain | FDNAME | DFD | ||
BASE_FLD | Field Name | FIELDNAME | CHAR | 30 | Assigned to domain | FDNAME | DFD | ||
UNIT_FNAME | Field Name | FIELDNAME | CHAR | 30 | Assigned to domain | FDNAME | DFD | ||
HAS_TEXTTABLE | Master Data: Text Table Exists (Indicator) | MDG_MDF_TXTTAB_FL | CHAR | 1 | MDG_MDF_FLG | ||||
HAS_CHECKTABLE | Master Data: Check Table Exists (Indicator) | MDG_MDF_CHKTAB_FL | CHAR | 1 | MDG_MDF_FLG | ||||
HAS_FIXVAL | Master Data: Domain Fixed Values Exist (Indicator) | MDG_MDF_FIXVAL_FL | CHAR | 1 | MDG_MDF_FLG | ||||
HAS_HIERARCHY | Master Data: With Hierarchies (Indicator) | MDG_MDF_HRY_EXIST_FL | CHAR | 1 | MDG_MDF_FLG | ||||
SEQNR | Sequence Number | MDG_MDF_SEQNR4 | NUMC | 4 | NUMC4 | ||||
TECH_SEQNR | Sequence Number | MDG_MDF_SEQNR4 | NUMC | 4 | NUMC4 | ||||
INTLEN | Internal Length in Bytes | INTLEN | NUMC | 6 | DDLENG | ||||
INTTYPE | ABAP data type (C,D,N,...) | INTTYPE | CHAR | 1 | INTTYPE | ||||
DECIMALS | Number of Decimal Places | DECIMALS | NUMC | 6 | DDLENG | ||||
DATATYPE | Data Type in ABAP Dictionary | DATATYPE_D | CHAR | 4 | DTYPE | DATATYPE | |||
LENG | Length (No. of Characters) | DDLENG | NUMC | 6 | DDLENG | ||||
ROLLNAME | Data element (semantic domain) | ROLLNAME | CHAR | 30 | Assigned to domain | ROLLNAME | ROL | DD_DTEL | |
OUTPUTLEN | Output Length | OUTPUTLEN | NUMC | 6 | DDLENG | ||||
ORIGIN | Master Data: Storage Location of a Characteristic | MDG_MDF_ORIGIN | INT1 | 3 | MDG_MDF_ORIGIN | ||||
REGISTRATION | Master Data: Why Field Was Registered | MDG_MDF_FIELD_REGISTRATION | CHAR | 1 | MDG_MDF_FIELD_REGISTRATION | ||||
ATRONLYFL | FIN Master Data: Characteristic Is an Attribute Only (ind.) | MDG_MDF_ATRONLY_FL | CHAR | 1 | MDG_MDF_FLG | ||||
IS_NAV_ATTR | Master Data: Characteristic is a Navigation Attribute (Ind.) | MDG_MDF_NAVATTR_FL | CHAR | 1 | MDG_MDF_FLG | ||||
CONVEXIT | Conversion Routine | CONVEXIT | CHAR | 5 | CONVEXIT | ||||
IS_DOC_ATTR | Master Data: Characteristic as Document Attribute Allowed | MDG_MDF_DOC_FL | CHAR | 1 | MDG_MDF_FLG | ||||
LOWERCASE | Lowercase letters allowed/not allowed | LOWERCASE | CHAR | 1 | AS4FLAG | ||||
TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | TZNTSTMPS |
Key field | Non-key field |
How do I retrieve data from SAP table MDG_MDF2005 using ABAP code
The following ABAP code Example will allow you to do a basic selection on MDG_MDF2005 to SELECT all data from the tableDATA: WA_MDG_MDF2005 TYPE MDG_MDF2005.
SELECT SINGLE *
FROM MDG_MDF2005
INTO CORRESPONDING FIELDS OF WA_MDG_MDF2005
WHERE...
How to access SAP table MDG_MDF2005
Within an ECC or HANA version of SAP you can also view further information about MDG_MDF2005 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