DD02L - SAP Tables
SAP Tables information is stored in SAP table DD02L.
It is part of development package SDIC in software component BC-DWB-DIC-AC. This development package consists of objects that can be grouped under "ABAP Dictionary".
It is part of development package SDIC in software component BC-DWB-DIC-AC. This development package consists of objects that can be grouped under "ABAP Dictionary".
Fields for table DD02L
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| TABNAME | Table Name | X | TABNAME | CHAR | 60 | |
| AS4LOCAL | Activation State of Repository Object | X | AS4LOCAL | CHAR | 2 | |
| AS4VERS | Version of the entry (not used) | X | AS4VERS | NUMC | 8 | |
| TABCLASS | Table Category | TABCLASS | CHAR | 16 | ||
| SQLTAB | Name of an SQL table or an appended table | SQLAPPDTAB | CHAR | 60 | ||
| DATMIN | Minimum no. of entries | DATMIN | NUMC | 20 | ||
| DATMAX | Maximum no. of entries | DATMAX | NUMC | 20 | ||
| DATAVG | Average number of entries | DATAVG | NUMC | 20 | ||
| CLIDEP | Client-Specific Flag | CLIDEP | CHAR | 2 | ||
| BUFFERED | Buffering flag | BUFFERED | CHAR | 2 | ||
| COMPRFLAG | Field compression indicator | COMPREX | CHAR | 2 | ||
| LANGDEP | Language dependency | LANGDEP | CHAR | 2 | ||
| ACTFLAG | Activation flag | ACTFLAG | CHAR | 2 | ||
| APPLCLASS | Application class for DD objects (not used) | APPLCLASS | CHAR | 8 | ||
| AUTHCLASS | Activation type | AUTHCLASS_ | NUMC | 4 | ||
| AS4USER | Last Changed By | AS4USER | CHAR | 24 | ||
| AS4DATE | Last Changed On | AS4DATE | DATS | 16 | ||
| AS4TIME | Last changed at | AS4TIME | TIMS | 12 | ||
| MASTERLANG | Original Language in Repository objects | MASTERLANG | LANG | 2 | ||
| MAINFLAG | Indicates maintenance with standard tools allowed | MAINTFLAG | CHAR | 2 | ||
| CONTFLAG | Delivery class | CONTFLAG | CHAR | 2 | ||
| RESERVETAB | SDIC: Reserve for tables | RESERVETAB | CHAR | 8 | ||
| GLOBALFLAG | Flag for private DD objects (not used) | GLOBALFLAG | CHAR | 2 | ||
| PROZPUFF | Percentage for buffers | PROZPUFF | NUMC | 6 | ||
| VIEWCLASS | View Type | VIEWCLASS | CHAR | 2 | ||
| VIEWGRANT | Maintenance status (change authorization) for view data | VIEWGRANT | CHAR | 2 | ||
| MULTIPLEX | Indicates multiplexing is possible for a table | MULTIPLEX | CHAR | 2 | ||
| SHLPEXI | Search help binding to table exists | SHLPEXI | CHAR | 2 | ||
| PROXYTYPE | DD: Is a generated proxy object | DDPROXYTY | CHAR | 2 | ||
| EXCLASS | DD: Ranking for include and subtype extension | DDRANKING | NUMC | 2 | ||
| WRONGCL | Enhancement category is incorrect | DDWRONGCL | CHAR | 2 | ||
| ALWAYSTRP | Table is always transparent on selected databases | DDALWAYSTRP | CHAR | 2 | ||
| ALLDATAINCL | DD: DataAging: Handle data as hot and cold if switched on | DDALLDATAINCLU | CHAR | 2 | ||
| WITH_PARAMETERS | DD: Set whenever a view or base view has parameters | DDWITHPAR | CHAR | 2 | ||
| EXVIEW_INCLUDED | DD: Contains at least one external view in the hierarchy | DDEXTVIEW_INCLUDED | CHAR | 2 | ||
| KEYMAX_FEATURE | DD: Maximum CL_DD_DBFEATURES=>KEYCNT_MAX1 Key Fields | DDDBKEYMAXFEATURE | CHAR | 2 | ||
| KEYLEN_FEATURE | DD: Maximum CL_DD_DBFEATURES=>KEYLEN_MAX1 Key Length | DDDBKEYLENFEATURE | CHAR | 2 | ||
| TABLEN_FEATURE | DD: Maximum Width CL_DD_DBFEATURES=>LEN_MAX1 | DDDBTABLENFEATURE | CHAR | 2 | ||
| NONTRP_INCLUDED | At least one non-transparent table is contained here | DDNONTRANSP_INCLUDED | CHAR | 2 | ||
| VIEWREF | Name of SAP Table View | VIEWNAME | CHAR | 60 | ||
| VIEWREF_ERR | Replacement object cannot be used | DDVIEWREF_ERR | CHAR | 2 | ||
| VIEWREF_POS_CHG | Replacement object exists in different positions | DDVIEWREF_POSCHG | CHAR | 2 | ||
| TBFUNC_INCLUDED | Contains info whether a table function exists in hierarchy | DDTBFUNC_INCLUDED | CHAR | 2 | ||
| IS_GTT | Flag whether table is a global temporary table | DD_IS_GTT | CHAR | 2 | ||
| SESSION_VAR_EX | DD: Does a session variable exist? | DDSESSIONVAR_EX | CHAR | 2 | ||
| FROM_ENTITY | DD: Table is generated from an entity DDL | DDTABGEN_FROM_DDL | CHAR | 2 | ||
| PK_IS_INVHASH | Create primary key as inverted hash/individual | DDPK_IS_INVHASH | CHAR | 2 | ||
| USED_SESSION_VARS | DD: Session Variables Used | DDUSEDSESSION_VARS | CHAR | 12 | ||
| ABAP_LANGUAGE_VERSION | ABAP Language Version | ABAP_LANGUAGE_VERSION | CHAR | 2 | ||
| HDB_ONLY_ENTITY_INCLUDED | DD: Does a HDB entity occur? | DDHDBONLY_ENTITY_INCLUDED | CHAR | 2 | ||
| FIELD_SUFFIX | ABAP Dictionary: Field Suffix for TABL objects | DDFIELDSUFFIX | CHAR | 6 | ||
| QUOTA_MAX_FIELDS | ABAP Dictionary: Count of fields for TABL Quota | DDQUOTAFIELDS | NUMC | 10 | ||
| QUOTA_MAX_BYTES | ABAP Dictionary: Bytes for TABL Quota definition | DDQUOTABYTES | NUMC | 14 | ||
| QUOTA_SHARE_PARTNER | ABAP Dictionary: Party share for TABL Quota definition | DDQUOTASHARE | NUMC | 6 | ||
| QUOTA_SHARE_CUSTOMER | ABAP Dictionary: Party share for TABL Quota definition | DDQUOTASHARE | NUMC | 6 |