DD25L

Transparent Table System Table (SAP only)
37 Fields 3 CDS Views

Aggregate Header (Views, MC Objects, Lock Objects)

DD25L is an SAP database table in S/4HANA. Aggregate Header (Views, MC Objects, Lock Objects). It contains 37 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
DD_LANG_VRS_OBJ_ACTIVE_ENQU view_entity from ABAP Language Version for Lock Objects
DD_LANG_VRS_OBJ_EDIT_ENQU view_entity from ABAP Language Version for Lock Objects
dhadm_cds_all_ddic_obj view_entity union_all All Tables, Views and Data Definitions

Fields (37)

KeyField Data ElementDescription DomainTypeLength
KEY viewname VIEWNAME View Name
KEY as4local AS4LOCAL Activation State
KEY as4vers AS4VERS Version
aggtype AGGTYPE Aggregate Type
applclass APPLCLASS Application Class
authclass AUTHCLASS_ Activation type
readonly MCROFLAG Read-only
roottab ROOTTAB Primary table
as4user AS4USER Last Changed By
as4date AS4DATE Date
as4time AS4TIME Time
viewclass VIEWCLASS View Type
actflag ACTFLAG Activation flag
masterlang MASTERLANG Original Lang.
customauth CONTFLAG Delivery class
viewgrant VIEWGRANT Maint. status
globalflag MAINTFLAG Table Maintenance
mankey DDVIMANKEY Key manual
dbrefname DBVIEWNAME DD: Name of View on Database
alldataincl DDALLDATAINCLU DD: DataAging: Handle data as hot and cold if switched on
with_parameters DDWITHPAR DD: Set whenever a view or base view has parameters
exview_included DDEXTVIEW_INCLUDED DD: Contains at least one external view in the hierarchy
expr_is_used DDEXPR_IS_USED DD: In the view, at least one expr. used (current append)
keymax_feature DDDBKEYMAXFEATURE DD: Maximum CL_DD_DBFEATURES=>KEYCNT_MAX1 Schlüsselfelder
keylen_feature DDDBKEYLENFEATURE DD: Maximum CL_DD_DBFEATURES=>KEYLEN_MAX1 Key Length
tablen_feature DDDBTABLENFEATURE DD: Maximum Width CL_DD_DBFEATURES=>LEN_MAX1
nontrp_included DDNONTRANSP_INCLUDED Obsolete
viewref VIEWNAME View Name
viewref_err DDVIEWREF_ERR Replacement object cannot be used
viewref_pos_chg DDVIEWREF_POSCHG Replacement object exists in different positions
tbfunc_included DDTBFUNC_INCLUDED Contains info whether a table function exists in hierarchy
session_var_ex DDSESSIONVAR_EX DD: Does a session variable exist?
comprflag COMPREX Compression
used_session_vars DDUSEDSESSION_VARS DD: Session Variables Used
abap_language_version ABAP_LANGUAGE_VERSION Language Version
shlpexi SHLPEXI Search help binding to table exists
hdb_only_entity_included DDHDBONLY_ENTITY_INCLUDED HDB entity

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Aggregate Header (Views, MC Objects, Lock Objects)
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DD25L (
    VIEWNAME,                  -- View Name [VIEWNAME]
    AS4LOCAL,                  -- Activation State [AS4LOCAL]
    AS4VERS,                   -- Version [AS4VERS]
    AGGTYPE,                   -- Aggregate Type [AGGTYPE]
    APPLCLASS,                 -- Application Class [APPLCLASS]
    AUTHCLASS,                 -- Activation type [AUTHCLASS_]
    READONLY,                  -- Read-only [MCROFLAG]
    ROOTTAB,                   -- Primary table [ROOTTAB]
    AS4USER,                   -- Last Changed By [AS4USER]
    AS4DATE,                   -- Date [AS4DATE]
    AS4TIME,                   -- Time [AS4TIME]
    VIEWCLASS,                 -- View Type [VIEWCLASS]
    ACTFLAG,                   -- Activation flag [ACTFLAG]
    MASTERLANG,                -- Original Lang. [MASTERLANG]
    CUSTOMAUTH,                -- Delivery class [CONTFLAG]
    VIEWGRANT,                 -- Maint. status [VIEWGRANT]
    GLOBALFLAG,                -- Table Maintenance [MAINTFLAG]
    MANKEY,                    -- Key manual [DDVIMANKEY]
    DBREFNAME,                 -- DD: Name of View on Database [DBVIEWNAME]
    ALLDATAINCL,               -- DD: DataAging: Handle data as hot and cold if switched on [DDALLDATAINCLU]
    WITH_PARAMETERS,           -- DD: Set whenever a view or base view has parameters [DDWITHPAR]
    EXVIEW_INCLUDED,           -- DD: Contains at least one external view in the hierarchy [DDEXTVIEW_INCLUDED]
    EXPR_IS_USED,              -- DD: In the view, at least one expr. used (current append) [DDEXPR_IS_USED]
    KEYMAX_FEATURE,            -- DD: Maximum CL_DD_DBFEATURES=>KEYCNT_MAX1 Schlüsselfelder [DDDBKEYMAXFEATURE]
    KEYLEN_FEATURE,            -- DD: Maximum CL_DD_DBFEATURES=>KEYLEN_MAX1 Key Length [DDDBKEYLENFEATURE]
    TABLEN_FEATURE,            -- DD: Maximum Width CL_DD_DBFEATURES=>LEN_MAX1 [DDDBTABLENFEATURE]
    NONTRP_INCLUDED,           -- Obsolete [DDNONTRANSP_INCLUDED]
    VIEWREF,                   -- View Name [VIEWNAME]
    VIEWREF_ERR,               -- Replacement object cannot be used [DDVIEWREF_ERR]
    VIEWREF_POS_CHG,           -- Replacement object exists in different positions [DDVIEWREF_POSCHG]
    TBFUNC_INCLUDED,           -- Contains info whether a table function exists in hierarchy [DDTBFUNC_INCLUDED]
    SESSION_VAR_EX,            -- DD: Does a session variable exist? [DDSESSIONVAR_EX]
    COMPRFLAG,                 -- Compression [COMPREX]
    USED_SESSION_VARS,         -- DD: Session Variables Used [DDUSEDSESSION_VARS]
    ABAP_LANGUAGE_VERSION,     -- Language Version [ABAP_LANGUAGE_VERSION]
    SHLPEXI,                   -- Search help binding to table exists [SHLPEXI]
    HDB_ONLY_ENTITY_INCLUDED,  -- HDB entity [DDHDBONLY_ENTITY_INCLUDED]
    PRIMARY KEY (VIEWNAME, AS4LOCAL, AS4VERS)
);

Learn More