1. Home
  2. Resources
  3. SAP Tables
  4. DD09L - DD: Technical settings of tables

SAP Table DD09L

DD: Technical settings of tables

DD09L (DD: Technical settings of 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 DD09L to other SAP tables.

DD09L table fields

Field Data element Checktable Datatype Length Decimals
TABNAME Table Name TABNAME DD02L 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
TABKAT Size category TABKAT CHAR 2 0
0 Tables < 500K
1 Tables < 1.5 MB
2 Tables < 6.5 MB
3 Tables < 25 MB
4 Tables > 160 MB
5 Value cannot be maintained manually (Early Watch value)
6 Value cannot be maintained manually (Early Watch value)
7 Value cannot be maintained manually (Early Watch value)
8 Value cannot be maintained manually (Early Watch value)
9 Value cannot be maintained manually (Early Watch value)
10 Value cannot be maintained manually (Early Watch value)
11 Value cannot be maintained manually (Early Watch value)
12 Value cannot be maintained manually (Early Watch value)
13 Value cannot be maintained manually (Early Watch value)
14 Value cannot be maintained manually (Early Watch value)
TABART Data class in technical settings TABART DDART CHAR 5 0
PUFFERUNG Buffering type indicator PUFFERUNG CHAR 1 0
NULL No buffering
P Single entries of table were buffered
G Full buffering corresp. to generic key
X Table is completely transferrred to buffer
SCHFELDANZ No. of key fields for generic buffers SCHFELDANZ NUMC 3 0
PROTOKOLL Log Data Changes DDPROTOCOL CHAR 1 0
NULL No logging
X Logging
SPEICHPUFF Flag for the storage type in the buffer SPEICHPUFF CHAR 1 0
X Store compressed in buffer (X)
NULL Store uncompressed in buffer (SPACE)
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
TRANSPFLAG Convert to transparent table or maintain transparency DDTRANSP CHAR 1 0
NULL No setting
X Convert to transparent table or retain this type
RESERVE Reserved field in the ABAP Dictionary DDRESERVE CHAR 1 0
UEBERSETZ Flag whether table is relevant for translation UEBERSETZ CHAR 1 0
X Translation using standard translation procedure
L Load table: text and translation are generated automatically
T Translation only possible with object-specific tools
N Table is language-dependent but not translation-relevant
NULL Table does not contain a language key
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
BUFALLOW Indicator for buffering allowed/not allowed BUFALLOW CHAR 1 0
N Buffering not allowed
X Buffering switched on
A Buffering allowed but switched off
JAVAONLY Write access only with JAVA DDJAVAONLY CHAR 1 0
NULL FALSE
X TRUE
ROWORCOLST For distinction between Row or Column Store DDROWORCOLST CHAR 1 0
R Row Store Table
C Column Store Table
NULL Column Store Table (Default)

DD09L foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
DD09L TABART DD09L TABART DDART DD: Data Class in Technical Settings TABART
DD09L TABNAME DD09L TABNAME DD02L SAP Tables TABNAME
DD09L TABNAME DD09L AS4LOCAL DD02L SAP Tables AS4LOCAL
DD09L TABNAME DD09L AS4VERS DD02L SAP Tables AS4VERS