CONS_MASTER_CHAR

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

Consolidation Characteristics Master Data

CONS_MASTER_CHAR is an SAP database table in S/4HANA. Consolidation Characteristics Master Data. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CnsldtnAllChars view from BASIC All consolidation characteristics

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.

-- Consolidation Characteristics Master Data
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CONS_MASTER_CHAR (
    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