SAP DD02V Generated Table for View Table data and field list

DD02V is a standard SAP Table View which is used to store Generated Table for View data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The DD02V table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include DDLANGUAGE (Language Key), TABCLASS (Table category), SQLTAB (Name of an SQL table or an appended table), DATMIN (Minimum no. of entries)... 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. .

DD02V table view Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP DD02V table view 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 DD02V 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 TABNAMECHAR30AS4TABDTB
DDLANGUAGELanguage Key DDLANGUAGELANG1ISOLASPRAS
TABCLASSTable category TABCLASSCHAR8TABCLASS
SQLTABName of an SQL table or an appended table SQLAPPDTABCHAR30AS4TAB
DATMINMinimum no. of entries DATMINNUMC10DATANZ
DATMAXMaximum no. of entries DATMAXNUMC10DATANZ
DATAVGAverage number of entries DATAVGNUMC10DATANZ
CLIDEPFlag indicating client-specific entries CLIDEPCHAR1CLIDEP
BUFFEREDBuffering flag BUFFEREDCHAR1BUFFERED
COMPRFLAGField compression indicator COMPREXCHAR1AS4FLAG
LANGDEPLanguage dependency LANGDEPCHAR1LANGDEP
DDTEXTShort Description of Repository Objects AS4TEXTCHAR60AS4TEXT
ACTFLAGActivation flag ACTFLAGCHAR1ACTFLAG
APPLCLASSApplication class for DD objects (not used) APPLCLASSCHAR4APPLCLASSAPP
AUTHCLASSActivation type AUTHCLASS_NUMC2AUTHCLASS
AS4USERLast Changed by AS4USERCHAR12AS4USER
AS4DATEDate of Last Change AS4DATEDATS8AS4DATE
AS4TIMELast changed at AS4TIMETIMS6AS4TIME
MASTERLANGOriginal Language in Repository objects MASTERLANGLANG1ISOLASPRASH_T002
MAINFLAGFlag if Maintenance with Standard Tools is allowed MAINTFLAGCHAR1MAINTFLAG
CONTFLAGDelivery class CONTFLAGCHAR1CONTFLAG
RESERVETABSDIC: Reserve for tables RESERVETABCHAR4CHAR4
GLOBALFLAGFlag for private DD objects (not used) GLOBALFLAGCHAR1GLOBALFLAG
PROZPUFFPercentage for buffers PROZPUFFNUMC3PROZPUFF
VIEWCLASSView Type VIEWCLASSCHAR1VIEWCLASS
VIEWGRANTMaintenance status (modif. authorization) for view data VIEWGRANTCHAR1VIEWGRANT
MULTIPLEXIndicator whether multiplexing is possible for a table MULTIPLEXCHAR1MULTIPLEX
SHLPEXISearch help attachment to table exists SHLPEXICHAR1DDBOOL
PROXYTYPEDD: Is a generated proxy object DDPROXYTYCHAR1DDPROXYTY
EXCLASSDD: Ranking for include and subtype extension DDRANKINGNUMC1DDRANKING
WRONGCLEnhancement category is incorrect DDWRONGCLCHAR1DDWRONGCL
ALWAYSTRPTable is always transparent on selective database DDALWAYSTRPCHAR1DDALWAYSTRP

Key field Non-key field



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

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

SELECT SINGLE *
FROM DD02V
INTO CORRESPONDING FIELDS OF WA_DD02V
WHERE...

How to access SAP table DD02V

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

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