FINCS_EXT_MDCHAR

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

Meta data information for extension characteristics

FINCS_EXT_MDCHAR is an SAP database table in S/4HANA. Meta data information for extension characteristics. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CnsldtnExtnCharacteristic view_entity from BASIC Cnsldtn Extensibility Characteristic

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY cnsldtnmdcharcfldname CHARACTERISTIC_NAME Char. Name
KEY mdcharcinternalname CHARACTERISTIC_INTERNAL_NAME Char. Internal Name
cnsldtmdsuprordfld CONS_MD_REF_FIELD Superord. Field
cnsldtnaddlcharcisinuse FINCS_FIELD_USAGE Enable Inputs
cnsldtnaddlmdisinuse FINCS_MD_USAGE Enable Master Data
cnsldtnaddlmdpairedfld CONS_MD_PAIR_FIELD Reference Field
cnsldtnaddlmdhierisinuse FINCS_MD_USE_HIERARCHY Enable Hierarchy
cnsldtcharcdataelmnt FINCS_ADDL_CHARC_DATA_ELMNT Data Element
cnsldtnaddlmdpairedfldname CHARACTERISTIC_NAME Char. Name
cnsldtnaddlmdsuprordfldname CHARACTERISTIC_NAME Char. Name
cnsldtnaddlmdpaireddataelmnt FINCS_ADDL_CHARC_DATA_ELMNT Data Element
cnsldtnaddlmdsuprorddataelmnt FINCS_ADDL_CHARC_DATA_ELMNT Data Element

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.

-- Meta data information for extension characteristics
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINCS_EXT_MDCHAR (
    MANDT,                          -- Client [MANDT]
    CNSLDTNMDCHARCFLDNAME,          -- Char. Name [CHARACTERISTIC_NAME]
    MDCHARCINTERNALNAME,            -- Char. Internal Name [CHARACTERISTIC_INTERNAL_NAME]
    CNSLDTMDSUPRORDFLD,             -- Superord. Field [CONS_MD_REF_FIELD]
    CNSLDTNADDLCHARCISINUSE,        -- Enable Inputs [FINCS_FIELD_USAGE]
    CNSLDTNADDLMDISINUSE,           -- Enable Master Data [FINCS_MD_USAGE]
    CNSLDTNADDLMDPAIREDFLD,         -- Reference Field [CONS_MD_PAIR_FIELD]
    CNSLDTNADDLMDHIERISINUSE,       -- Enable Hierarchy [FINCS_MD_USE_HIERARCHY]
    CNSLDTCHARCDATAELMNT,           -- Data Element [FINCS_ADDL_CHARC_DATA_ELMNT]
    CNSLDTNADDLMDPAIREDFLDNAME,     -- Char. Name [CHARACTERISTIC_NAME]
    CNSLDTNADDLMDSUPRORDFLDNAME,    -- Char. Name [CHARACTERISTIC_NAME]
    CNSLDTNADDLMDPAIREDDATAELMNT,   -- Data Element [FINCS_ADDL_CHARC_DATA_ELMNT]
    CNSLDTNADDLMDSUPRORDDATAELMNT,  -- Data Element [FINCS_ADDL_CHARC_DATA_ELMNT]
    PRIMARY KEY (MANDT, CNSLDTNMDCHARCFLDNAME, MDCHARCINTERNALNAME)
);

Learn More