DMC_FIELD

Transparent Table System Table (SAP only)
37 Fields 1 CDS Views

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)
);

Learn More