MDQ_DIMN_CAT

Transparent Table Application Table
11 Fields 1 CDS Views

MDQ_DIMN_CAT

MDQ_DIMN_CAT is an SAP database table in S/4HANA. MDQ_DIMN_CAT. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MDQltyDimensionCategory view from BASIC Configuration of MDQ Product Category

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY mdqltydimensioncategoryuuid mdq_dimension_category_uuid Dimension Category
mdqltybusinessobjecttypecode mdg_object_type_code_bs Bus. Obj. Type
mdqltydimensioncategory mdq_dimension_category Dimension Category
mdqltyevaltargetthreshold mdq_evalthreshold_target Target
mdqltyevalwarningthreshold mdq_evalthreshold_warning Warning
mdqltyevalcriticalthreshold mdq_evalthreshold_critical Critical
mdqltydimncatcrteatdatetime mdq_dimn_cat_crte_at Created at
mdqltydimncatcrtedbyuser uname User Name
mdqltydimncatupdtdatdatetime mdq_dimn_cat_updt_at Changed at
mdqltydimncatupdtdbyuser uname User Name

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.

-- MDQ_DIMN_CAT
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDQ_DIMN_CAT (
    CLIENT,                        -- Client [mandt]
    MDQLTYDIMENSIONCATEGORYUUID,   -- Dimension Category [mdq_dimension_category_uuid]
    MDQLTYBUSINESSOBJECTTYPECODE,  -- Bus. Obj. Type [mdg_object_type_code_bs]
    MDQLTYDIMENSIONCATEGORY,       -- Dimension Category [mdq_dimension_category]
    MDQLTYEVALTARGETTHRESHOLD,     -- Target [mdq_evalthreshold_target]
    MDQLTYEVALWARNINGTHRESHOLD,    -- Warning [mdq_evalthreshold_warning]
    MDQLTYEVALCRITICALTHRESHOLD,   -- Critical [mdq_evalthreshold_critical]
    MDQLTYDIMNCATCRTEATDATETIME,   -- Created at [mdq_dimn_cat_crte_at]
    MDQLTYDIMNCATCRTEDBYUSER,      -- User Name [uname]
    MDQLTYDIMNCATUPDTDATDATETIME,  -- Changed at [mdq_dimn_cat_updt_at]
    MDQLTYDIMNCATUPDTDBYUSER,      -- User Name [uname]
    PRIMARY KEY (CLIENT, MDQLTYDIMENSIONCATEGORYUUID)
);

Learn More