MDG_MDF_S_TABINFO SAP (Information for Master Data Tables) Structure details

Dictionary Type: Structure
Description: Information for Master Data Tables




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




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

MDG_MDF_S_TABINFO is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Information for Master Data Tables" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_MDG_MDF_S_TABINFO TYPE MDG_MDF_S_TABINFO.

The MDG_MDF_S_TABINFO table consists of various fields, each holding specific information or linking keys about Information for Master Data Tables data available in SAP. These include TABNAME (Table Name), DBASE (Internal Name for Database), UUID (Global Unique ID for table), CRSTAMP (Time of nametab generation).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP MDG_MDF_S_TABINFO structure 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
TABNAMETable Name TABNAMECHAR30Assigned to domainAS4TABDTB
DBASEInternal Name for Database INTBASECHAR1CHAR1
UUIDGlobal Unique ID for table UUIDRAW16UUID
CRSTAMPTime of nametab generation CRSTAMPCHAR14TIMESTMP
ABSTAMPABAP Time Stamp ABSTAMPCHAR14TIMESTMP
DYSTAMPScreen time stamp DYSTAMPCHAR14TIMESTMP
FLDCNTNumber of table fields FLDCNTRAW2NTABLONG
TABLENTable length in bytes TABLENGTHRAW4DDRAW4
KEYCNTNumber of key fields in table KEYCNTRAW1NTABSHORT
KEYLENLength of Table Key in Bytes KEYLENGTHRAW2NTABLONG
CLPOSPosition number of the client field in the table CLPOSRAW1NTABSHORT
TABTYPEType of the Dictionary object TABTYPECHAR1TABTYPE
TABFORMHow the Dictionary object is implemented in the database TABFORMCHAR1TABFORM
REFNAMEName of physical table (for pool/cluster/view) REFNAMECHAR30Assigned to domainAS4TAB
FLAGBYTEFlag of length 1 byte for table attributes TABFLAG_DRAW1NTABSHORT
EXROUTFlag if table to be compressed EXROUTRAW1NTABSHORT
FLAG3Flag of length 1 byte for table attributes TABFLAG_DRAW1NTABSHORT
FLAG4Flag of length 1 byte for table attributes TABFLAG_DRAW1NTABSHORT
FLAG5Flag of length 1 byte for table attributes TABFLAG_DRAW1NTABSHORT
FLAG6Flag of length 1 byte for table attributes TABFLAG_DRAW1NTABSHORT
BUFSTATEBuffering type of table BUFSTATECHAR1BUFSTATE
BUFPARMSupplementary information in generic buffering BUFPARMRAW2NTABLONG
ALIGNTable alignment ALIGNMENTRAW1NTABSHORT
POINTERLGPointer length with which nametab was generated POINTERLGRAW1NTABSHORT
UNICODELGUnicode length with which runtime object was generated UNICODELGRAW1NTABSHORT
COMPCNTABAP Dictionary: Number of Fields with Depth 0 DDCOMPCNTRAW2NTABLONG
LEAFCNTABAP Dictionary: Leaf Content of Structure DDLEAFCNTRAW2NTABLONG
CUSTOMER_CONTENTMaster Data: General Indicator MDG_MDF_FLGCHAR1MDG_MDF_FLG

Key field Non-key field



How do I retrieve data from SAP structure MDG_MDF_S_TABINFO using ABAP code?

As MDG_MDF_S_TABINFO is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MDG_MDF_S_TABINFO as there is no data to select.

How to access SAP table MDG_MDF_S_TABINFO

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