MMPUR_ANA_SESCR

Transparent Table Application Table
16 Fields 1 CDS Views

Supplier Eval Peersist Operational Score

MMPUR_ANA_SESCR is an SAP database table in S/4HANA. Supplier Eval Peersist Operational Score. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SupplierEvalScoreHistory view from BASIC Operational Score History

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY job_run_id MMPUR_ANA_JOB_RUN_ID Job ID
KEY calendarmonth CALENDARMONTH Calendar Month
KEY calendaryear CALENDARYEAR Calendar Year
KEY supplier ELIFN Supplier
KEY materialgroup MATKL Material Group
supplieroperationalscore MM_PUR_ANA_SUPLREVAL_OPL_SCORE Operational Score
timevariancescore MM_A_TIME_VARIANCE_SCORE Time Variance Score
pricevariancescore MM_A_PRICE_VARIANCE_SCORE Price Variance Score
quantityvariancescore MM_A_QUANTITY_VAR_SCORE Quantity Var. Score
inspectionlotqualityscore MM_A_QUALITY_VARIANCE_SCORE Inspection Lot Score
qualitynotificationscore MM_A_QUALITY_NOTIF_SCORE Quality Notif. Score
createdby ERNAM Created By
createddate ERDAT Created On
dummy_sescr_incl_eew_ps SESCR_INCL_EEW Ext. for Supplier Eval. Score History
supplieraccountgroup KTOKK Account group

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.

-- Supplier Eval Peersist Operational Score
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_ANA_SESCR (
    CLIENT,                     -- Client [MANDT]
    JOB_RUN_ID,                 -- Job ID [MMPUR_ANA_JOB_RUN_ID]
    CALENDARMONTH,              -- Calendar Month [CALENDARMONTH]
    CALENDARYEAR,               -- Calendar Year [CALENDARYEAR]
    SUPPLIER,                   -- Supplier [ELIFN]
    MATERIALGROUP,              -- Material Group [MATKL]
    SUPPLIEROPERATIONALSCORE,   -- Operational Score [MM_PUR_ANA_SUPLREVAL_OPL_SCORE]
    TIMEVARIANCESCORE,          -- Time Variance Score [MM_A_TIME_VARIANCE_SCORE]
    PRICEVARIANCESCORE,         -- Price Variance Score [MM_A_PRICE_VARIANCE_SCORE]
    QUANTITYVARIANCESCORE,      -- Quantity Var. Score [MM_A_QUANTITY_VAR_SCORE]
    INSPECTIONLOTQUALITYSCORE,  -- Inspection Lot Score [MM_A_QUALITY_VARIANCE_SCORE]
    QUALITYNOTIFICATIONSCORE,   -- Quality Notif. Score [MM_A_QUALITY_NOTIF_SCORE]
    CREATEDBY,                  -- Created By [ERNAM]
    CREATEDDATE,                -- Created On [ERDAT]
    DUMMY_SESCR_INCL_EEW_PS,    -- Ext. for Supplier Eval. Score History [SESCR_INCL_EEW]
    SUPPLIERACCOUNTGROUP,       -- Account group [KTOKK]
    PRIMARY KEY (CLIENT, JOB_RUN_ID, CALENDARMONTH, CALENDARYEAR, SUPPLIER, MATERIALGROUP)
);

Learn More