SAP DD09L DD: Technical settings of tables Table data and field list

DD09L is a standard SAP Table which is used to store DD: Technical settings of tables data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The DD09L table consists of various fields, each holding specific information or linking keys about DD: Technical settings of tables data available in SAP. These include AS4LOCAL (Activation Status of a Repository Object), AS4VERS (Version of the entry (not used)), TABKAT (Size category), TABART (Data class in technical settings)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

DD09L table Technical Details:

Delivery Class: W - System table, contents transportable via separate TR objects
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP DD09L table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the DD09L table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
TABNAMETable Name TABNAMECHAR30DD02LAS4TABDTB
AS4LOCALActivation Status of a Repository Object AS4LOCALCHAR1AS4LOCAL
AS4VERSVersion of the entry (not used) AS4VERSNUMC4AS4VERS
TABKATSize category TABKATCHAR2TABKAT
TABARTData class in technical settings TABARTCHAR5DDARTTABART
PUFFERUNGBuffering type indicator PUFFERUNGCHAR1PUFFERUNG
SCHFELDANZNo. of key fields for generic buffers SCHFELDANZNUMC3SCHFELDANZ
PROTOKOLLLog Data Changes DDPROTOCOLCHAR1DDPROTOCOL
SPEICHPUFFFlag for the storage type in the buffer SPEICHPUFFCHAR1SPEICHPUFF
AS4USERLast Changed by AS4USERCHAR12AS4USER
AS4DATEDate of Last Change AS4DATEDATS8AS4DATE
AS4TIMELast changed at AS4TIMETIMS6AS4TIME
TRANSPFLAGConvert to transparent table or maintain transparency DDTRANSPCHAR1DDTRANSP
RESERVEReserved field in the ABAP Dictionary DDRESERVECHAR1DDRESERV
UEBERSETZFlag whether table is relevant for translation UEBERSETZCHAR1UEBERSETZ
ACTFLAGActivation flag ACTFLAGCHAR1ACTFLAG
BUFALLOWIndicator for buffering allowed/not allowed BUFALLOWCHAR1BUFALLOW
JAVAONLYWrite access only with JAVA DDJAVAONLYCHAR1DDBOOL
ROWORCOLSTFor distinction between Row or Column Store DDROWORCOLSTCHAR1DDROWORCOLST

Key field Non-key field



How do I retrieve data from SAP table DD09L using ABAP code

The following ABAP code Example will allow you to do a basic selection on DD09L to SELECT all data from the table
DATA: WA_DD09L TYPE DD09L.

SELECT SINGLE *
FROM DD09L
INTO CORRESPONDING FIELDS OF WA_DD09L
WHERE...

How to access SAP table DD09L

Within an ECC or HANA version of SAP you can also view further information about DD09L and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).