I_ContrAllocVolPrimProdWC

CA Volume Primary Product For WC | view: IPVCAVOLPRIWC | TRAN | Extraction: Full only | Component: Production and Revenue Accounting
Tables used: OIU_SB_ACTWC
Column Name Description
Material FK Material Number
PRAContract FK Contract Number
DeliveryNetwork FK Delivery network number
Well FK Well ID number
WellCompletion FK Well Completion Number
OwnerInterestType FK Participant Interest Type
PRAOwner FK PRA owner
OriginatingMeasurementPt FK Original measurement point number
OwnerInterestSequence Owner Interest Sequence Number
SalesDate Sales date
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
  • Delivery network number
  • Client
  • I_CONTRALLOCVOLPRIMPRODWC.DELIVERYNETWORK == OIU_PR_DN.DN_NO
  • I_CONTRALLOCVOLPRIMPRODWC.MANDT == OIU_PR_DN.MANDT
Actual Energy Unit
  • Actual Energy Unit
  • Client
  • I_CONTRALLOCVOLPRIMPRODWC.ENERGYUNIT == T006.MSEHI
  • I_CONTRALLOCVOLPRIMPRODWC.MANDT == T006.MANDT
Heating Value Unit
  • Heating Value Unit
  • Client
  • I_CONTRALLOCVOLPRIMPRODWC.HEATINGVALUNIT == T006.MSEHI
  • I_CONTRALLOCVOLPRIMPRODWC.MANDT == T006.MANDT
Material Number
  • Material Number
  • Client
Original measurement point number
  • Client
  • Original measurement point number
  • I_CONTRALLOCVOLPRIMPRODWC.MANDT == OIU_PR_MP.MANDT
  • I_CONTRALLOCVOLPRIMPRODWC.ORIGINATINGMEASUREMENTPT == OIU_PR_MP.MP_NO
Participant Interest Type I_CONTRALLOCVOLPRIMPRODWC.OWNERINTERESTTYPE == OIU_CM_PINTTY.OWN_INT_TYPE_CD
PRA owner
  • Client
  • PRA owner
  • I_CONTRALLOCVOLPRIMPRODWC.MANDT == LFA1.MANDT
  • I_CONTRALLOCVOLPRIMPRODWC.PRAOWNER == LFA1.LIFNR
Transporter number
  • Transporter number
  • Client
  • I_CONTRALLOCVOLPRIMPRODWC.TRANSPORTER == KNA1.KUNNR
  • I_CONTRALLOCVOLPRIMPRODWC.MANDT == KNA1.MANDT
Actual Volume Units
  • Client
  • Actual Volume Units
  • I_CONTRALLOCVOLPRIMPRODWC.MANDT == T006.MANDT
  • I_CONTRALLOCVOLPRIMPRODWC.VOLUMEUNIT == T006.MSEHI
Well ID number
  • Well ID number
  • Client
Well Completion Number
  • Well ID number
  • Client
  • Well Completion Number
  • I_CONTRALLOCVOLPRIMPRODWC.WELL == OIU_PR_WC.WL_NO
  • I_CONTRALLOCVOLPRIMPRODWC.MANDT == OIU_PR_WC.MANDT
  • I_CONTRALLOCVOLPRIMPRODWC.WELLCOMPLETION == OIU_PR_WC.WC_NO