MDG_MDF2005 SAP (Properties of Master Data Fields) Table details

Dictionary Type: Table
Description: Properties of Master Data Fields




ABAP Code to SELECT data from MDG_MDF2005
Related tables to MDG_MDF2005
Access table MDG_MDF2005




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 empty
Display/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
APPLICATIONMaster Data: Application MDG_MDF_APPLICATIONCHAR2Assigned to domainMDG_MDF_APPLICATIONMDG_MDF_APPLICATIONMDG_MDF_APPLICATION
AREAIDMaster Data: Application Area MDG_MDF_AREAIDCHAR22SYSUUID_22MDG_MDF_AREAID
FIELDNMMaster Data: Field Name MDG_MDF_FIELDNAMECHAR30Assigned to domainFDNAMEMDG_MDF_FIELDNAME_BASIC
FIELDNAMEField Name FIELDNAMECHAR30Assigned to domainFDNAMEDFD
SID instead of UG_SID because of package errors0
TYPEMaster Data: Field Type: Characteristic or Key Figure MDG_MDF_FIELDTYPECHAR1MDG_MDF_FIELDTYPE
ROLE instead of UG_ROLE because of package errors0
ATTR_ORIGField Name FIELDNAMECHAR30Assigned to domainFDNAMEDFD
BASE_FLDField Name FIELDNAMECHAR30Assigned to domainFDNAMEDFD
UNIT_FNAMEField Name FIELDNAMECHAR30Assigned to domainFDNAMEDFD
HAS_TEXTTABLEMaster Data: Text Table Exists (Indicator) MDG_MDF_TXTTAB_FLCHAR1MDG_MDF_FLG
HAS_CHECKTABLEMaster Data: Check Table Exists (Indicator) MDG_MDF_CHKTAB_FLCHAR1MDG_MDF_FLG
HAS_FIXVALMaster Data: Domain Fixed Values Exist (Indicator) MDG_MDF_FIXVAL_FLCHAR1MDG_MDF_FLG
HAS_HIERARCHYMaster Data: With Hierarchies (Indicator) MDG_MDF_HRY_EXIST_FLCHAR1MDG_MDF_FLG
SEQNRSequence Number MDG_MDF_SEQNR4NUMC4NUMC4
TECH_SEQNRSequence Number MDG_MDF_SEQNR4NUMC4NUMC4
INTLENInternal Length in Bytes INTLENNUMC6DDLENG
INTTYPEABAP data type (C,D,N,...) INTTYPECHAR1INTTYPE
DECIMALSNumber of Decimal Places DECIMALSNUMC6DDLENG
DATATYPEData Type in ABAP Dictionary DATATYPE_DCHAR4DTYPEDATATYPE
LENGLength (No. of Characters) DDLENGNUMC6DDLENG
ROLLNAMEData element (semantic domain) ROLLNAMECHAR30Assigned to domainROLLNAMEROLDD_DTEL
OUTPUTLENOutput Length OUTPUTLENNUMC6DDLENG
ORIGINMaster Data: Storage Location of a Characteristic MDG_MDF_ORIGININT13MDG_MDF_ORIGIN
REGISTRATIONMaster Data: Why Field Was Registered MDG_MDF_FIELD_REGISTRATIONCHAR1MDG_MDF_FIELD_REGISTRATION
ATRONLYFLFIN Master Data: Characteristic Is an Attribute Only (ind.) MDG_MDF_ATRONLY_FLCHAR1MDG_MDF_FLG
IS_NAV_ATTRMaster Data: Characteristic is a Navigation Attribute (Ind.) MDG_MDF_NAVATTR_FLCHAR1MDG_MDF_FLG
CONVEXITConversion Routine CONVEXITCHAR5CONVEXIT
IS_DOC_ATTRMaster Data: Characteristic as Document Attribute Allowed MDG_MDF_DOC_FLCHAR1MDG_MDF_FLG
LOWERCASELowercase letters allowed/not allowed LOWERCASECHAR1AS4FLAG
TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!