MDQ_DS_SCN

Transparent Table Application Table
18 Fields 1 CDS Views

Derivation Scenario

MDQ_DS_SCN is an SAP database table in S/4HANA. Derivation Scenario. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MDQualityDerivationScenario view_entity from BASIC Master Data Quality Derivation Scenario

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY mdqltydrvtnscenuuid MDQ_DS_SCENARIO_UUID Scenario UUID
mdqltydrvtnscen MDQ_DS_SCENARIO_ID Scenario ID
mdqltybusinessobjecttypecode MDG_OBJECT_TYPE_CODE_BS Bus. Obj. Type
mdqltydrvtnscenname MDQ_DS_SCENARIO_NAME Scenario Name
mdqltydrvtnscenbasetable MDQ_DS_BASE_TABLE Scenario Base Table
mdqltydrvtnscendescription MDQ_DS_SCENARIO_DESCRIPTION Description
mdqltydrvtnscenstatus MDQ_DS_SCENARIO_STATUS Status
mdqltydrvtnscenowner MDQ_DS_SCENARIO_OWNER Scenario Owner
mdqltydrvtnscenexpert MDQ_DS_SCENARIO_EXPERT Impl. Expert
mdqltydrvtnscenscopedesc MDQ_DS_SCENARIO_SCOPE_DESC Scope Description
mdqltydrvtngnrtnstartdatetime MDQ_DS_GENERATION_DATE_TIME Generated On
mdqltydrvtnscenstatusbfrgnrtn MDQ_DS_SCEN_STATUS_BFR_GNRTN Status Before Gnrtn
mdqltydrvtnscencrtndatetime MDQ_DS_CREATION_DATE_TIME Created On
mdqltydrvtnscencreatedbyuser MDQ_DS_CREATED_BY_USER Created By
mdqltydrvtnscenchangedatetime MDQ_DS_CHANGE_DATE_TIME Changed On
mdqltydrvtnscenchangedbyuser MDQ_DS_CHANGED_BY_USER Changed By
mdqltydrvtnscenlastchgdatetime MDQ_DS_LAST_CHANGE_DATE_TIME Last Changed On

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.

-- Derivation Scenario
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDQ_DS_SCN (
    CLIENT,                          -- Client [MANDT]
    MDQLTYDRVTNSCENUUID,             -- Scenario UUID [MDQ_DS_SCENARIO_UUID]
    MDQLTYDRVTNSCEN,                 -- Scenario ID [MDQ_DS_SCENARIO_ID]
    MDQLTYBUSINESSOBJECTTYPECODE,    -- Bus. Obj. Type [MDG_OBJECT_TYPE_CODE_BS]
    MDQLTYDRVTNSCENNAME,             -- Scenario Name [MDQ_DS_SCENARIO_NAME]
    MDQLTYDRVTNSCENBASETABLE,        -- Scenario Base Table [MDQ_DS_BASE_TABLE]
    MDQLTYDRVTNSCENDESCRIPTION,      -- Description [MDQ_DS_SCENARIO_DESCRIPTION]
    MDQLTYDRVTNSCENSTATUS,           -- Status [MDQ_DS_SCENARIO_STATUS]
    MDQLTYDRVTNSCENOWNER,            -- Scenario Owner [MDQ_DS_SCENARIO_OWNER]
    MDQLTYDRVTNSCENEXPERT,           -- Impl. Expert [MDQ_DS_SCENARIO_EXPERT]
    MDQLTYDRVTNSCENSCOPEDESC,        -- Scope Description [MDQ_DS_SCENARIO_SCOPE_DESC]
    MDQLTYDRVTNGNRTNSTARTDATETIME,   -- Generated On [MDQ_DS_GENERATION_DATE_TIME]
    MDQLTYDRVTNSCENSTATUSBFRGNRTN,   -- Status Before Gnrtn [MDQ_DS_SCEN_STATUS_BFR_GNRTN]
    MDQLTYDRVTNSCENCRTNDATETIME,     -- Created On [MDQ_DS_CREATION_DATE_TIME]
    MDQLTYDRVTNSCENCREATEDBYUSER,    -- Created By [MDQ_DS_CREATED_BY_USER]
    MDQLTYDRVTNSCENCHANGEDATETIME,   -- Changed On [MDQ_DS_CHANGE_DATE_TIME]
    MDQLTYDRVTNSCENCHANGEDBYUSER,    -- Changed By [MDQ_DS_CHANGED_BY_USER]
    MDQLTYDRVTNSCENLASTCHGDATETIME,  -- Last Changed On [MDQ_DS_LAST_CHANGE_DATE_TIME]
    PRIMARY KEY (CLIENT, MDQLTYDRVTNSCENUUID)
);

Learn More