Follow us on LinkedIn for your next SAP project

← Back to Search

SAP Table DD03L

Table Fields

DD03L (Table Fields) 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 DD03L to other SAP tables.

DD03L table fields

Field

Data element

Checktable

Datatype

Length

Decimals

Possible values

TABNAME

Table Name

TABNAME

DD02L

CHAR

FIELDNAME

Field Name

FIELDNAME

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

POSITION

Position of the field in the table

TABFDPOS

NUMC

KEYFLAG

Identifies a key field of a table

KEYFLAG

CHAR

Value	Description
NULL	No key field
X	Key field

MANDATORY

Flag: Field is required (not blank)

MANDATORY

CHAR

Value	Description
NULL	Do not set flag
X	Set flag

ROLLNAME

Data element (semantic domain)

ROLLNAME

DD04L

CHAR

CHECKTABLE

Check table name of the foreign key

CHECKTABLE

CHAR

ADMINFIELD

Nesting depth for includes

ADMINFIELD

CHAR

Value	Description
NULL	Do not set flag
X	Set flag

INTTYPE

ABAP data type (C,D,N,...)

INTTYPE

CHAR

Value	Description
C	Character String
N	Character String with Digits Only
D	Date (Date: YYYYMMDD)
T	Time (Time: HHMMSS)
X	Byte Seq. (heXadecimal), in DDIC metadata also for INT1/2/4
I	Integer number (4-byte integer with sign)
b	1-byte integer, integer number <= 254
s	2-byte integer, only for length field before LCHR or LRAW
P	Packed number
F	Floating point number to accuracy of 8 bytes
g	Character string with variable length (ABAP type STRING)
y	Byte sequence with variable length (ABAP type XSTRING)
u	Structured type, flat
v	Structured type, deep
h	Table type
V	Character string (old Dictionary type VARC)
r	Reference to class/interface
l	Reference to data object
a	Decimal Floating Point Number, 16 Digits
e	Decimal Floating Point Number, 34 Digits
j	Static Boxed Components
k	Generic Boxed Components

INTLEN

Internal Length in Bytes

INTLEN

NUMC

REFTABLE

Table for reference field

REFTABLE

CHAR

PRECFIELD

Name of included table

PRECFIELD

CHAR

REFFIELD

Reference field for currency and qty fields

REFFIELD

CHAR

CONROUT

Check or generating module for fields

CONROUT

CHAR

NOTNULL

Indicator that NOT NULL is forced for this field

NOTNULL

CHAR

Value	Description
X	NOT NULL forced
NULL	Any NULL or NOT NULL
N	NULL forced

DATATYPE

Data Type in ABAP Dictionary

DATATYPE_D

CHAR

Value	Description
ACCP	Posting period YYYYMM
CHAR	Character String
CLNT	Client
CUKY	Currency key, referenced by CURR fields
CURR	Currency field, stored as DEC
D16D	Decimal Floating Point, 16 Digits, DEC on Database
D16R	Decimal Floating Point, 16 Digits, RAW on Database
D16S	Decimal Floating Point. 16 Digits, with Scale Field
D34D	Decimal Floating Point, 34 Digits, DEC on Database
D34R	Decimal Floating Point, 34 Digits, RAW on Database
D34S	Decimal Floating Point, 34 Digits, with Scale Field
DATS	Date field (YYYYMMDD) stored as char(8)
DEC	Counter or amount field with comma and sign
FLTP	Floating point number, accurate to 8 bytes
INT1	1-byte integer, integer number <= 255
INT2	2-byte integer, only for length field before LCHR or LRAW
INT4	4-byte integer, integer number with sign
LANG	Language key
LCHR	Long character string, requires preceding INT2 field
LRAW	Long byte string, requires preceding INT2 field
NUMC	Character string with only digits
PREC	Obsolete data type, do not use
QUAN	Quantity field, points to a unit field with format UNIT
RAW	Uninterpreted sequence of bytes
RSTR	Byte String of Variable Length
SSTR	Short Character String of Variable Length
STRG	Character String of Variable Length
TIMS	Time field (hhmmss), stored as char(6)
UNIT	Unit key for QUAN fields
VARC	Long character string, no longer supported from Rel. 3.0

LENG

Length (No. of Characters)

DDLENG

NUMC

DECIMALS

Number of Decimal Places

DECIMALS

NUMC

DOMNAME

Domain name

DOMNAME

DD01L

CHAR

SHLPORIGIN

Origin of an Input Help

SHLPORIGIN

CHAR

Value	Description
X	Explicit search help attachment to field
P	Input help implemented with check table
D	Explicit search help attachment to data element
F	Input help with fixed values
T	Input help based on data type
NULL	No input help exists

TABLETYPE

DD: Flag if it is a table

DDTABTYPE

CHAR

Value	Description
X	Yes / TRUE
NULL	No / FALSE

DEPTH

DD: Depth for structured types

TYPEDEPTH

NUMC

COMPTYPE

DD: Component Type

COMPTYPE

CHAR

Value	Description
E	Data element
NULL	Built-in type
S	Structured type (possibly as INCLUDE)
L	Table type
N	Reference to non-active type

REFTYPE

Type of Object Referenced

DDREFTYPE

CHAR

Value	Description
NULL	No Information
A	ANY
O	Object
D	DATA
B	Built-In Dictionary Type
E	Data Element
S	Structured Type
L	Table Type
C	Class
I	Interface

LANGUFLAG

DD: Indicator for a Language Field

DDLANGUFLG

CHAR

Value	Description
NULL	Not selected as language field
X	Field selected as language field

DBPOSITION

Position of the field in the table

TABFDPOS

NUMC

ANONYMOUS

Anonymization Indicator (for User Fields)

DDANONYM

CHAR

Value	Description
NULL	No Anonymity
X	Anonymity

OUTPUTSTYLE

DD: Output Style (Output Style) for Decfloat Types

OUTPUTSTYLE

NUMC

Value	Description
00	Normal
01	Sign right
02	Scale-preserving
03	Scientific
04	Scientific with leading zero
05	Scale-preserving scientific
06	Engineering

DD03L foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table	Check field
DD03L	DOMNAME	DD03L	DOMNAME	DD01L Domains	DOMNAME
DD03L	DOMNAME	*		DD01L Domains	AS4LOCAL
DD03L	DOMNAME	*		DD01L Domains	AS4VERS
DD03L	ROLLNAME	DD03L	ROLLNAME	DD04L Data elements	ROLLNAME
DD03L	ROLLNAME	*		DD04L Data elements	AS4LOCAL
DD03L	ROLLNAME	*		DD04L Data elements	AS4VERS
DD03L	TABNAME	DD03L	TABNAME	DD02L SAP Tables	TABNAME
DD03L	TABNAME	*		DD02L SAP Tables	AS4LOCAL
DD03L	TABNAME	*		DD02L SAP Tables	AS4VERS