MDG_GN_INDX_SOURCE SAP (Source Data of a Secondary Index) Structure details

Dictionary Type: Structure
Description: Source Data of a Secondary Index




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




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

MDG_GN_INDX_SOURCE 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 "Source Data of a Secondary Index" 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_GN_INDX_SOURCE TYPE MDG_GN_INDX_SOURCE.

The MDG_GN_INDX_SOURCE table consists of various fields, each holding specific information or linking keys about Source Data of a Secondary Index data available in SAP. These include SQLTAB (Table Name), INDEXNAME (Unique Index ID in a Table), AS4LOCAL (Activation Status of a Repository Object), AS4VERS (Version of the entry (not used)).. 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_GN_INDX_SOURCE 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
HEADER 0
SQLTABTable Name TABNAMECHAR30AS4TABDTB
INDEXNAMEUnique Index ID in a Table INDEXIDCHAR3INDEXIDDIX
AS4LOCALActivation Status of a Repository Object AS4LOCALCHAR1AS4LOCAL
AS4VERSVersion of the entry (not used) AS4VERSNUMC4AS4VERS
DDLANGUAGELanguage Key DDLANGUAGELANG1ISOLASPRAS
AUTHCLASSActivation type AUTHCLASS_NUMC2AUTHCLASS
UNIQUEFLAGFlag for UNIQUE indexes UNIQUEFLAGCHAR1AS4FLAG
AS4USERLast Changed by AS4USERCHAR12AS4USER
AS4DATEDate of Last Change AS4DATEDATS8AS4DATE
AS4TIMELast changed at AS4TIMETIMS6AS4TIME
ACTFLAGActivation flag ACTFLAGCHAR1ACTFLAG
DBINDEXDatabase index DBINDEX_DCHAR18DBINDEX
DBSTATEStatus of index on the database DDIXDBSTATCHAR1DDIXDBSTAT
DBINCLEXCLList of DB systems used as list of inclusions/exclusions DDIXINCEXCHAR1DDIXINCEX
DBSYSSEL1Choose a database system for DB-specific indexes DDIXDBSELCHAR3DDIXDBSEL
DBSYSSEL2Choose a database system for DB-specific indexes DDIXDBSELCHAR3DDIXDBSEL
DBSYSSEL3Choose a database system for DB-specific indexes DDIXDBSELCHAR3DDIXDBSEL
DBSYSSEL4Choose a database system for DB-specific indexes DDIXDBSELCHAR3DDIXDBSEL
DDTEXTExplanatory short text DDTEXTCHAR60DDTEXT
ISEXTINDDD: Flag if index is extension index DDISEXTINDCHAR1DDISEXTIND
FULL_TEXTDD: Full Text Index DDFULLTEXTCHAR1DDFULLTEXT
HEADER_CHANGEDData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
T_FIELDS 0
FIELDS_CHANGEDData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE

Key field Non-key field



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

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

How to access SAP table MDG_GN_INDX_SOURCE

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