1. Home
  2. Resources
  3. SAP Tables
  4. DD03N - Generated Table for View

SAP Table DD03N

Generated Table for View

DD03N (Generated Table for View) 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 DD03N to other SAP tables.

DD03N table fields

Field Data element Checktable Datatype Length Decimals
TABNAME Table Name TABNAME DD02L CHAR 30 0
FIELDNAME Field Name FIELDNAME CHAR 30 0
FLDSTAT Activation Status of a Repository Object AS4LOCAL CHAR 1 0
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
ROLLSTAT Activation Status of a Repository Object AS4LOCAL CHAR 1 0
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
DOMSTAT Activation Status of a Repository Object AS4LOCAL CHAR 1 0
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
POSITION Position of the field in the table TABFDPOS NUMC 4 0
KEYFLAG Identifies a key field of a table KEYFLAG CHAR 1 0
NULL No key field
X Key field
MANDATORY Flag: Field is required (not blank) MANDATORY CHAR 1 0
NULL Do not set flag
X Set flag
ROLLNAME Data element (semantic domain) ROLLNAME DD04L CHAR 30 0
CHECKTABLE Check table name of the foreign key CHECKTABLE CHAR 30 0
ADMINFIELD Nesting depth for includes ADMINFIELD CHAR 1 0
NULL Do not set flag
X Set flag
INTTYPE ABAP data type (C,D,N,...) INTTYPE CHAR 1 0
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 6 0
REFTABLE Table for reference field REFTABLE CHAR 30 0
PRECFIELD Name of included table PRECFIELD CHAR 30 0
REFFIELD Reference field for currency and qty fields REFFIELD CHAR 30 0
CONROUT Check or generating module for fields CONROUT CHAR 10 0
DOMNAME Domain name DOMNAME DD01L CHAR 30 0
ROUTPUTLEN Length (No. of Characters) DDLENG NUMC 6 0
MEMORYID Set/Get parameter ID MEMORYID TPARA CHAR 20 0
LOGFLAG Indicator for writing change documents LOGFLAG CHAR 1 0
NULL Do not set flag
X Set flag
HEADLEN Maximum length of heading HEADLEN NUMC 2 0
SCRLEN1 Max. length for short field label SCRLEN_S NUMC 2 0
SCRLEN2 Max. length for medium field label SCRLEN_M NUMC 2 0
SCRLEN3 Max. length for long field label SCRLEN_L NUMC 2 0
ACTFLAG Activation flag DTACTFLAG CHAR 1 0
NULL All changes already propagated to the dependent tables
I Dependent tables must be activated
D Screen time stamp for dependent tables must be set
N Nametab of the dependent tables must be regenerated
APPLCLASS Application class for DD objects (not used) APPLCLASS CHAR 4 0
AUTHCLASS Activation type AUTHCLASS_ NUMC 2 0
01 Nametab generation not in online (only via C program)
02 C structures must be adapted when tables are changed
10 Initial table required before R3TRANS runs
00 No classification
AS4USER Last Changed by AS4USER CHAR 12 0
AS4DATE Date of Last Change AS4DATE DATS 8 0
AS4TIME Last changed at AS4TIME TIMS 6 0
DTELMASTER Original Language in Repository objects MASTERLANG LANG 1 0
RESERVEDTE SDIC: Reserve for data elements (not used) RESERVEDTE CHAR 4 0
DTELGLOBAL Flag for private DD objects (not used) GLOBALFLAG CHAR 1 0
NULL Global DE object
X Application-dependent DE object
T Table-dependent DD object
DATATYPE Data Type in ABAP Dictionary DATATYPE_D CHAR 4 0
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 6 0
OUTPUTLEN Output Length OUTPUTLEN NUMC 6 0
DECIMALS Number of Decimal Places DECIMALS NUMC 6 0
LOWERCASE Lowercase letters allowed/not allowed LOWERCASE CHAR 1 0
NULL Do not set flag
X Set flag
SIGNFLAG Flag for sign in numerical fields SIGNFLAG CHAR 1 0
NULL Do not set flag
X Set flag
LANGFLAG Flag for language-dependent values(not used) LANGFLAG CHAR 1 0
NULL Do not set flag
X Set flag
VALEXI Existence of fixed values VALEXI CHAR 1 0
NULL Do not set flag
X Set flag
ENTITYTAB Value table ENTITYTAB DD02L CHAR 30 0
CONVEXIT Conversion Routine CONVEXIT CHAR 5 0
MASK Template (not used) AS4MASK CHAR 20 0
MASKLEN Template length (not used) MASKLEN NUMC 4 0
ACTFLAG1 Activation flag ACTFLAG CHAR 1 0
NULL Start of activation or activation successful
I Internal checks successful
U External checks for object OK or table as dependent faulty
APPLCLASS1 Application class for DD objects (not used) APPLCLASS CHAR 4 0
AUTHCLASS1 Activation type AUTHCLASS_ NUMC 2 0
01 Nametab generation not in online (only via C program)
02 C structures must be adapted when tables are changed
10 Initial table required before R3TRANS runs
00 No classification
AS4USER1 Last Changed by AS4USER CHAR 12 0
AS4DATE1 Date of Last Change AS4DATE DATS 8 0
AS4TIME1 Last changed at AS4TIME TIMS 6 0
DOMMASTER Original Language in Repository objects MASTERLANG LANG 1 0
RESERVEDOM Reserve for domains (not used) RESERVEDOM CHAR 4 0
DOMGLOBAL Flag for private DD objects (not used) GLOBALFLAG CHAR 1 0
NULL Global DE object
X Application-dependent DE object
T Table-dependent DD object

DD03N foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
DD03N DOMNAME DD03N DOMNAME DD01L Domains DOMNAME
DD03N DOMNAME * DD01L Domains AS4LOCAL
DD03N DOMNAME * DD01L Domains AS4VERS
DD03N ENTITYTAB DD03N ENTITYTAB DD02L SAP Tables TABNAME
DD03N ENTITYTAB * DD02L SAP Tables AS4LOCAL
DD03N ENTITYTAB * DD02L SAP Tables AS4VERS
DD03N MEMORYID DD03N MEMORYID TPARA Directory of Memory IDs PARAMID
DD03N ROLLNAME * DD04L Data elements AS4VERS
DD03N ROLLNAME DD03N ROLLNAME DD04L Data elements ROLLNAME
DD03N ROLLNAME * DD04L Data elements AS4LOCAL
DD03N TABNAME DD03N TABNAME DD02L SAP Tables TABNAME
DD03N TABNAME * DD02L SAP Tables AS4LOCAL
DD03N TABNAME * DD02L SAP Tables AS4VERS