SAP table DD02L is part of the SAP data dictionary and serves as a central repository for storing metadata about all database tables in the system. It contains details such as table names, table types (e.g., transparent, cluster, pooled), delivery class, and other key attributes that define the structure and behavior of tables within the SAP system. This table is essential for system administrators and developers for understanding the underlying database architecture and managing table configurations. This table is also use dto create the SAP data dictionary on this website. Table descriptions can be found in SAP table DD02T (SAP DD: SAP Table Texts)
SAP table DD02L has 3 primary key fields being TABNAME,AS4LOCAL,AS4VERS.
/ Fields
DD02L columns.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
KeyTABNAME
Table Name
CHAR
30
0
TABNAME
KeyAS4LOCAL
Activation State of Repository Object
CHAR
1
0
AS4LOCAL
A
Entry was activated or generated in this form
L
Lock entry (first N version)
N
Entry was edited, but not activated
S
Previously active entry, backup copy
T
Temporary version when editing
KeyAS4VERS
Version of the entry (not used)
NUMC
4
0
AS4VERS
TABCLASS
Table Category
CHAR
8
0
TABCLASS
APPEND
Append structure
INTTAB
Structure
TRANSP
Transparent table
VIEW
General view structure
SQLTAB
Name of an SQL table or an appended table
CHAR
30
0
SQLAPPDTAB
DATMIN
Minimum no. of entries
NUMC
10
0
DATMIN
DATMAX
Maximum no. of entries
NUMC
10
0
DATMAX
DATAVG
Average number of entries
NUMC
10
0
DATAVG
CLIDEP
Client-Specific Flag
CHAR
1
0
CLIDEP
Not client-specific; valid throughout system
X
Client-specific; valid only for current client
BUFFERED
Buffering flag
CHAR
1
0
BUFFERED
' ': buffering not allowed
E
'E': buffering allowed (internal indicator)
X
'X': buffering allowed
COMPRFLAG
Field compression indicator
CHAR
1
0
COMPREX
LANGDEP
Language dependency
CHAR
1
0
LANGDEP
Table may not contain INCLUDE to other tables
X
Table contains only INCLUDE to other tables
ACTFLAG
Activation flag
CHAR
1
0
ACTFLAG
Start of activation or activation successful
I
Internal checks successful
U
External checks for object OK or error in table as dependent
APPLCLASS
Application class for DD objects (not used)
CHAR
4
0
APPLCLASS
AUTHCLASS
Activation type
NUMC
2
0
AUTHCLASS_
AS4USER
Last Changed By
CHAR
12
0
AS4USER
AS4DATE
Last Changed On
DATS
8
0
AS4DATE
AS4TIME
Last changed at
TIMS
6
0
AS4TIME
MASTERLANG
Original Language in Repository objects
LANG
1
0
MASTERLANG
MAINFLAG
Indicates maintenance with standard tools allowed
CHAR
1
0
MAINTFLAG
Display/Maintenance Allowed with Restrictions
D
Only display allowed
N
Display/Maintenance Not Allowed
X
Display/Maintenance Allowed
CONTFLAG
Delivery class
CHAR
1
0
CONTFLAG
A
Application table (master and transaction data)
C
Customizing, maintenance only by customer, no SAP imports
E
Control table, SAP and customer have separate key areas
G
Customizing, protected against SAP updates, only INS allowed
L
Local data, delivered empty
S
System table, edited only by SAP, change = modification
W
System table, contents transportable by separate TR objects
RESERVETAB
SDIC: Reserve for tables
CHAR
4
0
RESERVETAB
GLOBALFLAG
Flag for private DD objects (not used)
CHAR
1
0
GLOBALFLAG
Global DE object
T
Table-dependent DD object
X
Application-dependent DE object
PROZPUFF
Percentage for buffers
NUMC
3
0
PROZPUFF
VIEWCLASS
View Type
CHAR
1
0
VIEWCLASS
A
Append View
C
Maintenance View
D
Database View
E
Entity view (no longer supported)
H
Help View
P
Projection View
R
Replication Projection View
S
Structure view (no longer supported)
V
View Variant
X
External View
VIEWGRANT
Maintenance status (change authorization) for view data
CHAR
1
0
VIEWGRANT
Read, change, delete, and insert
M
Time-dependent views: like U, validity data like ' '
R
read only
U
read and change
MULTIPLEX
Indicates multiplexing is possible for a table
CHAR
1
0
MULTIPLEX
D
Multiple of the original table
M
Original table for table multiplexing
SHLPEXI
Search help binding to table exists
CHAR
1
0
SHLPEXI
PROXYTYPE
DD: Is a generated proxy object
CHAR
1
0
DDPROXYTY
Is not proxy-generated
X
Is a generated proxy object
EXCLASS
DD: Ranking for include and subtype extension
NUMC
1
0
DDRANKING
0
Not classified
1
Cannot Be Enhanced
2
Can be enhanced (character-like)
3
Can be enhanced (character-like or numeric)
4
Can Be Enhanced (Deep)
WRONGCL
Enhancement category is incorrect
CHAR
1
0
DDWRONGCL
Classification is correct
X
Error during classification
ALWAYSTRP
Table is always transparent on selected databases
CHAR
1
0
DDALWAYSTRP
ALLDATAINCL
DD: DataAging: Handle data as hot and cold if switched on
CHAR
1
0
DDALLDATAINCLU
Read hot data only
X
Read hot and cold data
WITH_PARAMETERS
DD: Set whenever a view or base view has parameters
CHAR
1
0
DDWITHPAR
View Without Parameters
H
At least one view with parameters in call stack
U
At least one direct base view is a view with parameters
X
Parameterized View
EXVIEW_INCLUDED
DD: Contains at least one external view in the hierarchy
CHAR
1
0
DDEXTVIEW_INCLUDED
KEYMAX_FEATURE
DD: Maximum CL_DD_DBFEATURES=>KEYCNT_MAX1 Key Fields
CHAR
1
0
DDDBKEYMAXFEATURE
KEYLEN_FEATURE
DD: Maximum CL_DD_DBFEATURES=>KEYLEN_MAX1 Key Length
CHAR
1
0
DDDBKEYLENFEATURE
TABLEN_FEATURE
DD: Maximum Width CL_DD_DBFEATURES=>LEN_MAX1
CHAR
1
0
DDDBTABLENFEATURE
NONTRP_INCLUDED
At least one non-transparent table is contained here
CHAR
1
0
DDNONTRANSP_INCLUDED
VIEWREF
Name of SAP Table View
CHAR
30
0
VIEWNAME
VIEWREF_ERR
Replacement object cannot be used
CHAR
1
0
DDVIEWREF_ERR
VIEWREF_POS_CHG
Replacement object exists in different positions
CHAR
1
0
DDVIEWREF_POSCHG
TBFUNC_INCLUDED
Contains info whether a table function exists in hierarchy
CHAR
1
0
DDTBFUNC_INCLUDED
IS_GTT
Flag whether table is a global temporary table
CHAR
1
0
DD_IS_GTT
Not a global temporary table
N
Not a global temporary table (for unique parameter passing)
X
Global Temporary Table
SESSION_VAR_EX
DD: Does a session variable exist?
CHAR
1
0
DDSESSIONVAR_EX
U
Session variable exists in the view hierarchy
X
Sesssion variable exists directly in the view
FROM_ENTITY
DD: Table is generated from an entity DDL
CHAR
1
0
DDTABGEN_FROM_DDL
PK_IS_INVHASH
Create primary key as inverted hash/individual
CHAR
1
0
DDPK_IS_INVHASH
No inverted hash primary key
X
Primary key is created as inverted hash
USED_SESSION_VARS
DD: Session Variables Used
CHAR
6
0
DDUSEDSESSION_VARS
ABAP_LANGUAGE_VERSION
ABAP Language Version
CHAR
1
0
ABAP_LANGUAGE_VERSION
Standard
2
ABAP for Key Users
5
ABAP for Cloud Development
HDB_ONLY_ENTITY_INCLUDED
DD: Does a HDB entity occur?
CHAR
1
0
DDHDBONLY_ENTITY_INCLUDED
FIELD_SUFFIX
ABAP Dictionary: Field Suffix for TABL objects
CHAR
3
0
DDFIELDSUFFIX
QUOTA_MAX_FIELDS
ABAP Dictionary: Count of fields for TABL Quota
NUMC
5
0
DDQUOTAFIELDS
QUOTA_MAX_BYTES
ABAP Dictionary: Bytes for TABL Quota definition
NUMC
7
0
DDQUOTABYTES
QUOTA_SHARE_PARTNER
ABAP Dictionary: Party share for TABL Quota definition
NUMC
3
0
DDQUOTASHARE
QUOTA_SHARE_CUSTOMER
ABAP Dictionary: Party share for TABL Quota definition