P_ContrAllocVolPrimProd

Private view for CA Volumes for Primary Products | view: PPVCAVOLPRIM | TRAN | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: OIU_SB_ACTMP, OIU_SB_ACTWC
Column Name Description
Material FK Material Number
PRAContract FK Contract Number
DeliveryNetwork FK Delivery network number
MeasurementPoint Measurement point 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
WetGasOverridePct Wet Gas Override Percent OIU_PERCENT98
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
  • P_CONTRALLOCVOLPRIMPROD.DELIVERYNETWORK == OIU_PR_DN.DN_NO
  • P_CONTRALLOCVOLPRIMPROD.MANDT == OIU_PR_DN.MANDT
Actual Energy Unit
  • Actual Energy Unit
  • Client
  • P_CONTRALLOCVOLPRIMPROD.ENERGYUNIT == T006.MSEHI
  • P_CONTRALLOCVOLPRIMPROD.MANDT == T006.MANDT
Heating Value Unit
  • Client
  • Heating Value Unit
  • P_CONTRALLOCVOLPRIMPROD.MANDT == T006.MANDT
  • P_CONTRALLOCVOLPRIMPROD.HEATINGVALUNIT == T006.MSEHI
Material Number
  • Client
  • Material Number
Original measurement point number
  • Client
  • Original measurement point number
  • P_CONTRALLOCVOLPRIMPROD.MANDT == OIU_PR_MP.MANDT
  • P_CONTRALLOCVOLPRIMPROD.ORIGINATINGMEASUREMENTPT == OIU_PR_MP.MP_NO
Participant Interest Type P_CONTRALLOCVOLPRIMPROD.OWNERINTERESTTYPE == OIU_CM_PINTTY.OWN_INT_TYPE_CD
PRA owner
  • Client
  • PRA owner
  • P_CONTRALLOCVOLPRIMPROD.MANDT == LFA1.MANDT
  • P_CONTRALLOCVOLPRIMPROD.PRAOWNER == LFA1.LIFNR
Transporter number
  • Transporter number
  • Client
  • P_CONTRALLOCVOLPRIMPROD.TRANSPORTER == KNA1.KUNNR
  • P_CONTRALLOCVOLPRIMPROD.MANDT == KNA1.MANDT
Actual Volume Units
  • Actual Volume Units
  • Client
  • P_CONTRALLOCVOLPRIMPROD.VOLUMEUNIT == T006.MSEHI
  • P_CONTRALLOCVOLPRIMPROD.MANDT == T006.MANDT
Well ID number
  • Well ID number
  • Client
Well Completion Number
  • Well ID number
  • Client
  • Well Completion Number
  • P_CONTRALLOCVOLPRIMPROD.WELL == OIU_PR_WC.WL_NO
  • P_CONTRALLOCVOLPRIMPROD.MANDT == OIU_PR_WC.MANDT
  • P_CONTRALLOCVOLPRIMPROD.WELLCOMPLETION == OIU_PR_WC.WC_NO