DMC_FIELD

Transparent Table System Table (SAP only)

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)

ViewTypeJoinVDMDescription
I_DataMigrtnProjObjField view from BASIC Data Migration Data Field of a Structure

Fields (37)

KeyField Data ElementDescription DomainTypeLength
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)
);