DMC_FIXEDVALUE

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

MWB: Fixed Values

DMC_FIXEDVALUE is an SAP database table in S/4HANA. MWB: Fixed Values. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
/LTB/I_MC_ACTIVITY_DETAIL_LIST view left_outer The activity details of MC

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY guid DMC_FV_GUID Fixed Val. GUID
ident DMC_FVIDENT Identifier
ulcase DMC_ULCASE Upper/ lower case
type DMC_FV_TYPE Type Name
len DMC_FIXEDVALUE_LENGTH FixedVal Lngth
visibility DMC_VISIB Classification
def_value DMC_FV_VALUE Value
assigned DMC_ASSIGNED GUID Org. Unit
versio DMC_VERSIO Version Number
chnam SYUNAME User Name
changedate SYDATUM Current Date
author SYUNAME User Name
createdate SYDATUM Current Date
sortcrit DMC_CNVLOGIC_SORTCRIT Sort criterion
check_dom DOMNAME Domain
check_tab TABNAME Table Name
check_field FIELDNAME Field Name
shlpname SHLPNAME Search Help Name
content_date DATS Date
content_time TIMS Field of type TIMS
is_modified DMC_CONTENT_MODIFIED content modif
check_fv DMC_CHECK_FV Check

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.

-- MWB: Fixed Values
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DMC_FIXEDVALUE (
    GUID,          -- Fixed Val. GUID [DMC_FV_GUID]
    IDENT,         -- Identifier [DMC_FVIDENT]
    ULCASE,        -- Upper/ lower case [DMC_ULCASE]
    TYPE,          -- Type Name [DMC_FV_TYPE]
    LEN,           -- FixedVal Lngth [DMC_FIXEDVALUE_LENGTH]
    VISIBILITY,    -- Classification [DMC_VISIB]
    DEF_VALUE,     -- Value [DMC_FV_VALUE]
    ASSIGNED,      -- GUID Org. Unit [DMC_ASSIGNED]
    VERSIO,        -- Version Number [DMC_VERSIO]
    CHNAM,         -- User Name [SYUNAME]
    CHANGEDATE,    -- Current Date [SYDATUM]
    AUTHOR,        -- User Name [SYUNAME]
    CREATEDATE,    -- Current Date [SYDATUM]
    SORTCRIT,      -- Sort criterion [DMC_CNVLOGIC_SORTCRIT]
    CHECK_DOM,     -- Domain [DOMNAME]
    CHECK_TAB,     -- Table Name [TABNAME]
    CHECK_FIELD,   -- Field Name [FIELDNAME]
    SHLPNAME,      -- Search Help Name [SHLPNAME]
    CONTENT_DATE,  -- Date [DATS]
    CONTENT_TIME,  -- Field of type TIMS [TIMS]
    IS_MODIFIED,   -- content modif [DMC_CONTENT_MODIFIED]
    CHECK_FV,      -- Check [DMC_CHECK_FV]
    PRIMARY KEY (GUID)
);

Learn More