DD03M
Generated Table for View
DD03M is an SAP database table in S/4HANA. Generated Table for View. It contains 51 fields. 7 CDS views read from this table.
CDS Views using this table (7)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FndEI_C_TableAndTableFieldInfo | view | inner | External info of Tables and TableFields | |
| I_ChgLgDatabaseTblFieldText | view | from | COMPOSITE | Change Log Database Table Field Text |
| I_FrtUnitBldngRuleCritlQtyName | view | from | BASIC | FUBR Critical Quantity Name |
| I_RAChangeDocFieldName | view | from | BASIC | RA Change Doc Field Name |
| UPOV_NWMODELLING_BA | view | left_outer | Network Modelling PPA before after data | |
| upov_pr_proctype_varfieldname | view | left_outer | Variable fieldnames for Process type | |
| ViewReplGetDppFields | view | left_outer | Get All Blacklisted Fields |
Fields (51)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | tabname | TABNAME | Table Name | |||
| KEY | fieldname | FIELDNAME | Field Name | |||
| KEY | fldstat | AS4LOCAL | Activation State | |||
| KEY | rollname | ROLLNAME | Data Element | |||
| KEY | rollstat | AS4LOCAL | Activation State | |||
| KEY | domname | DOMNAME | Domain | |||
| KEY | domstat | AS4LOCAL | Activation State | |||
| KEY | textstat | AS4LOCAL | Activation State | |||
| KEY | ddlanguage | DDLANGUAGE | Lang. | |||
| KEY | position | TABFDPOS | Table position | |||
| KEY | keyflag | KEYFLAG | Key field | |||
| KEY | mandatory | MANDATORY | Required Field | |||
| KEY | checktable | CHECKTABLE | Check table | |||
| KEY | adminfield | ADMINFIELD | Admin. field | |||
| KEY | inttype | INTTYPE | ABAP type | |||
| KEY | intlen | INTLEN | Internal Length | |||
| KEY | reftable | REFTABLE | Reference table | |||
| KEY | precfield | PRECFIELD | Name of include | |||
| KEY | reffield | REFFIELD | Ref. field | |||
| KEY | conrout | CONROUT | Check module | |||
| KEY | routputlen | DDLENG | No. of Characters | |||
| KEY | memoryid | MEMORYID | Parameter ID | |||
| KEY | logflag | LOGFLAG | Change document | |||
| KEY | headlen | HEADLEN | Header | |||
| KEY | scrlen1 | SCRLEN_S | ShortFieldLabelLen | |||
| KEY | scrlen2 | SCRLEN_M | Med.FieldLabelLen. | |||
| KEY | scrlen3 | SCRLEN_L | LongFieldLabelLen. | |||
| KEY | dtelglobal | GLOBALFLAG | Not global | |||
| KEY | dtelmaster | MASTERLANG | Original Lang. | |||
| KEY | reservedte | RESERVEDTE | ReserveFlag | |||
| KEY | datatype | DATATYPE_D | Data Type | |||
| KEY | leng | DDLENG | No. of Characters | |||
| KEY | outputlen | OUTPUTLEN | Output Length | |||
| KEY | decimals | DECIMALS | Decimal Places | |||
| KEY | lowercase | LOWERCASE | Case-Sensitive | |||
| KEY | signflag | SIGNFLAG | Sign | |||
| KEY | langflag | LANGFLAG | Lang.-dep. values | |||
| KEY | valexi | VALEXI | Fixed val. ex. | |||
| KEY | entitytab | ENTITYTAB | Value table | |||
| KEY | convexit | CONVEXIT | Convers. Rout. | |||
| KEY | mask | AS4MASK | Template | |||
| KEY | masklen | MASKLEN | Template length | |||
| KEY | actflag | ACTFLAG | Activation flag | |||
| KEY | dommaster | MASTERLANG | Original Lang. | |||
| KEY | reservedom | RESERVEDOM | ReserveFlag | |||
| KEY | domglobal | GLOBALFLAG | Not global | |||
| KEY | ddtext | AS4TEXT | Short Description | |||
| KEY | reptext | REPTEXT | Heading | |||
| KEY | scrtext_s | SCRTEXT_S | ShortFieldLabel | |||
| KEY | scrtext_m | SCRTEXT_M | Medium Label | |||
| KEY | scrtext_l | SCRTEXT_L | Long Fld Label |
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.
-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DD03M (
TABNAME, -- Table Name [TABNAME]
FIELDNAME, -- Field Name [FIELDNAME]
FLDSTAT, -- Activation State [AS4LOCAL]
ROLLNAME, -- Data Element [ROLLNAME]
ROLLSTAT, -- Activation State [AS4LOCAL]
DOMNAME, -- Domain [DOMNAME]
DOMSTAT, -- Activation State [AS4LOCAL]
TEXTSTAT, -- Activation State [AS4LOCAL]
DDLANGUAGE, -- Lang. [DDLANGUAGE]
POSITION, -- Table position [TABFDPOS]
KEYFLAG, -- Key field [KEYFLAG]
MANDATORY, -- Required Field [MANDATORY]
CHECKTABLE, -- Check table [CHECKTABLE]
ADMINFIELD, -- Admin. field [ADMINFIELD]
INTTYPE, -- ABAP type [INTTYPE]
INTLEN, -- Internal Length [INTLEN]
REFTABLE, -- Reference table [REFTABLE]
PRECFIELD, -- Name of include [PRECFIELD]
REFFIELD, -- Ref. field [REFFIELD]
CONROUT, -- Check module [CONROUT]
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]
DTELGLOBAL, -- Not global [GLOBALFLAG]
DTELMASTER, -- Original Lang. [MASTERLANG]
RESERVEDTE, -- ReserveFlag [RESERVEDTE]
DATATYPE, -- Data Type [DATATYPE_D]
LENG, -- No. of Characters [DDLENG]
OUTPUTLEN, -- Output Length [OUTPUTLEN]
DECIMALS, -- Decimal Places [DECIMALS]
LOWERCASE, -- Case-Sensitive [LOWERCASE]
SIGNFLAG, -- Sign [SIGNFLAG]
LANGFLAG, -- Lang.-dep. values [LANGFLAG]
VALEXI, -- Fixed val. ex. [VALEXI]
ENTITYTAB, -- Value table [ENTITYTAB]
CONVEXIT, -- Convers. Rout. [CONVEXIT]
MASK, -- Template [AS4MASK]
MASKLEN, -- Template length [MASKLEN]
ACTFLAG, -- Activation flag [ACTFLAG]
DOMMASTER, -- Original Lang. [MASTERLANG]
RESERVEDOM, -- ReserveFlag [RESERVEDOM]
DOMGLOBAL, -- Not global [GLOBALFLAG]
DDTEXT, -- Short Description [AS4TEXT]
REPTEXT, -- Heading [REPTEXT]
SCRTEXT_S, -- ShortFieldLabel [SCRTEXT_S]
SCRTEXT_M, -- Medium Label [SCRTEXT_M]
SCRTEXT_L, -- Long Fld Label [SCRTEXT_L]
PRIMARY KEY (TABNAME, FIELDNAME, FLDSTAT, ROLLNAME, ROLLSTAT, DOMNAME, DOMSTAT, TEXTSTAT, DDLANGUAGE, POSITION, KEYFLAG, MANDATORY, CHECKTABLE, ADMINFIELD, INTTYPE, INTLEN, REFTABLE, PRECFIELD, REFFIELD, CONROUT, ROUTPUTLEN, MEMORYID, LOGFLAG, HEADLEN, SCRLEN1, SCRLEN2, SCRLEN3, DTELGLOBAL, DTELMASTER, RESERVEDTE, DATATYPE, LENG, OUTPUTLEN, DECIMALS, LOWERCASE, SIGNFLAG, LANGFLAG, VALEXI, ENTITYTAB, CONVEXIT, MASK, MASKLEN, ACTFLAG, DOMMASTER, RESERVEDOM, DOMGLOBAL, DDTEXT, REPTEXT, SCRTEXT_S, SCRTEXT_M, SCRTEXT_L)
);
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