MMPUR_RULE_DEF

Transparent Table Customizing Table
12 Fields 1 CDS Views

definition of a rule

MMPUR_RULE_DEF is an SAP database table in S/4HANA. definition of a rule. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProcmtAutomnRuleDefinition view from BASIC Base view for Rule header Table

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY procmtautomnruleid mmpur_rule_id Rule ID
procmntautomnrulename mmpur_rule_name Rule Name
sapobjecttype sbo_bo_type SAP Object Type
procmthubcreatedbyuser ernam Created By
prmthblastchangedbyuser mmpur_changed_by Changed By
procmthubcreationdate mmpur_created_on Created On
lastchangedatetime timestampl Time Stamp
procmtautomnisruleactive mmpur_rule_active Active
validitystartdate datum Date
validityenddate datum Date
isdeleted boolean_flg Boolean Variables (X=true, space=false)

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.

-- definition of a rule
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_RULE_DEF (
    CLIENT,                    -- Client [mandt]
    PROCMTAUTOMNRULEID,        -- Rule ID [mmpur_rule_id]
    PROCMNTAUTOMNRULENAME,     -- Rule Name [mmpur_rule_name]
    SAPOBJECTTYPE,             -- SAP Object Type [sbo_bo_type]
    PROCMTHUBCREATEDBYUSER,    -- Created By [ernam]
    PRMTHBLASTCHANGEDBYUSER,   -- Changed By [mmpur_changed_by]
    PROCMTHUBCREATIONDATE,     -- Created On [mmpur_created_on]
    LASTCHANGEDATETIME,        -- Time Stamp [timestampl]
    PROCMTAUTOMNISRULEACTIVE,  -- Active [mmpur_rule_active]
    VALIDITYSTARTDATE,         -- Date [datum]
    VALIDITYENDDATE,           -- Date [datum]
    ISDELETED,                 -- Boolean Variables (X=true, space=false) [boolean_flg]
    PRIMARY KEY (CLIENT, PROCMTAUTOMNRULEID)
);

Learn More