C_ContrAllocVolPrimProdQry

CA Volume for Primary Products Query | view: CPVCAVOLPRIM | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: OIU_SB_ACTMP, OIU_SB_ACTWC
Column Name Description
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
MeasurementPoint Measurement point number OIU_MP_NO
OwnerInterestSequence Owner Interest Sequence Number OIU_OWN_ISQ_NO
WetGasOverridePct Wet Gas Override Percent OIU_PERCENT98
CreatedByUser Created By XUBNAME
CreationDateTime Created On Timestamp TZNTSTMPS
Master Data Relations Join Conditions
Delivery network number
  • Client
  • Delivery network number
  • C_CONTRALLOCVOLPRIMPRODQRY.MANDT == OIU_PR_DN.MANDT
  • C_CONTRALLOCVOLPRIMPRODQRY.DELIVERYNETWORK == OIU_PR_DN.DN_NO
Actual Energy Unit
  • Client
  • Actual Energy Unit
  • C_CONTRALLOCVOLPRIMPRODQRY.MANDT == T006.MANDT
  • C_CONTRALLOCVOLPRIMPRODQRY.ENERGYUNIT == T006.MSEHI
Heating Value Unit
  • Client
  • Heating Value Unit
  • C_CONTRALLOCVOLPRIMPRODQRY.MANDT == T006.MANDT
  • C_CONTRALLOCVOLPRIMPRODQRY.HEATINGVALUNIT == T006.MSEHI
Material Number
  • Client
  • Material Number
Original measurement point number
  • Client
  • Original measurement point number
  • C_CONTRALLOCVOLPRIMPRODQRY.MANDT == OIU_PR_MP.MANDT
  • C_CONTRALLOCVOLPRIMPRODQRY.ORIGINATINGMEASUREMENTPT == OIU_PR_MP.MP_NO
Participant Interest Type C_CONTRALLOCVOLPRIMPRODQRY.OWNERINTERESTTYPE == OIU_CM_PINTTY.OWN_INT_TYPE_CD
PRA owner
  • Client
  • PRA owner
  • C_CONTRALLOCVOLPRIMPRODQRY.MANDT == LFA1.MANDT
  • C_CONTRALLOCVOLPRIMPRODQRY.PRAOWNER == LFA1.LIFNR
Transporter number
  • Client
  • Transporter number
  • C_CONTRALLOCVOLPRIMPRODQRY.MANDT == KNA1.MANDT
  • C_CONTRALLOCVOLPRIMPRODQRY.TRANSPORTER == KNA1.KUNNR
Actual Volume Units
  • Client
  • Actual Volume Units
  • C_CONTRALLOCVOLPRIMPRODQRY.MANDT == T006.MANDT
  • C_CONTRALLOCVOLPRIMPRODQRY.VOLUMEUNIT == T006.MSEHI
Well ID number
  • Client
  • Well ID number
Well Completion Number
  • Client
  • Well ID number
  • Well Completion Number
  • C_CONTRALLOCVOLPRIMPRODQRY.MANDT == OIU_PR_WC.MANDT
  • C_CONTRALLOCVOLPRIMPRODQRY.WELL == OIU_PR_WC.WL_NO
  • C_CONTRALLOCVOLPRIMPRODQRY.WELLCOMPLETION == OIU_PR_WC.WC_NO