MMPRC_CCTR_RELOR
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 28 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CntrlPurContrReleaseHistory | view | from | BASIC | Basic View for Release History in Central Purchase Contract |
Fields (28)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 |
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]
PRIMARY KEY (MANDT, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM, DISTRIBUTIONNUMBER, RELEASEORDER, RELEASEORDERITEM)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA