SAP table DD03L (Table Fields)

SAP table DD03L (Table Fields) is a standard table in the SAP system that stores metadata about the structure of other tables. It contains detailed information about the fields of database tables, such as field names, data elements, data types, lengths, and other attributes. This table is essential for understanding the technical details of table structures in SAP, making it a valuable resource for developers and technical consultants working with the Data Dictionary. Table DD03L is also used to display the SAP data dictionary on this website.

SAP table DD03L has 5 primary key fields being TABNAME,FIELDNAME,AS4LOCAL,AS4VERS,POSITION.

Field Description Data Type Length Decimals Checktable Data Element
TABNAME Table Name CHAR 30 0 DD02L TABNAME
FIELDNAME Field Name CHAR 30 0 FIELDNAME
AS4LOCAL 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
AS4VERS Version of the entry (not used) NUMC 4 0 AS4VERS
POSITION Position of the field in the table NUMC 4 0 TABFDPOS
KEYFLAG Identifies a key field of a table CHAR 1 0 KEYFLAG
No key field
X Key field
MANDATORY Flag: Field is required (not blank) CHAR 1 0 MANDATORY
ROLLNAME Data element (semantic domain) CHAR 30 0 DD04L ROLLNAME
CHECKTABLE Check table name of the foreign key CHAR 30 0 CHECKTABLE
ADMINFIELD Nesting depth for includes CHAR 1 0 ADMINFIELD
INTTYPE ABAP data type (C,D,N,...) CHAR 1 0 INTTYPE
8 Whole Number (8-Byte Integer with Sign)
a Decimal Floating Point Number, 16 Digits
b 1-byte integer, whole number <= 254
C Character String
D Date (YYYYMMDD)
e Decimal Floating Point Number, 34 Digits
F Floating point number to accuracy of 8 bytes
g Character string with variable length (ABAP type STRING)
h Table type
I Integer number (4-byte integer with sign)
j Static Boxed Components
k Generic Boxed Components
l Reference to data object
N Character String with Digits Only
P Packed number
p Time stamp 'yyyy-mm-dd hh:mm:ss[.nnnnnnn]'
r Reference to class/interface
s 2-byte integer, only for length field before LCHR or LRAW
T Time (HHMMSS)
u Structured type, flat
V Character string (old dictionary type VARC)
v Structured type, deep
X Byte string (hexadecimal), in DDIC metadata also INT1/2/4
y Byte string with variable length (ABAP type XSTRING)
z Node Line for Stuctured Objects
INTLEN Internal Length in Bytes NUMC 6 0 INTLEN
REFTABLE Reference Table for Field CHAR 30 0 REFTABLE
PRECFIELD Name of included table CHAR 30 0 PRECFIELD
REFFIELD Reference Field for Currency and Quantity Fields CHAR 30 0 REFFIELD
CONROUT Check or generating module for fields CHAR 10 0 CONROUT
NOTNULL Indicator for initial values in database fields CHAR 1 0 NOTNULL
Either NULL or NOT NULL
N Force NULL
X Force NOT NULL
DATATYPE Data Type in ABAP Dictionary CHAR 4 0 DATATYPE_D
LENG Length (No. of Characters) NUMC 6 0 DDLENG
DECIMALS Number of Decimal Places NUMC 6 0 DECIMALS
DOMNAME Domain name CHAR 30 0 DD01L DOMNAME
SHLPORIGIN Origin of an Input Help CHAR 1 0 SHLPORIGIN
No input help exists
D Explicit search help interface to data element
F Input help with fixed values
P Input help implemented with check table
T Input help based on data type
X Explicit search help interface to field
TABLETYPE DD: Flag if it is a table CHAR 1 0 DDTABTYPE
DEPTH DD: Depth for structured types NUMC 2 0 TYPEDEPTH
COMPTYPE DD: Component Type CHAR 1 0 COMPTYPE
Built-in type
E Data element
L Table type
N Reference to non-active type
S Structured type (possibly as INCLUDE)
REFTYPE Type of Object Referenced CHAR 1 0 DDREFTYPE
No Information
A ANY
B Built-in dictionary type
C Class
D DATA
E Data Element
I Interface
L Table Type
O Object
S Structured Type
LANGUFLAG DD: Indicator for a Language Field CHAR 1 0 DDLANGUFLG
Not selected as language field
X Field selected as language field
DBPOSITION Position of the field in the table NUMC 4 0 TABFDPOS
ANONYMOUS Anonymization Indicator (for User Fields) CHAR 1 0 DDANONYM
Anonymity undefined
N No anonymity
X Anonymity
OUTPUTSTYLE DD: Output Style (Output Style) for Decfloat Types NUMC 2 0 OUTPUTSTYLE
00 Normal
01 Sign right
02 Scale-preserving
03 Scientific
04 Scientific with leading zero
05 Scale-preserving scientific
06 Engineering
SRS_ID Spatial Reference System INT4 10 0 SRS_ID

DD03L foreign key relationships

Table Field Check Table Check Field
0 DD03L DOMNAME DD01L Domains DOMNAME
0 DD03L DOMNAME DD01L Domains AS4LOCAL
0 DD03L DOMNAME DD01L Domains AS4VERS
1 DD03L ROLLNAME DD04L Data elements ROLLNAME
1 DD03L ROLLNAME DD04L Data elements AS4LOCAL
1 DD03L ROLLNAME DD04L Data elements AS4VERS
0 DD03L TABNAME DD02L SAP Tables TABNAME
0 DD03L TABNAME DD02L SAP Tables AS4LOCAL
0 DD03L TABNAME DD02L SAP Tables AS4VERS