MDQ_MND_SCPFLDS

Transparent Table Application Table
9 Fields 1 CDS Views

Master Data Quality Mined Rules Scope Fields

MDQ_MND_SCPFLDS is an SAP database table in S/4HANA. Master Data Quality Mined Rules Scope Fields. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MDQltyMinedRuleScpField view from BASIC MDQ Mined Rule Scope Field

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY mdqltyminedrulescpfielduuid MDQ_MINEDRULE_SCOPEFLD_UUID Scope Field UUID
mdqltyminedruleuuid MDQ_MINEDRULE_UUID Mined Rule UUID
mdqltyminedrulescpfieldtable MDQ_MINEDRULE_SCOPEFLD_TABLE Scope Field Table
mdqltyminedrulescpfield MDQ_MINEDRULE_SCOPEFIELD Scope Field
mdqltyminedrulescpfldoperand MDQ_MINEDRULE_SCOPEFLD_OPERAND Operand
mdqltyminedrulescpfldsign MDQ_MINEDRULE_SCOPEFLD_SIGN Sign
mdqltyminedrulescpfldlow MDQ_MINEDRULE_SCOPEFLD_LOW Low Value
mdqltyminedrulescpfldhigh MDQ_MINEDRULE_SCOPEFLD_HIGH High Value

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.

-- Master Data Quality Mined Rules Scope Fields
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDQ_MND_SCPFLDS (
    CLIENT,                        -- Client [MANDT]
    MDQLTYMINEDRULESCPFIELDUUID,   -- Scope Field UUID [MDQ_MINEDRULE_SCOPEFLD_UUID]
    MDQLTYMINEDRULEUUID,           -- Mined Rule UUID [MDQ_MINEDRULE_UUID]
    MDQLTYMINEDRULESCPFIELDTABLE,  -- Scope Field Table [MDQ_MINEDRULE_SCOPEFLD_TABLE]
    MDQLTYMINEDRULESCPFIELD,       -- Scope Field [MDQ_MINEDRULE_SCOPEFIELD]
    MDQLTYMINEDRULESCPFLDOPERAND,  -- Operand [MDQ_MINEDRULE_SCOPEFLD_OPERAND]
    MDQLTYMINEDRULESCPFLDSIGN,     -- Sign [MDQ_MINEDRULE_SCOPEFLD_SIGN]
    MDQLTYMINEDRULESCPFLDLOW,      -- Low Value [MDQ_MINEDRULE_SCOPEFLD_LOW]
    MDQLTYMINEDRULESCPFLDHIGH,     -- High Value [MDQ_MINEDRULE_SCOPEFLD_HIGH]
    PRIMARY KEY (CLIENT, MDQLTYMINEDRULESCPFIELDUUID)
);

Learn More