Follow us on LinkedIn for your next SAP project

← Back to Search

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

Possible values

TABNAME

Table Name

TABNAME

DD02L

CHAR

AS4LOCAL

Activation Status of a Repository Object

AS4LOCAL

CHAR

Value	Description
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

TABKAT

Size category

TABKAT

CHAR

Value	Description
NULL	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

PUFFERUNG

Buffering type indicator

PUFFERUNG

CHAR

Value	Description
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

PROTOKOLL

Log Data Changes

DDPROTOCOL

CHAR

Value	Description
NULL	No logging
X	Logging

SPEICHPUFF

Flag for the storage type in the buffer

SPEICHPUFF

CHAR

Value	Description
X	Store compressed in buffer (X)
NULL	Store uncompressed in buffer (SPACE)

AS4USER

Last Changed by

AS4USER

CHAR

AS4DATE

Date of Last Change

AS4DATE

DATS

AS4TIME

Last changed at

AS4TIME

TIMS

TRANSPFLAG

Convert to transparent table or maintain transparency

DDTRANSP

CHAR

Value	Description
NULL	No setting
X	Convert to transparent table or retain this type

RESERVE

Reserved field in the ABAP Dictionary

DDRESERVE

CHAR

UEBERSETZ

Flag whether table is relevant for translation

UEBERSETZ

CHAR

Value	Description
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

Value	Description
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

Value	Description
N	Buffering not allowed
X	Buffering switched on
A	Buffering allowed but switched off

JAVAONLY

Write access only with JAVA

DDJAVAONLY

CHAR

Value	Description
NULL	FALSE
X	TRUE

ROWORCOLST

For distinction between Row or Column Store

DDROWORCOLST

CHAR

Value	Description
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