MDG_DT_S_ENTITY SAP (Structure for Entity Types) Structure details

Dictionary Type: Structure
Description: Structure for Entity Types




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




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

MDG_DT_S_ENTITY 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 "Structure for Entity Types" 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_DT_S_ENTITY TYPE MDG_DT_S_ENTITY.

The MDG_DT_S_ENTITY table consists of various fields, each holding specific information or linking keys about Structure for Entity Types data available in SAP. These include USMD_ENTITY (Entity Type), USAGE_TYPE (Storage and Use Type), KEY_HANDLING (Type of Key Assignment), USMD_VAL_ENTITY (Validity Concept for Entity Type).. 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_DT_S_ENTITY 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
USMD_MODELData Model USMD_MODELCHAR2Assigned to domainUSMD_MODEL
USMD_ENTITYEntity Type USMD_ENTITYCHAR9Assigned to domainUSMD_ENTITY
USAGE_TYPEStorage and Use Type USMD_USAGE_TYPECHAR1USMD_USAGE_TYPE
KEY_HANDLINGType of Key Assignment USMD_KEY_HANDLINGCHAR1USMD_KEY_HANDLING
USMD_VAL_ENTITYValidity Concept for Entity Type USMD_VALIDITY_ENTITY_TYPECHAR1USMD_VALIDITY_ENTITY_TYPE
ROLLNAMEData Element (Entity Type) USMD_ROLLNAME_ENTCHAR30Assigned to domainROLLNAMEROLDD_DTEL
HRYHierarchies USMD_HRYCHAR1USMD_HRY
USMD_VAL_HRYValidity Concept for Hierarchy USMD_VALIDITY_HRYCHAR1USMD_VALIDITY_HRY
F_MULTI_LANGULanguage-Dependent Texts USMD_MULTI_LANGUCHAR1USMD_FLG
TXTLG_LENLong Text: Length USMD_TXTLG_LENNUMC2USMD_TXTLG_LEN
TXTMI_LENMedium Text: Length USMD_TXTMI_LENNUMC2USMD_TXTMI_LEN
TXTSH_LENShort Text: Length USMD_TXTSH_LENNUMC2USMD_TXTSH_LEN
F_HAS_ATTACHMENTAttachments (Indicator) USMD_HAS_ATTACHMENTCHAR1USMD_FLG
F_HAS_SETSets Indicator USMD_HAS_SETCHAR1USMD_FLG
USMD_SEARCH_HLPSearch Help USMD_SEARCH_HLPCHAR30Assigned to domainSHLPNAMEDD_SHLP
USMD_FLD_TXTSHShort Text: Source Field USMD_FLD_TXTSHCHAR30Assigned to domainFDNAME
USMD_FLD_TXTMIMedium Text: Source Field USMD_FLD_TXTMICHAR30Assigned to domainFDNAME
USMD_FLD_TXTLGLong Text: Source Field USMD_FLD_TXTLGCHAR30Assigned to domainFDNAME
TMP_KEY_NROBJName of number range object NROBJCHAR10Assigned to domainNROBJ
PP_DOMAINActive Area USMD_PP_DOMAINCHAR10Assigned to domainUSMD_PP_DOMAIN
ENTITY_DELETIONDeletion of Entities USMD_ENTITY_DELETIONCHAR1USMD_ENTITY_DELETION
USMD_APPLApplication USMD_APPLCHAR10USMD_APPL
TAB_SOURCEABAP Dictionary Structure/Table USMD_TAB_SOURCECHAR30Assigned to domainAS4TAB
FLD_SOURCESource Field USMD_FLD_SOURCECHAR30Assigned to domainFDNAME
TAB_XFIELDABAP Dictionary Structure for X-Fields USMD_TAB_XFIELDCHAR30Assigned to domainAS4TAB
TXTLGDescription USMD_MODEL_OBJ_TXTCHAR60TEXT60
ACTIONAction on the Data Model MDG_DT_ACTIONCHAR1MDG_DT_ACTION
GENERATEDGenerated Element USMD_GENERATEDCHAR1USMD_FLG
DISABLEDStandard Delivery Status USMD_SWITCH_DEFAULTCHAR1USMD_SWITCH_DEFAULT

Key field Non-key field



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

As MDG_DT_S_ENTITY 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_DT_S_ENTITY as there is no data to select.

How to access SAP table MDG_DT_S_ENTITY

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