I_ContrAllocVolPrimProd

CA Volume for Primary Products | view: IPVCAVOLPRIM | TRAN | Extraction: Full only | Component: Production and Revenue Accounting

Tables used: OIU_SB_ACTMP, OIU_SB_ACTWC

🔑 Keys (12)
💰 Amounts
∑ Quantities (7)
📅 Dates (1)
☰ Categorical
Other (4)
🔗 Relations (11)

Column Name	Description
DeliveryNetwork FK	Delivery network number
MeasurementPoint	Measurement point number
Well FK	Well ID number
WellCompletion FK	Well Completion 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 FK	Transporter number

Column Name	Description

Column Name	Description
📏 Actual Volume Units (VolumeUnit):
ActualVolume	Actual Volume
EntitledVolume	Entitled Contract Volume
AdjustedEntitledVol	Adjusted Entitled Contract Volume
📏 Heating Value Unit (HeatingValUnit):
HeatingValue	Heating value
📏 Actual Energy Unit (EnergyUnit):
ActualEnergy	Actual Energy
EntitledEnergy	Entitled Contract Energy
AdjustedEntitledEngy	Adjusted Entitled Contract Energy

Column Name	Description
SalesDate	Sales date

Column Name	Description

Column Name	Description	Domain name
OriginTransaction	Source Transaction ID	FQM_ORIGIN_TRANS_ID
CreatedByUser	Created By	XUBNAME
CreationDateTime	Created On Timestamp	TZNTSTMPS
WetGasOverridePct	Wet Gas Override Percent	OIU_PERCENT98

Master Data Relations	Join Conditions
Delivery network number Client Delivery network number	`I_CONTRALLOCVOLPRIMPROD.MANDT == OIU_PR_DN.MANDT` `I_CONTRALLOCVOLPRIMPROD.DELIVERYNETWORK == OIU_PR_DN.DN_NO`
Actual Energy Unit Actual Energy Unit Client	`I_CONTRALLOCVOLPRIMPROD.ENERGYUNIT == T006.MSEHI` `I_CONTRALLOCVOLPRIMPROD.MANDT == T006.MANDT`
Heating Value Unit Client Heating Value Unit	`I_CONTRALLOCVOLPRIMPROD.MANDT == T006.MANDT` `I_CONTRALLOCVOLPRIMPROD.HEATINGVALUNIT == T006.MSEHI`
Material Number Client Material Number	`I_CONTRALLOCVOLPRIMPROD.MANDT == OIU_CM_MAT_PRCD.MANDT` `I_CONTRALLOCVOLPRIMPROD.MATERIAL == OIU_CM_MAT_PRCD.MATNR`
Original measurement point number Original measurement point number Client	`I_CONTRALLOCVOLPRIMPROD.ORIGINATINGMEASUREMENTPT == OIU_PR_MP.MP_NO` `I_CONTRALLOCVOLPRIMPROD.MANDT == OIU_PR_MP.MANDT`
Participant Interest Type	`I_CONTRALLOCVOLPRIMPROD.OWNERINTERESTTYPE == OIU_CM_PINTTY.OWN_INT_TYPE_CD`
PRA owner Client PRA owner	`I_CONTRALLOCVOLPRIMPROD.MANDT == LFA1.MANDT` `I_CONTRALLOCVOLPRIMPROD.PRAOWNER == LFA1.LIFNR`
Transporter number Transporter number Client	`I_CONTRALLOCVOLPRIMPROD.TRANSPORTER == KNA1.KUNNR` `I_CONTRALLOCVOLPRIMPROD.MANDT == KNA1.MANDT`
Actual Volume Units Client Actual Volume Units	`I_CONTRALLOCVOLPRIMPROD.MANDT == T006.MANDT` `I_CONTRALLOCVOLPRIMPROD.VOLUMEUNIT == T006.MSEHI`
Well ID number Client Well ID number	`I_CONTRALLOCVOLPRIMPROD.MANDT == OIU_PR_WELL.MANDT` `I_CONTRALLOCVOLPRIMPROD.WELL == OIU_PR_WELL.WL_NO`
Well Completion Number Client Well Completion Number Well ID number	`I_CONTRALLOCVOLPRIMPROD.MANDT == OIU_PR_WC.MANDT` `I_CONTRALLOCVOLPRIMPROD.WELLCOMPLETION == OIU_PR_WC.WC_NO` `I_CONTRALLOCVOLPRIMPROD.WELL == OIU_PR_WC.WL_NO`