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