DD04L
Data elements
DD04L is an SAP database table in S/4HANA. Data elements. It contains 39 fields. 24 CDS views read from this table.
CDS Views using this table (24)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| AUTHX_FIELDINFO__DD04LDD01L | view_entity | union | Test | |
| AUTHX_FIELDINFO__DD04LDD01L | view_entity | from | Test | |
| DD_DATA_ELEMENT_INFO | view_entity | from | Data Element Information | |
| DD_LANG_VRS_OBJ_ACTIVE_DTEL | view_entity | from | ABAP Language Version for DTEL Objects | |
| DD_LANG_VRS_OBJ_EDIT_DTEL | view_entity | from | ABAP Language Version for Data Elements | |
| DDCDS_SCALAR_TYPES | view_entity | union_all | ABAP Dictionary: API view scalar types | |
| E_TBFD_SHLP | view | inner | DD: SHLP for given TABNAME/FIELDNAME | |
| e_tbfd_shlp_u | view | inner | DD: SHLP for given TABNAME/FIELDNAME | |
| fiscds_trk_fld_text | view | inner | Changed Field Name of Dcoument | |
| gseg_cds_cds_fld_md | view_entity | left_outer | CDS Fields with Metadata (Type, DTEL...) | |
| I_BusEvtLogEntityElement | view_entity | inner | BASIC | Business Event Log Entity Element |
| I_CmmdtyPrcgDtaElmntInfo | view_entity | from | BASIC | Pricing Date Element Information |
| I_CnsldtnSubassignment | view | from | BASIC | Consolidation Subassignment |
| I_SCBO_ASSOCIATION_CBO1 | view_entity | left_outer | Custom Business Objects: Associable CBO1 | |
| I_SCBO_ASSOCIATION_CBO2 | view_entity | left_outer | Custom Business Objects: Associable CBO2 | |
| I_USFedDataElementInfo | view_entity | from | BASIC | Data Element Information |
| P_ATPSelOptnToolDataElement | view | from | BASIC | |
| P_CFD_DE_C1_REL_DATA_ELEMENT | view_entity | inner | C1 released data elements | |
| P_JOURNALENTRYFIELDTEXT | view | inner | BASIC | |
| P_MDQltyModelTblFldSrchHelps | view | inner | BASIC | |
| sais_gaf_dtel_info | view_entity | from | Info about Data Element for GAF Purpose | |
| sbd_shlp_info | view | left_outer | Search Help Info | |
| sdsh_cds_field_type_ahead | view_entity | inner | Dictionary Search Helps: Table fields with type-ahead | |
| SUIM_AUTH_LIST_DD | view | left_outer | SUIM | Helper View to for SUIM_AUTH_LIST |
Fields (39)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | rollname | ROLLNAME | Data Element | |||
| KEY | as4local | AS4LOCAL | Activation State | |||
| KEY | as4vers | AS4VERS | Version | |||
| domname | DOMNAME | Domain | ||||
| routputlen | DDLENG | No. of Characters | ||||
| memoryid | MEMORYID | Parameter ID | ||||
| logflag | LOGFLAG | Change document | ||||
| headlen | HEADLEN | Header | ||||
| scrlen1 | SCRLEN_S | ShortFieldLabelLen | ||||
| scrlen2 | SCRLEN_M | Med.FieldLabelLen. | ||||
| scrlen3 | SCRLEN_L | LongFieldLabelLen. | ||||
| actflag | DTACTFLAG | Activation flag | ||||
| applclass | APPLCLASS | Application Class | ||||
| authclass | AUTHCLASS_ | Activation type | ||||
| as4user | AS4USER | Last Changed By | ||||
| as4date | AS4DATE | Date | ||||
| as4time | AS4TIME | Time | ||||
| dtelmaster | MASTERLANG | Original Lang. | ||||
| reservedte | RESERVEDTE | ReserveFlag | ||||
| dtelglobal | GLOBALFLAG | Not global | ||||
| shlpname | SHLPNAME | Search Help Name | ||||
| shlpfield | SHLPFIELD | SearchHelpParam | ||||
| deffdname | DEFFDNAME | Component name | ||||
| datatype | DATATYPE_D | Data Type | ||||
| leng | DDLENG | No. of Characters | ||||
| decimals | DECIMALS | Decimal Places | ||||
| outputlen | OUTPUTLEN | Output Length | ||||
| lowercase | LOWERCASE | Case-Sensitive | ||||
| signflag | SIGNFLAG | Sign | ||||
| convexit | CONVEXIT | Convers. Rout. | ||||
| valexi | VALEXI | Fixed val. ex. | ||||
| entitytab | ENTITYTAB | Value table | ||||
| refkind | TYPEKIND | Category (Coded) | ||||
| reftype | DDREFTYPE | Ref.Type (Coded) | ||||
| proxytype | DDPROXYTY | PrxyUsage | ||||
| ltrflddis | DDLTRFLDDI | LTR basic direction | ||||
| bidictrlc | DDBIDICTRL | No BIDI Filtering | ||||
| nohistory | DDNOHISTORY | No History | ||||
| abap_language_version | ABAP_LANGUAGE_VERSION | Language Version |
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.
-- Data elements
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DD04L (
ROLLNAME, -- Data Element [ROLLNAME]
AS4LOCAL, -- Activation State [AS4LOCAL]
AS4VERS, -- Version [AS4VERS]
DOMNAME, -- Domain [DOMNAME]
ROUTPUTLEN, -- No. of Characters [DDLENG]
MEMORYID, -- Parameter ID [MEMORYID]
LOGFLAG, -- Change document [LOGFLAG]
HEADLEN, -- Header [HEADLEN]
SCRLEN1, -- ShortFieldLabelLen [SCRLEN_S]
SCRLEN2, -- Med.FieldLabelLen. [SCRLEN_M]
SCRLEN3, -- LongFieldLabelLen. [SCRLEN_L]
ACTFLAG, -- Activation flag [DTACTFLAG]
APPLCLASS, -- Application Class [APPLCLASS]
AUTHCLASS, -- Activation type [AUTHCLASS_]
AS4USER, -- Last Changed By [AS4USER]
AS4DATE, -- Date [AS4DATE]
AS4TIME, -- Time [AS4TIME]
DTELMASTER, -- Original Lang. [MASTERLANG]
RESERVEDTE, -- ReserveFlag [RESERVEDTE]
DTELGLOBAL, -- Not global [GLOBALFLAG]
SHLPNAME, -- Search Help Name [SHLPNAME]
SHLPFIELD, -- SearchHelpParam [SHLPFIELD]
DEFFDNAME, -- Component name [DEFFDNAME]
DATATYPE, -- Data Type [DATATYPE_D]
LENG, -- No. of Characters [DDLENG]
DECIMALS, -- Decimal Places [DECIMALS]
OUTPUTLEN, -- Output Length [OUTPUTLEN]
LOWERCASE, -- Case-Sensitive [LOWERCASE]
SIGNFLAG, -- Sign [SIGNFLAG]
CONVEXIT, -- Convers. Rout. [CONVEXIT]
VALEXI, -- Fixed val. ex. [VALEXI]
ENTITYTAB, -- Value table [ENTITYTAB]
REFKIND, -- Category (Coded) [TYPEKIND]
REFTYPE, -- Ref.Type (Coded) [DDREFTYPE]
PROXYTYPE, -- PrxyUsage [DDPROXYTY]
LTRFLDDIS, -- LTR basic direction [DDLTRFLDDI]
BIDICTRLC, -- No BIDI Filtering [DDBIDICTRL]
NOHISTORY, -- No History [DDNOHISTORY]
ABAP_LANGUAGE_VERSION, -- Language Version [ABAP_LANGUAGE_VERSION]
PRIMARY KEY (ROLLNAME, 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