SAP DD25V Generated Table for View Table data and field list

DD25V 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 DD25V table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include AS4LOCAL (Activation Status of a Repository Object), AS4VERS (Version of the entry (not used)), DDLANGUAGE (Language Key), AGGTYPE (Aggregate Type)... 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. .

DD25V table view Technical Details:

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


SAP DD25V 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 DD25V 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
VIEWNAMEName of SAP table view VIEWNAMECHAR30VIEWNAMEDVI
AS4LOCALActivation Status of a Repository Object AS4LOCALCHAR1AS4LOCAL
AS4VERSVersion of the entry (not used) AS4VERSNUMC4AS4VERS
DDLANGUAGELanguage Key DDLANGUAGELANG1ISOLASPRAS
AGGTYPEAggregate Type AGGTYPECHAR1AGGTYPE
APPLCLASSApplication class for DD objects (not used) APPLCLASSCHAR4TAPPLAPPLCLASSAPP
AUTHCLASSActivation type AUTHCLASS_NUMC2AUTHCLASS
READONLYRead-Only Flag for Views (old) MCROFLAGCHAR1AS4FLAG
ROOTTABPrimary table of an aggregate ROOTTABCHAR30AS4TAB
AS4USERLast Changed by AS4USERCHAR12AS4USER
AS4DATEDate of Last Change AS4DATEDATS8AS4DATE
AS4TIMELast changed at AS4TIMETIMS6AS4TIME
DDTEXTExplanatory short text DDTEXTCHAR60DDTEXT
VIEWCLASSView Type VIEWCLASSCHAR1VIEWCLASS
ACTFLAGActivation flag ACTFLAGCHAR1ACTFLAG
MASTERLANGOriginal Language in Repository objects MASTERLANGLANG1T002ISOLASPRASH_T002
CUSTOMAUTHDelivery class CONTFLAGCHAR1CONTFLAG
VIEWGRANTMaintenance status (modif. authorization) for view data VIEWGRANTCHAR1VIEWGRANT
GLOBALFLAGFlag if Maintenance with Standard Tools is allowed MAINTFLAGCHAR1MAINTFLAG
MANKEYPermit manual maintenance of key attribute DDVIMANKEYCHAR1AS4FLAG
DBREFNAMEDD: Name of View on Database DBVIEWNAMECHAR250DBVIEWNAME

Key field Non-key field



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

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

SELECT SINGLE *
FROM DD25V
INTO CORRESPONDING FIELDS OF WA_DD25V
WHERE...

How to access SAP table DD25V

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

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