DD04L
Datenelemente
DD04L is an SAP database table in S/4HANA. Datenelemente. It contains 39 fields. 15 CDS views read from this table.
CDS Views using this table (15)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| DD_DATA_ELEMENT_INFO | view_entity | from | Data Element Information | |
| 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 | |
| I_CmmdtyPrcgDtaElmntInfo | view_entity | from | BASIC | Pricing Date Element Information |
| I_CnsldtnSubassignment | view | from | BASIC | Consolidation Subassignment |
| I_scbo_association | view | left_outer | Custom Business Objects: Associatable | |
| 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.
-- Datenelemente
-- 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