DD25L
Aggregat-Header (Views, Matchcode-Objekte, Sperrobjekte)
DD25L is an SAP database table in S/4HANA. Aggregat-Header (Views, Matchcode-Objekte, Sperrobjekte). It contains 37 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 Key Fields | ||||
| 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.
-- Aggregat-Header (Views, Matchcode-Objekte, Sperrobjekte)
-- 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 Key Fields [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
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA