MDQ_DIMEN

Transparent Table Application Table
11 Fields 2 CDS Views

MDQ_DIMEN

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MDQltyDimension view from BASIC Configuration of MDQ Dimensions
I_MDQltyDimensionConvertedKeys view_entity from BASIC MDQ Dimension Converted Keys

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY mdqltydimensionuuid MDQ_DIMENSION_UUID Dimension
mdqltydimensioncategoryuuid MDQ_DIMENSION_CATEGORY_UUID Dimension Category
mdqltydimension MDQ_DIMENSION Dimension
mdqltyevaltargetthreshold MDQ_EVALTHRESHOLD_TARGET Target
mdqltyevalwarningthreshold MDQ_EVALTHRESHOLD_WARNING Warning
mdqltyevalcriticalthreshold MDQ_EVALTHRESHOLD_CRITICAL Critical
mdqltydimncrteatdatetime MDQ_DIMN_CRTE_AT Created at
mdqltydimncrtedbyuser UNAME User Name
mdqltydimnupdtdatdatetime MDQ_DIMN_UPDT_AT Changed at
mdqltydimnupdtdbyuser 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_DIMEN
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDQ_DIMEN (
    CLIENT,                       -- Client [MANDT]
    MDQLTYDIMENSIONUUID,          -- Dimension [MDQ_DIMENSION_UUID]
    MDQLTYDIMENSIONCATEGORYUUID,  -- Dimension Category [MDQ_DIMENSION_CATEGORY_UUID]
    MDQLTYDIMENSION,              -- Dimension [MDQ_DIMENSION]
    MDQLTYEVALTARGETTHRESHOLD,    -- Target [MDQ_EVALTHRESHOLD_TARGET]
    MDQLTYEVALWARNINGTHRESHOLD,   -- Warning [MDQ_EVALTHRESHOLD_WARNING]
    MDQLTYEVALCRITICALTHRESHOLD,  -- Critical [MDQ_EVALTHRESHOLD_CRITICAL]
    MDQLTYDIMNCRTEATDATETIME,     -- Created at [MDQ_DIMN_CRTE_AT]
    MDQLTYDIMNCRTEDBYUSER,        -- User Name [UNAME]
    MDQLTYDIMNUPDTDATDATETIME,    -- Changed at [MDQ_DIMN_UPDT_AT]
    MDQLTYDIMNUPDTDBYUSER,        -- User Name [UNAME]
    PRIMARY KEY (CLIENT, MDQLTYDIMENSIONUUID)
);

Learn More