P_ContrAllocVolSecdryProd

Private view for CA Volumes for Primary Products | view: PPVCAVOLSECDRY | TRAN | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: OIU_SB_RNAMPOIU_SB_RNAWC
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 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
  • P_CONTRALLOCVOLSECDRYPROD.DELIVERYNETWORK == OIU_PR_DN.DN_NO
  • P_CONTRALLOCVOLSECDRYPROD.MANDT == OIU_PR_DN.MANDT
Actual Energy Unit
  • Actual Energy Unit
  • Client
  • P_CONTRALLOCVOLSECDRYPROD.ENERGYUNIT == T006.MSEHI
  • P_CONTRALLOCVOLSECDRYPROD.MANDT == T006.MANDT
Heating Value Unit
  • Client
  • Heating Value Unit
  • P_CONTRALLOCVOLSECDRYPROD.MANDT == T006.MANDT
  • P_CONTRALLOCVOLSECDRYPROD.HEATINGVALUNIT == T006.MSEHI
Material Number
  • Client
  • Material Number
Original measurement point number
  • Client
  • Original measurement point number
  • P_CONTRALLOCVOLSECDRYPROD.MANDT == OIU_PR_MP.MANDT
  • P_CONTRALLOCVOLSECDRYPROD.ORIGINATINGMEASUREMENTPT == OIU_PR_MP.MP_NO
Participant Interest Type P_CONTRALLOCVOLSECDRYPROD.OWNERINTERESTTYPE == OIU_CM_PINTTY.OWN_INT_TYPE_CD
PRA owner
  • Client
  • PRA owner
  • P_CONTRALLOCVOLSECDRYPROD.MANDT == LFA1.MANDT
  • P_CONTRALLOCVOLSECDRYPROD.PRAOWNER == LFA1.LIFNR
Actual Volume Units
  • Actual Volume Units
  • Client
  • P_CONTRALLOCVOLSECDRYPROD.VOLUMEUNIT == T006.MSEHI
  • P_CONTRALLOCVOLSECDRYPROD.MANDT == T006.MANDT
Well ID number
  • Client
  • Well ID number
Well Completion Number
  • Client
  • Well Completion Number
  • Well ID number
  • P_CONTRALLOCVOLSECDRYPROD.MANDT == OIU_PR_WC.MANDT
  • P_CONTRALLOCVOLSECDRYPROD.WELLCOMPLETION == OIU_PR_WC.WC_NO
  • P_CONTRALLOCVOLSECDRYPROD.WELL == OIU_PR_WC.WL_NO