MDG_MDFL1000 SAP (Local Roles in Master Data Environment) Table details

Dictionary Type: Table
Description: Local Roles in Master Data Environment




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




Table field list including key, data, relationships and ABAP select examples

MDG_MDFL1000 is a standard SAP Table which is used to store Local Roles in Master Data Environment data and is available within R/3 SAP systems depending on the version and release level.

The MDG_MDFL1000 table consists of various fields, each holding specific information or linking keys about Local Roles in Master Data Environment data available in SAP. These include CHAR_CLASS (Reference type), HIER_CLASS (Reference type), NET_CLASS (Reference type), ONLY_INTTYPE (ABAP data type (C,D,N,...)).. 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_MDFL1000 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
ROLEMaster Data: Role MDG_MDF_ROLECHAR10Assigned to domainMDG_MDF_ROLE
CHAR_CLASSReference type CLASSNAMECHAR30CLASSNAME
HIER_CLASSReference type CLASSNAMECHAR30CLASSNAME
NET_CLASSReference type CLASSNAMECHAR30CLASSNAME
ONLY_INTTYPEABAP data type (C,D,N,...) INTTYPECHAR1INTTYPE
ONLY_INTLENInternal Length in Bytes INTLENNUMC6DDLENG
ONLY_TYPEMaster Data: Field Type: Characteristic or Key Figure MDG_MDF_FIELDTYPECHAR1MDG_MDF_FIELDTYPE
ROLLNAMEData element (semantic domain) ROLLNAMECHAR30Assigned to domainROLLNAMEROLDD_DTEL
FIELDNAMEMaster Data: Field Name MDG_MDF_FIELDNAMECHAR30Assigned to domainFDNAMEMDG_MDF_FIELDNAME_BASIC
ROLLNAME_SIDData element (semantic domain) ROLLNAMECHAR30Assigned to domainROLLNAMEROLDD_DTEL
SOBJObject Name OB_OBJECTCHAR30Assigned to domainOB_OBJECT
BUFFER_TYPEMaster Data: Type of Read Buffering MDG_MDF_BUFF_TYPENUMC1MDG_MDF_BUFF_TYPE
WITH_DELTA_LEAFMaster Data: General Indicator MDG_MDF_FLGCHAR1MDG_MDF_FLG
TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
UNAMEUser Name UNAMECHAR12UNAME

Key field Non-key field



How do I retrieve data from SAP table MDG_MDFL1000 using ABAP code

The following ABAP code Example will allow you to do a basic selection on MDG_MDFL1000 to SELECT all data from the table
DATA: WA_MDG_MDFL1000 TYPE MDG_MDFL1000.

SELECT SINGLE *
FROM MDG_MDFL1000
INTO CORRESPONDING FIELDS OF WA_MDG_MDFL1000
WHERE...

How to access SAP table MDG_MDFL1000

Within an ECC or HANA version of SAP you can also view further information about MDG_MDFL1000 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!