MMPUR_ANA_SE_OVS

Transparent Table Application Table
17 Fields 1 CDS Views

Persisted Supplier Eval Overall Score

MMPUR_ANA_SE_OVS is an SAP database table in S/4HANA. Persisted Supplier Eval Overall Score. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SuplrEvalOverallScoreHistory view from BASIC Supplier Evaluation Overall score

Fields (17)

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
overallscore mm_a_supplier_eval_score Operational Score
questionnairescore mm_a_supplier_eval_score Operational Score
createdby ernam Created By
createddate erdat Created On
supplieraccountgroup ktokk Account group
suplrevalusrdfndcriteria1score mmpur_ana_supleval_usrdefscore User-Defined Score
suplrevalusrdfndcriteria2score mmpur_ana_supleval_usrdefscore User-Defined Score
suplrevalusrdfndcriteria3score mmpur_ana_supleval_usrdefscore User-Defined Score
suplrevalusrdfndcriteria4score mmpur_ana_supleval_usrdefscore User-Defined Score
suplrevalusrdfndcriteria5score mmpur_ana_supleval_usrdefscore User-Defined Score
suplrevalusrdfndcriteria6score mmpur_ana_supleval_usrdefscore User-Defined Score
suplrevalusrdfndcritratotscore mmpur_ana_supleval_usrdefscore User-Defined Score

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.

-- Persisted Supplier Eval Overall Score
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_ANA_SE_OVS (
    CLIENT,                          -- Client [mandt]
    JOB_RUN_ID,                      -- Job ID [mmpur_ana_job_run_id]
    CALENDARMONTH,                   -- Calendar Month [calendarmonth]
    CALENDARYEAR,                    -- Calendar Year [calendaryear]
    SUPPLIER,                        -- Supplier [elifn]
    OVERALLSCORE,                    -- Operational Score [mm_a_supplier_eval_score]
    QUESTIONNAIRESCORE,              -- Operational Score [mm_a_supplier_eval_score]
    CREATEDBY,                       -- Created By [ernam]
    CREATEDDATE,                     -- Created On [erdat]
    SUPPLIERACCOUNTGROUP,            -- Account group [ktokk]
    SUPLREVALUSRDFNDCRITERIA1SCORE,  -- User-Defined Score [mmpur_ana_supleval_usrdefscore]
    SUPLREVALUSRDFNDCRITERIA2SCORE,  -- User-Defined Score [mmpur_ana_supleval_usrdefscore]
    SUPLREVALUSRDFNDCRITERIA3SCORE,  -- User-Defined Score [mmpur_ana_supleval_usrdefscore]
    SUPLREVALUSRDFNDCRITERIA4SCORE,  -- User-Defined Score [mmpur_ana_supleval_usrdefscore]
    SUPLREVALUSRDFNDCRITERIA5SCORE,  -- User-Defined Score [mmpur_ana_supleval_usrdefscore]
    SUPLREVALUSRDFNDCRITERIA6SCORE,  -- User-Defined Score [mmpur_ana_supleval_usrdefscore]
    SUPLREVALUSRDFNDCRITRATOTSCORE,  -- User-Defined Score [mmpur_ana_supleval_usrdefscore]
    PRIMARY KEY (CLIENT, JOB_RUN_ID, CALENDARMONTH, CALENDARYEAR, SUPPLIER)
);

Learn More