MMPRC_CCTR_RELOR

Transparent Table Application Table
30 Fields 1 CDS Views

Calloff data for Central contracts in Hub

MMPRC_CCTR_RELOR is an SAP database table in S/4HANA. Calloff data for Central contracts in Hub. It contains 30 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CntrlPurContrReleaseHistory view from BASIC Basic View for Release History in Central Purchase Contract

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY purchasingdocument ebeln Purchasing Doc.
KEY purchasingdocumentitem ebelp Item
KEY distributionnumber mm_purgdoc_distr_num Distr. Number
KEY releaseorder ebeln Purchasing Doc.
KEY releaseorderitem ebelp Item
extcontractforpurg konnr Agreement
extcontractitemforpurg ktpnr Agreement Item
releaseorderdate bedat PO Date
releaseorderitemorderquantity bstmg PO Quantity
releaseorderitemquantityunit bstme Order Unit
releaseorderitemnetamount bwert Net Value
releaseordercurrency waers Currency
releaseorderexchangerate wkurs Exchange Rate
releaseorderitemisdeleted eloek Del. Indicator
releaseorderlogicalsystem logsystem Logical System
releaseordercompanycode bukrs Company Code
releaseorderitemplant ewerk Plant
releaseorderpurgorganization ekorg Purchasing Org.
releaseorderitemlastchgdate aedat Changed On
memorytype memorytype Incompl. Cat.
companycode bukrs Company Code
plant ewerk Plant
releaseorderdocumentcategory ebstyp Doc. Category
releaseordergrconsumptionqty menge_bpr Qty. in OPUn
releaseordergramount wrbtr Amount
releaseorderlastgrdate lvgdt Last transact.
jobname mmpur_bckgrnd_job Job Name
releaseorderirconsumptionqty mmpur_ir_quantity
releaseorderiramount mmpur_ir_amount

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.

-- Calloff data for Central contracts in Hub
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPRC_CCTR_RELOR (
    MANDT,                          -- Client [mandt]
    PURCHASINGDOCUMENT,             -- Purchasing Doc. [ebeln]
    PURCHASINGDOCUMENTITEM,         -- Item [ebelp]
    DISTRIBUTIONNUMBER,             -- Distr. Number [mm_purgdoc_distr_num]
    RELEASEORDER,                   -- Purchasing Doc. [ebeln]
    RELEASEORDERITEM,               -- Item [ebelp]
    EXTCONTRACTFORPURG,             -- Agreement [konnr]
    EXTCONTRACTITEMFORPURG,         -- Agreement Item [ktpnr]
    RELEASEORDERDATE,               -- PO Date [bedat]
    RELEASEORDERITEMORDERQUANTITY,  -- PO Quantity [bstmg]
    RELEASEORDERITEMQUANTITYUNIT,   -- Order Unit [bstme]
    RELEASEORDERITEMNETAMOUNT,      -- Net Value [bwert]
    RELEASEORDERCURRENCY,           -- Currency [waers]
    RELEASEORDEREXCHANGERATE,       -- Exchange Rate [wkurs]
    RELEASEORDERITEMISDELETED,      -- Del. Indicator [eloek]
    RELEASEORDERLOGICALSYSTEM,      -- Logical System [logsystem]
    RELEASEORDERCOMPANYCODE,        -- Company Code [bukrs]
    RELEASEORDERITEMPLANT,          -- Plant [ewerk]
    RELEASEORDERPURGORGANIZATION,   -- Purchasing Org. [ekorg]
    RELEASEORDERITEMLASTCHGDATE,    -- Changed On [aedat]
    MEMORYTYPE,                     -- Incompl. Cat. [memorytype]
    COMPANYCODE,                    -- Company Code [bukrs]
    PLANT,                          -- Plant [ewerk]
    RELEASEORDERDOCUMENTCATEGORY,   -- Doc. Category [ebstyp]
    RELEASEORDERGRCONSUMPTIONQTY,   -- Qty. in OPUn [menge_bpr]
    RELEASEORDERGRAMOUNT,           -- Amount [wrbtr]
    RELEASEORDERLASTGRDATE,         -- Last transact. [lvgdt]
    JOBNAME,                        -- Job Name [mmpur_bckgrnd_job]
    RELEASEORDERIRCONSUMPTIONQTY,   -- mmpur_ir_quantity
    RELEASEORDERIRAMOUNT,           -- mmpur_ir_amount
    PRIMARY KEY (MANDT, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM, DISTRIBUTIONNUMBER, RELEASEORDER, RELEASEORDERITEM)
);

Learn More