DD03L SAP (Table Fields) Table details
Dictionary Type: Table
Description: Table Fields
Description: Table Fields
Table field list including key, data, relationships and ABAP select examples
DD03L is a standard SAP Table which is used to store Table Fields data and is available within R/3 SAP systems depending on the version and release level.
The DD03L table consists of various fields, each holding specific information or linking keys about Table Fields data available in SAP. These include FIELDNAME (Field Name), AS4LOCAL (Activation Status of a Repository Object), AS4VERS (Version of the entry (not used)), POSITION (Position of the field in the table).. 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. .
Delivery Class: W - System table, contents transportable via separate TR objectsDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
Text table = /SAPSLL/TCOEUIT
SAP DD03L table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
TABNAME | Table Name | TABNAME | CHAR | 30 | DD02L | AS4TAB | DTB | ||
FIELDNAME | Field Name | FIELDNAME | CHAR | 30 | FDNAME | DFD | |||
AS4LOCAL | Activation Status of a Repository Object | AS4LOCAL | CHAR | 1 | AS4LOCAL | ||||
AS4VERS | Version of the entry (not used) | AS4VERS | NUMC | 4 | AS4VERS | ||||
POSITION | Position of the field in the table | TABFDPOS | NUMC | 4 | AS4POS | ||||
KEYFLAG | Identifies a key field of a table | KEYFLAG | CHAR | 1 | KEYFLAG | ||||
MANDATORY | Flag: Field is required (not blank) | MANDATORY | CHAR | 1 | AS4FLAG | ||||
ROLLNAME | Data element (semantic domain) | ROLLNAME | CHAR | 30 | DD04L | ROLLNAME | ROL | DD_DTEL | |
CHECKTABLE | Check table name of the foreign key | CHECKTABLE | CHAR | 30 | Assigned to domain | AS4TAB | |||
ADMINFIELD | Nesting depth for includes | ADMINFIELD | CHAR | 1 | AS4FLAG | ||||
INTTYPE | ABAP data type (C,D,N,...) | INTTYPE | CHAR | 1 | INTTYPE | ||||
INTLEN | Internal Length in Bytes | INTLEN | NUMC | 6 | DDLENG | ||||
REFTABLE | Table for reference field | REFTABLE | CHAR | 30 | Assigned to domain | AS4TAB | |||
PRECFIELD | Name of included table | PRECFIELD | CHAR | 30 | Assigned to domain | FDNAME | |||
REFFIELD | Reference field for currency and qty fields | REFFIELD | CHAR | 30 | Assigned to domain | FDNAME | |||
CONROUT | Check or generating module for fields | CONROUT | CHAR | 10 | CHAR10 | ||||
NOTNULL | Indicator that NOT NULL is forced for this field | NOTNULL | CHAR | 1 | NOTNULL | ||||
DATATYPE | Data Type in ABAP Dictionary | DATATYPE_D | CHAR | 4 | DTYPE | DATATYPE | |||
LENG | Length (No. of Characters) | DDLENG | NUMC | 6 | DDLENG | ||||
DECIMALS | Number of Decimal Places | DECIMALS | NUMC | 6 | DDLENG | ||||
DOMNAME | Domain name | DOMNAME | CHAR | 30 | DD01L | DOMNAME | DD_DOMA | ||
SHLPORIGIN | Origin of an Input Help | SHLPORIGIN | CHAR | 1 | SHLPORIGIN | ||||
TABLETYPE | DD: Flag if it is a table | DDTABTYPE | CHAR | 1 | DDFLAG | ||||
DEPTH | DD: Depth for structured types | TYPEDEPTH | NUMC | 2 | TYPEDEPTH | ||||
COMPTYPE | DD: Component Type | COMPTYPE | CHAR | 1 | COMPTYPE | ||||
REFTYPE | Type of Object Referenced | DDREFTYPE | CHAR | 1 | DDREFTYPE | ||||
LANGUFLAG | DD: Indicator for a Language Field | DDLANGUFLG | CHAR | 1 | DDLANGUFLG | ||||
DBPOSITION | Position of the field in the table | TABFDPOS | NUMC | 4 | AS4POS | ||||
ANONYMOUS | Anonymization Indicator (for User Fields) | DDANONYM | CHAR | 1 | DDANONYM | ||||
OUTPUTSTYLE | DD: Output Style (Output Style) for Decfloat Types | OUTPUTSTYLE | NUMC | 2 | OUTPUTSTYLE |
Key field | Non-key field |
How do I retrieve data from SAP table DD03L using ABAP code
The following ABAP code Example will allow you to do a basic selection on DD03L to SELECT all data from the tableDATA: WA_DD03L TYPE DD03L.
SELECT SINGLE *
FROM DD03L
INTO CORRESPONDING FIELDS OF WA_DD03L
WHERE...
How to access SAP table DD03L
Within an ECC or HANA version of SAP you can also view further information about DD03L and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects