1. Home
  2. Resources
  3. SAP Tables
  4. DD02L - SAP Tables

SAP Table DD02L

SAP Tables

DD02L (SAP Tables) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link DD02L to other SAP tables.

Source: DD02L (SAP Tables)

DD02L table fields

Field Data element Checktable Datatype Length Decimals
TABNAME Table Name TABNAME CHAR 30 0
AS4LOCAL Activation Status of a Repository Object AS4LOCAL CHAR 1 0
A Entry activated or generated in this form
L Lock entry (first N version)
N Entry edited, but not activated
S Previously active entry, backup copy
T Temporary version when editing
AS4VERS Version of the entry (not used) AS4VERS NUMC 4 0
TABCLASS Table category TABCLASS CHAR 8 0
TRANSP Transparent table
INTTAB Structure
CLUSTER Cluster table
POOL Pooled table
VIEW General view structure
APPEND Append structure
SQLTAB Name of an SQL table or an appended table SQLAPPDTAB CHAR 30 0
DATMIN Minimum no. of entries DATMIN NUMC 10 0
DATMAX Maximum no. of entries DATMAX NUMC 10 0
DATAVG Average number of entries DATAVG NUMC 10 0
CLIDEP Flag indicating client-specific entries CLIDEP CHAR 1 0
NULL No client-dependence, valid throughout system
X Client-dependent, valid only for current client
BUFFERED Buffering flag BUFFERED CHAR 1 0
NULL ' ': buffering not allowed
X 'X': buffering allowed
E 'E': buffering allowed (internal indicator)
COMPRFLAG Field compression indicator COMPREX CHAR 1 0
NULL Do not set flag
X Set flag
LANGDEP Language dependency LANGDEP CHAR 1 0
NULL Table may not contain INCLUDE to other tables
X Table contains only INCLUDE to other tables
ACTFLAG Activation flag ACTFLAG CHAR 1 0
NULL Start of activation or activation successful
I Internal checks successful
U External checks for object OK or table as dependent faulty
APPLCLASS Application class for DD objects (not used) APPLCLASS CHAR 4 0
AUTHCLASS Activation type AUTHCLASS_ NUMC 2 0
01 Nametab generation not in online (only via C program)
02 C structures must be adapted when tables are changed
10 Initial table required before R3TRANS runs
00 No classification
AS4USER Last Changed by AS4USER CHAR 12 0
AS4DATE Date of Last Change AS4DATE DATS 8 0
AS4TIME Last changed at AS4TIME TIMS 6 0
MASTERLANG Original Language in Repository objects MASTERLANG LANG 1 0
MAINFLAG Flag if Maintenance with Standard Tools is allowed MAINTFLAG CHAR 1 0
NULL Display/Maintenance Allowed with Restrictions
X Display/Maintenance Allowed
N Display/Maintenance Not Allowed
CONTFLAG Delivery class CONTFLAG CHAR 1 0
A Application table (master and transaction data)
C Customizing table, maintenance only by cust., not SAP import
L Table for storing temporary data, delivered empty
G Customizing table, protected against SAP Upd., only INS all.
E Control table, SAP and customer have separate key areas
S System table, maint. only by SAP, change = modification
W System table, contents transportable via separate TR objects
RESERVETAB SDIC: Reserve for tables RESERVETAB CHAR 4 0
GLOBALFLAG Flag for private DD objects (not used) GLOBALFLAG CHAR 1 0
NULL Global DE object
X Application-dependent DE object
T Table-dependent DD object
PROZPUFF Percentage for buffers PROZPUFF NUMC 3 0
VIEWCLASS View Type VIEWCLASS CHAR 1 0
H Help View
D Database View
P Projection View
S Structure view, data selection not possible
C Maintenance View
E Entity View (no longer supported)
V View Variant
A Append View
X External View
R Replication Projection View
VIEWGRANT Maintenance status (modif. authorization) for view data VIEWGRANT CHAR 1 0
R read only
U read and change
M Time-dependent views: like U, validity data like ' '
NULL read, change, delete and insert
MULTIPLEX Indicator whether multiplexing is possible for a table MULTIPLEX CHAR 1 0
M Original table for table multiplexing
D Multiple of the original table
SHLPEXI Search help attachment to table exists SHLPEXI CHAR 1 0
NULL FALSE
X TRUE
PROXYTYPE DD: Is a generated proxy object DDPROXYTY CHAR 1 0
X Is a generated proxy object
NULL Is not proxy-generated
EXCLASS DD: Ranking for include and subtype extension DDRANKING NUMC 1 0
0 Not classified
1 Cannot Be Enhanced
2 Can be enhanced (character-type)
3 Can be enhanced (character-type or numeric)
4 Can Be Enhanced (Deep)
WRONGCL Enhancement category is incorrect DDWRONGCL CHAR 1 0
NULL Classification is correct
X Error during classification
ALWAYSTRP Table is always transparent on selective database DDALWAYSTRP CHAR 1 0