MMPUR_ANA_CRTSCR

Transparent Table Application Table
20 Fields 1 CDS Views

Capability to assign scores for the Criteria

MMPUR_ANA_CRTSCR is an SAP database table in S/4HANA. Capability to assign scores for the Criteria. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SuplrEvalUserDfndCriteriaCt view from BASIC User Defined Criteria Count

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY suplrevalusrdfndcritrauuid MMPUR_ANA_USRCRT_UUID Unique Idenitifier
supplier LIFNR Supplier
materialgroup MATKL Material Group
purchasingcategory MMPUR_ANA_PUR_DE_CATEGORY_ID Purchasing Cat. ID
suplrevaluserdefinedcriteria MMPUR_ANA_CRITERIA_ID Criteria Identifier
validfrom MM_PUR_ANA_DE_VALID_FRM Valid From
validto MM_PUR_ANA_DE_VALID_TO Valid To
plottingdate MM_PUR_ANA_REPORTED_DATE Reported Date
totnmbrofsuplrusrdfndcritra MM_A_SUPPLIER_OPL_SCORE_CNT Supplier Count
isdeleted MMPUR_ANA_USRCRT_DELETE_FLG Deletable
iseopblocked MMPUR_ANA_EOPBLOCKED Business Usage Comp.
comments MMPUR_ANA_COMMENTS Comments
suplrevalusrdfndcritracrtedby MMPUR_ANA_CREATEDBY Created By
suplrevaluserdfndcritracrtndte MMPUR_ANA_CREATEDON Created On
suplrevalusrdfndcritrachgdby MMPUR_ANA_LASTCHANGEBY Last Updated By
suplrevaluserdfndcritrachgdate MMPUR_ANA_LASTCHANGEON Last Updated On
supplieraccountgroup KTOKK Account group
suplrevaluserdfndcritraexecdat MM_PUR_ANA_DE_UDC_EXEC_DATE Execution Date
suplrevalusrdfndcritraentchgd MM_PUR_ANA_DE_LASTCHG_TMSTP Lst Change Timestamp

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.

-- Capability to assign scores for the Criteria
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_ANA_CRTSCR (
    CLIENT,                          -- Client [MANDT]
    SUPLREVALUSRDFNDCRITRAUUID,      -- Unique Idenitifier [MMPUR_ANA_USRCRT_UUID]
    SUPPLIER,                        -- Supplier [LIFNR]
    MATERIALGROUP,                   -- Material Group [MATKL]
    PURCHASINGCATEGORY,              -- Purchasing Cat. ID [MMPUR_ANA_PUR_DE_CATEGORY_ID]
    SUPLREVALUSERDEFINEDCRITERIA,    -- Criteria Identifier [MMPUR_ANA_CRITERIA_ID]
    VALIDFROM,                       -- Valid From [MM_PUR_ANA_DE_VALID_FRM]
    VALIDTO,                         -- Valid To [MM_PUR_ANA_DE_VALID_TO]
    PLOTTINGDATE,                    -- Reported Date [MM_PUR_ANA_REPORTED_DATE]
    TOTNMBROFSUPLRUSRDFNDCRITRA,     -- Supplier Count [MM_A_SUPPLIER_OPL_SCORE_CNT]
    ISDELETED,                       -- Deletable [MMPUR_ANA_USRCRT_DELETE_FLG]
    ISEOPBLOCKED,                    -- Business Usage Comp. [MMPUR_ANA_EOPBLOCKED]
    COMMENTS,                        -- Comments [MMPUR_ANA_COMMENTS]
    SUPLREVALUSRDFNDCRITRACRTEDBY,   -- Created By [MMPUR_ANA_CREATEDBY]
    SUPLREVALUSERDFNDCRITRACRTNDTE,  -- Created On [MMPUR_ANA_CREATEDON]
    SUPLREVALUSRDFNDCRITRACHGDBY,    -- Last Updated By [MMPUR_ANA_LASTCHANGEBY]
    SUPLREVALUSERDFNDCRITRACHGDATE,  -- Last Updated On [MMPUR_ANA_LASTCHANGEON]
    SUPPLIERACCOUNTGROUP,            -- Account group [KTOKK]
    SUPLREVALUSERDFNDCRITRAEXECDAT,  -- Execution Date [MM_PUR_ANA_DE_UDC_EXEC_DATE]
    SUPLREVALUSRDFNDCRITRAENTCHGD,   -- Lst Change Timestamp [MM_PUR_ANA_DE_LASTCHG_TMSTP]
    PRIMARY KEY (CLIENT, SUPLREVALUSRDFNDCRITRAUUID)
);

Learn More