I_ContrAllocVolSecdryProdMP

CA Volume Secondary Product For MP | view: IPVCAVOLSECMP | TRAN | Extraction: Full only | Component: Production and Revenue Accounting

Tables used: OIU_SB_RNAMP

🔑 Keys (11)
💰 Amounts
∑ Quantities (9)
📅 Dates (1)
☰ Categorical (1)
Other (3)
🔗 Relations (9)

Column Name	Description
DeliveryNetwork FK	Delivery network number
MeasurementPoint FK	Measurement point number
Material FK	Material Number
PRAContract FK	Contract Number
SalesDate	Sales date
PRAOwner FK	PRA owner
OwnerInterestType FK	Participant Interest Type
OwnerInterestSequence	Owner Interest Sequence Number
OriginatingMeasurementPt FK	Original measurement point number
Transporter	Transporter number
IsLeaseOrPlant	Lease Plant Code	Show values

Column Name	Description

Column Name	Description
📏 Actual Volume Units (VolumeUnit):
ActualVolume	Actual Volume
EntitledVolume	Entitled Contract Volume
📏 Heating Value Unit (HeatingValUnit):
HeatingValue	Heating value
📏 Actual Energy Unit (EnergyUnit):
ActualEnergy	Actual Energy
EntitledEnergy	Entitled Contract Energy
📏 PVR Unit (VolReducnUnit):
ActualVolReducn	Owner PVR
EntitledVolReducn	Owner PVR
📏 PTR Unit (EnergyReducnUnit):
ActualEnergyReducn	Owner PTR
EntitledEngyReducn	Owner PTR

Column Name	Description
SalesDate	Sales date

Column Name	Description
IsLeaseOrPlant	Lease Plant Code	Show values

Column Name	Description	Domain name
OriginTransaction	Source Transaction ID	FQM_ORIGIN_TRANS_ID
CreatedByUser	Created By	XUBNAME
CreationDateTime	Created On Timestamp	TZNTSTMPS

Master Data Relations	Join Conditions
Delivery network number Delivery network number Client	`I_CONTRALLOCVOLSECDRYPRODMP.DELIVERYNETWORK == OIU_PR_DN.DN_NO` `I_CONTRALLOCVOLSECDRYPRODMP.MANDT == OIU_PR_DN.MANDT`
Actual Energy Unit Actual Energy Unit Client	`I_CONTRALLOCVOLSECDRYPRODMP.ENERGYUNIT == T006.MSEHI` `I_CONTRALLOCVOLSECDRYPRODMP.MANDT == T006.MANDT`
Heating Value Unit Heating Value Unit Client	`I_CONTRALLOCVOLSECDRYPRODMP.HEATINGVALUNIT == T006.MSEHI` `I_CONTRALLOCVOLSECDRYPRODMP.MANDT == T006.MANDT`
Material Number Material Number Client	`I_CONTRALLOCVOLSECDRYPRODMP.MATERIAL == OIU_CM_MAT_PRCD.MATNR` `I_CONTRALLOCVOLSECDRYPRODMP.MANDT == OIU_CM_MAT_PRCD.MANDT`
Measurement point number Measurement point number Client	`I_CONTRALLOCVOLSECDRYPRODMP.MEASUREMENTPOINT == OIU_PR_MP.MP_NO` `I_CONTRALLOCVOLSECDRYPRODMP.MANDT == OIU_PR_MP.MANDT`
Original measurement point number Client Original measurement point number	`I_CONTRALLOCVOLSECDRYPRODMP.MANDT == OIU_PR_MP.MANDT` `I_CONTRALLOCVOLSECDRYPRODMP.ORIGINATINGMEASUREMENTPT == OIU_PR_MP.MP_NO`
Participant Interest Type	`I_CONTRALLOCVOLSECDRYPRODMP.OWNERINTERESTTYPE == OIU_CM_PINTTY.OWN_INT_TYPE_CD`
PRA owner Client PRA owner	`I_CONTRALLOCVOLSECDRYPRODMP.MANDT == LFA1.MANDT` `I_CONTRALLOCVOLSECDRYPRODMP.PRAOWNER == LFA1.LIFNR`
Actual Volume Units Actual Volume Units Client	`I_CONTRALLOCVOLSECDRYPRODMP.VOLUMEUNIT == T006.MSEHI` `I_CONTRALLOCVOLSECDRYPRODMP.MANDT == T006.MANDT`