CONS_MDCHAR_ATTR

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

Attributes for Consolidation Master Data Characteristics

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CnsldtnAllCharsAttribute view from BASIC Consolidation Characteristics Attributes

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY cnsldtnmdcharcfldname characteristic_name Char. Name
KEY cnsldtcharattr characteristic_attr Char. Attribute
KEY mdcharcinternalname characteristic_internal_name Char. Internal Name
cnsldtcharattrinternal characteristic_attr_int_name Attrib Internal Name
cnsldtnmdsuprordfld cons_md_ref_field Superord. Field
cnsldtnmdsuprordfld2 cons_md_ref_field Superord. Field
cnsldtnmdsuprordfld3 cons_md_ref_field Superord. Field
cnsldtnmdsuprordfld4 cons_md_ref_field Superord. Field
cnsldtcharattrmvalue attr_multi_values Multiple Values
cnsldtcharattrdataelem characteristic_attr_data_ele 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.

-- Attributes for Consolidation Master Data Characteristics
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CONS_MDCHAR_ATTR (
    MANDT,                   -- Client [mandt]
    CNSLDTNMDCHARCFLDNAME,   -- Char. Name [characteristic_name]
    CNSLDTCHARATTR,          -- Char. Attribute [characteristic_attr]
    MDCHARCINTERNALNAME,     -- Char. Internal Name [characteristic_internal_name]
    CNSLDTCHARATTRINTERNAL,  -- Attrib Internal Name [characteristic_attr_int_name]
    CNSLDTNMDSUPRORDFLD,     -- Superord. Field [cons_md_ref_field]
    CNSLDTNMDSUPRORDFLD2,    -- Superord. Field [cons_md_ref_field]
    CNSLDTNMDSUPRORDFLD3,    -- Superord. Field [cons_md_ref_field]
    CNSLDTNMDSUPRORDFLD4,    -- Superord. Field [cons_md_ref_field]
    CNSLDTCHARATTRMVALUE,    -- Multiple Values [attr_multi_values]
    CNSLDTCHARATTRDATAELEM,  -- Data Element [characteristic_attr_data_ele]
    PRIMARY KEY (MANDT, CNSLDTNMDCHARCFLDNAME, CNSLDTCHARATTR, MDCHARCINTERNALNAME)
);

Learn More