MMPUR_RUL_CRTRIA

Transparent Table Customizing Table

criteria for the hub rule

MMPUR_RUL_CRTRIA is an SAP database table in S/4HANA. criteria for the hub rule. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProcmtAutomnRuleCriteria view from BASIC Base view for Rule critera

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY procmtautomnruleid mmpur_rule_id Rule ID
KEY extsourcesystem mmpur_d_source_sys Connected System ID
KEY sapobjectnodetype sbo_node_type SAP Obj Node Type
KEY businessobjectfieldname mmpur_field_name Field Name
KEY itemcounter mmpur_field_sequence Sequence
operator mmpur_operator Operator
businessobjectkeyfieldvalue1 mmpur_value_high Value High
businessobjectkeyfieldvalue2 mmpur_value_low Value Low
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.

-- criteria for the hub rule
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_RUL_CRTRIA (
    CLIENT,                        -- Client [mandt]
    PROCMTAUTOMNRULEID,            -- Rule ID [mmpur_rule_id]
    EXTSOURCESYSTEM,               -- Connected System ID [mmpur_d_source_sys]
    SAPOBJECTNODETYPE,             -- SAP Obj Node Type [sbo_node_type]
    BUSINESSOBJECTFIELDNAME,       -- Field Name [mmpur_field_name]
    ITEMCOUNTER,                   -- Sequence [mmpur_field_sequence]
    OPERATOR,                      -- Operator [mmpur_operator]
    BUSINESSOBJECTKEYFIELDVALUE1,  -- Value High [mmpur_value_high]
    BUSINESSOBJECTKEYFIELDVALUE2,  -- Value Low [mmpur_value_low]
    ISDELETED,                     -- Boolean Variables (X=true, space=false) [boolean_flg]
    PRIMARY KEY (CLIENT, PROCMTAUTOMNRULEID, EXTSOURCESYSTEM, SAPOBJECTNODETYPE, BUSINESSOBJECTFIELDNAME, ITEMCOUNTER)
);