DMC_FIELD
DMC: Data Field of a Structure
DMC_FIELD is an SAP database table in S/4HANA. DMC: Data Field of a Structure. It contains 37 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_DataMigrtnProjObjField | view | from | BASIC | Data Migration Data Field of a Structure |
Fields (37)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | guid | GUID_22 | GUID 22 | |||
| dstructure | GUID_22 | GUID 22 | ||||
| forkeyfeld | DMC_FORKEY_GUID | GUID CallingObj. | ||||
| fieldname | FIELDNAME | Field Name | ||||
| ident | DMC_FIDENT | ID | ||||
| keyflag | KEYFLAG | Key field | ||||
| scrtext_l | SCRTEXT_L | Long Fld Label | ||||
| supply_status | DMC_FIELD_SUPPLY | Fld. supply | ||||
| rulecall | GUID_22 | GUID 22 | ||||
| split | DMC_SPLIT | Splitfeld | ||||
| versio | DMC_VERSIO | Version Number | ||||
| chnam | SYUNAME | User Name | ||||
| changedate | SYDATUM | Current Date | ||||
| author | SYUNAME | User Name | ||||
| createdate | SYDATUM | Current Date | ||||
| descr | DMC_DESCR | Description | ||||
| len | DMC_LEN | Field Len. | ||||
| outputlen | OUTPUTLEN | Output Length | ||||
| decs | DECIMALS | Decimal Places | ||||
| pos | TABFDPOS | Table position | ||||
| inttype | INTTYPE | ABAP type | ||||
| datatype | DMC_FLDTYP | Field Type | ||||
| idfield | DMC_IDF | Id. Fld. Cont. | ||||
| idchar | DMC_IDCHR | Identifying Field Value | ||||
| gchange | DMC_GCHG | Group Exch. Field | ||||
| gchgkind | DMC_GCHK | Group Exchange Procedure | ||||
| typ_prop | DMC_ID | Key | ||||
| checktable | KOMP_CHECK | Check table | ||||
| gcchar | DMC_GCCHR | Field Value for Group Exchange | ||||
| selpar | DMC_SELPAR | Selection Parameter | ||||
| aggreg | DMC_AGGREG | Aggregate Field | ||||
| technical | DMC_TECHN | Technical | ||||
| domname | DOMNAME | Domain | ||||
| rollname | ROLLNAME | Data Element | ||||
| seqnr | DMC_SEQNR | Sequence Number | ||||
| not_initial | DMC_FLD_NOT_INITIAL | Value is mandatory | ||||
| update_lock | BOOLEAN | Boolean Variable (X = True, - = False, Space = Unknown) |
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.
-- DMC: Data Field of a Structure
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DMC_FIELD (
GUID, -- GUID 22 [GUID_22]
DSTRUCTURE, -- GUID 22 [GUID_22]
FORKEYFELD, -- GUID CallingObj. [DMC_FORKEY_GUID]
FIELDNAME, -- Field Name [FIELDNAME]
IDENT, -- ID [DMC_FIDENT]
KEYFLAG, -- Key field [KEYFLAG]
SCRTEXT_L, -- Long Fld Label [SCRTEXT_L]
SUPPLY_STATUS, -- Fld. supply [DMC_FIELD_SUPPLY]
RULECALL, -- GUID 22 [GUID_22]
SPLIT, -- Splitfeld [DMC_SPLIT]
VERSIO, -- Version Number [DMC_VERSIO]
CHNAM, -- User Name [SYUNAME]
CHANGEDATE, -- Current Date [SYDATUM]
AUTHOR, -- User Name [SYUNAME]
CREATEDATE, -- Current Date [SYDATUM]
DESCR, -- Description [DMC_DESCR]
LEN, -- Field Len. [DMC_LEN]
OUTPUTLEN, -- Output Length [OUTPUTLEN]
DECS, -- Decimal Places [DECIMALS]
POS, -- Table position [TABFDPOS]
INTTYPE, -- ABAP type [INTTYPE]
DATATYPE, -- Field Type [DMC_FLDTYP]
IDFIELD, -- Id. Fld. Cont. [DMC_IDF]
IDCHAR, -- Identifying Field Value [DMC_IDCHR]
GCHANGE, -- Group Exch. Field [DMC_GCHG]
GCHGKIND, -- Group Exchange Procedure [DMC_GCHK]
TYP_PROP, -- Key [DMC_ID]
CHECKTABLE, -- Check table [KOMP_CHECK]
GCCHAR, -- Field Value for Group Exchange [DMC_GCCHR]
SELPAR, -- Selection Parameter [DMC_SELPAR]
AGGREG, -- Aggregate Field [DMC_AGGREG]
TECHNICAL, -- Technical [DMC_TECHN]
DOMNAME, -- Domain [DOMNAME]
ROLLNAME, -- Data Element [ROLLNAME]
SEQNR, -- Sequence Number [DMC_SEQNR]
NOT_INITIAL, -- Value is mandatory [DMC_FLD_NOT_INITIAL]
UPDATE_LOCK, -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
PRIMARY KEY (GUID)
);
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