SAP DMC_DD02L_EXT_S Table in S/4 HANA - DD02L tables extend
DMC_DD02L_EXT_S is a standard SAP Table which is used to store DD02L tables extend data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP DMC_DD02L_EXT_S table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type)
Dictionary Type: Structure
Database Table: DMC_DD02L_EXT_S
DMC_DD02L_EXT_S table structure field list
Below is the full DMC_DD02L_EXT_S field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| ORG_TABNAME | Generic data element for database table names | DMC_DB_TABNAME | CHAR | 128(0) | DMC_DB_TABNAME | |||||
| TABNAME | Table Name | TABNAME | CHAR | 30(0) | Assigned to domain | AS4TAB | DTB | |||
| AS4LOCAL | Activation State of Repository Object | AS4LOCAL | CHAR | 1(0) | AS4LOCAL | |||||
| AS4VERS | Version of the entry (not used) | AS4VERS | NUMC | 4(0) | AS4VERS | |||||
| TABCLASS | Table Category | TABCLASS | CHAR | 8(0) | TABCLASS | |||||
| SQLTAB | Name of an SQL table or an appended table | SQLAPPDTAB | CHAR | 30(0) | Assigned to domain | AS4TAB | ||||
| DATMIN | Minimum no. of entries | DATMIN | NUMC | 10(0) | DATANZ | |||||
| DATMAX | Maximum no. of entries | DATMAX | NUMC | 10(0) | DATANZ | |||||
| DATAVG | Average number of entries | DATAVG | NUMC | 10(0) | DATANZ | |||||
| CLIDEP | Client-Specific Flag | CLIDEP | CHAR | 1(0) | CLIDEP | |||||
| BUFFERED | Buffering flag | BUFFERED | CHAR | 1(0) | BUFFERED | |||||
| COMPRFLAG | Field compression indicator | COMPREX | CHAR | 1(0) | AS4FLAG | |||||
| LANGDEP | Language dependency | LANGDEP | CHAR | 1(0) | LANGDEP | |||||
| ACTFLAG | Activation flag | ACTFLAG | CHAR | 1(0) | ACTFLAG | |||||
| APPLCLASS | Application class for DD objects (not used) | APPLCLASS | CHAR | 4(0) | Assigned to domain | APPLCLASS | APP | |||
| AUTHCLASS | Activation type | AUTHCLASS_ | NUMC | 2(0) | AUTHCLASS | |||||
| AS4USER | Last Changed By | AS4USER | CHAR | 12(0) | AS4USER | |||||
| AS4DATE | Last Changed On | AS4DATE | DATS | 8(0) | AS4DATE | |||||
| AS4TIME | Last changed at | AS4TIME | TIMS | 6(0) | AS4TIME | |||||
| MASTERLANG | Original Language in Repository objects | MASTERLANG | LANG | 1(0) | ISOLA | SPRAS | H_T002 | SPRAS | ||
| MAINFLAG | Indicates maintenance with standard tools allowed | MAINTFLAG | CHAR | 1(0) | MAINTFLAG | |||||
| CONTFLAG | Delivery class | CONTFLAG | CHAR | 1(0) | CONTFLAG | |||||
| RESERVETAB | SDIC: Reserve for tables | RESERVETAB | CHAR | 4(0) | CHAR4 | |||||
| GLOBALFLAG | Flag for private DD objects (not used) | GLOBALFLAG | CHAR | 1(0) | GLOBALFLAG | |||||
| PROZPUFF | Percentage for buffers | PROZPUFF | NUMC | 3(0) | PROZPUFF | |||||
| VIEWCLASS | View Type | VIEWCLASS | CHAR | 1(0) | VIEWCLASS | |||||
| VIEWGRANT | Maintenance status (change authorization) for view data | VIEWGRANT | CHAR | 1(0) | VIEWGRANT | |||||
| MULTIPLEX | Indicates multiplexing is possible for a table | MULTIPLEX | CHAR | 1(0) | MULTIPLEX | |||||
| SHLPEXI | Search help binding to table exists | SHLPEXI | CHAR | 1(0) | DDBOOL | |||||
| PROXYTYPE | DD: Is a generated proxy object | DDPROXYTY | CHAR | 1(0) | DDPROXYTY | |||||
| EXCLASS | DD: Ranking for include and subtype extension | DDRANKING | NUMC | 1(0) | DDRANKING | |||||
| WRONGCL | Enhancement category is incorrect | DDWRONGCL | CHAR | 1(0) | DDWRONGCL | |||||
| ALWAYSTRP | Table is always transparent on selected databases | DDALWAYSTRP | CHAR | 1(0) | DDALWAYSTRP | |||||
| ALLDATAINCL | DD: DataAging: Handle data as hot and cold if switched on | DDALLDATAINCLU | CHAR | 1(0) | DDALLDATAINCLU | |||||
| WITH_PARAMETERS | DD: Set whenever a view or base view has parameters | DDWITHPAR | CHAR | 1(0) | DDWITHPAR | |||||
| EXVIEW_INCLUDED | DD: Contains at least one external view in the hierarchy | DDEXTVIEW_INCLUDED | CHAR | 1(0) | DDEXTVIEW_INCLUDED | |||||
| KEYMAX_FEATURE | DD: Maximum CL_DD_DBFEATURES=>KEYCNT_MAX1 Key Fields | DDDBKEYMAXFEATURE | CHAR | 1(0) | DDDBFEATURE | |||||
| KEYLEN_FEATURE | DD: Maximum CL_DD_DBFEATURES=>KEYLEN_MAX1 Key Length | DDDBKEYLENFEATURE | CHAR | 1(0) | DDDBFEATURE | |||||
| TABLEN_FEATURE | DD: Maximum Width CL_DD_DBFEATURES=>LEN_MAX1 | DDDBTABLENFEATURE | CHAR | 1(0) | DDDBFEATURE | |||||
| NONTRP_INCLUDED | At least one non-transparent table is contained here | DDNONTRANSP_INCLUDED | CHAR | 1(0) | DDNONTRANSP_INCLUDED | |||||
| VIEWREF | Name of SAP table view | VIEWNAME | CHAR | 30(0) | Assigned to domain | VIEWNAME | DVI | |||
| VIEWREF_ERR | Replacement object cannot be used | DDVIEWREF_ERR | CHAR | 1(0) | DDBOOL | |||||
| VIEWREF_POS_CHG | Replacement object exists in different positions | DDVIEWREF_POSCHG | CHAR | 1(0) | ||||||
| TBFUNC_INCLUDED | Contains info whether a table function exists in hierarchy | DDTBFUNC_INCLUDED | CHAR | 1(0) | ||||||
| IS_GTT | Flag whether table is a global temporary table | DD_IS_GTT | CHAR | 1(0) | DD_IS_GTT | |||||
| SESSION_VAR_EX | DD: Does a session variable exist? | DDSESSIONVAR_EX | CHAR | 1(0) | DDSESSIONVAR_EX | |||||
| FROM_ENTITY | DD: Table is generated from an entity DDL | DDTABGEN_FROM_DDL | CHAR | 1(0) | ||||||
| PK_IS_INVHASH | Create primary key as inverted hash/individual | DDPK_IS_INVHASH | CHAR | 1(0) | DDPK_IS_INVHASH | |||||
| USED_SESSION_VARS | DD: Session Variables Used | DDUSEDSESSION_VARS | CHAR | 5(0) | DDUSEDSESSION_VARS | |||||
| ABAP_LANGUAGE_VERSION | ABAP Language Version | ABAP_LANGUAGE_VERSION | CHAR | 1(0) | ABAP_LANGUAGE_VERSION | |||||
| HDB_ONLY_ENTITY_INCLUDED | DD: Does a HDB entity occur? | DDHDBONLY_ENTITY_INCLUDED | CHAR | 1(0) |
Search for further information about these or an SAP related objects