I_PRATstActlPrimProdCompareUI

TV - Primary Productions : Calculate UI | view: IPRATACTWCCUI | TRAN | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: OIU_SB_ACTWC, OIUTV_SB_ACTWC_B, OIU_CM_MAT_PRCD, OIUTV_CA_SCEN, OIUTV_CA_TOL
Column Name Description
PRATstAllocVersion Unique Version ID
DeliveryNetwork FK Delivery network 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
AllocationFrequency Frequency Show values
Column Name Description
Column Name Description
📏 Actual Volume Units (VolumeUnit):
ActualVolume Actual Volume
BaselineActualVolume Actual Volume
BaselineActualHeatingValue Heating value
ActualHeatingValue Heating value
BaselineActualEnergy Actual Energy
ActualEnergy Actual Energy
BaselineEntitledVolume Entitled Contract Volume
EntitledVolume Entitled Contract Volume
BaselineAdjustedEntitledVol Adjusted Entitled Contract Volume
AdjustedEntitledVol Adjusted Entitled Contract Volume
BaselineEntitledEnergy Entitled Contract Energy
EntitledEnergy Entitled Contract Energy
BaselineAdjustedEntitledEngy Adjusted Entitled Contract Energy
AdjustedEntitledEngy Adjusted Entitled Contract Energy
Column Name Description
SalesDate Sales date
Column Name Description
AllocationFrequency Frequency Show values
MajorProduct Major product code Show values
Column Name Description Domain name
ActualVolumeStsCritlty null
ActualHeatingValueStsCritlty null
ActualEnergyStsCritlty null
EntitledVolumeStsCritlty null
AdjustedEntitledVolStsCritlty null
EntitledEnergyStsCritlty null
AdjustedEntitledEngyStsCritlty null
Master Data Relations Join Conditions
Delivery network number
  • Delivery network number
  • Client
  • I_PRATSTACTLPRIMPRODCOMPAREUI.DELIVERYNETWORK == OIU_PR_DN.DN_NO
  • I_PRATSTACTLPRIMPRODCOMPAREUI.MANDT == OIU_PR_DN.MANDT
Actual Energy Unit
  • Actual Energy Unit
  • Client
  • I_PRATSTACTLPRIMPRODCOMPAREUI.ENERGYUNIT == T006.MSEHI
  • I_PRATSTACTLPRIMPRODCOMPAREUI.MANDT == T006.MANDT
Heating Value Unit
  • Heating Value Unit
  • Client
  • I_PRATSTACTLPRIMPRODCOMPAREUI.HEATINGVALUNIT == T006.MSEHI
  • I_PRATSTACTLPRIMPRODCOMPAREUI.MANDT == T006.MANDT
Material Number
  • Client
  • Material Number
Original measurement point number
  • Original measurement point number
  • Client
  • I_PRATSTACTLPRIMPRODCOMPAREUI.ORIGINATINGMEASUREMENTPT == OIU_PR_MP.MP_NO
  • I_PRATSTACTLPRIMPRODCOMPAREUI.MANDT == OIU_PR_MP.MANDT
Participant Interest Type I_PRATSTACTLPRIMPRODCOMPAREUI.OWNERINTERESTTYPE == OIU_CM_PINTTY.OWN_INT_TYPE_CD
PRA owner
  • Client
  • PRA owner
  • I_PRATSTACTLPRIMPRODCOMPAREUI.MANDT == LFA1.MANDT
  • I_PRATSTACTLPRIMPRODCOMPAREUI.PRAOWNER == LFA1.LIFNR
Transporter number
  • Transporter number
  • Client
  • I_PRATSTACTLPRIMPRODCOMPAREUI.TRANSPORTER == KNA1.KUNNR
  • I_PRATSTACTLPRIMPRODCOMPAREUI.MANDT == KNA1.MANDT
Actual Volume Units
  • Actual Volume Units
  • Client
  • I_PRATSTACTLPRIMPRODCOMPAREUI.VOLUMEUNIT == T006.MSEHI
  • I_PRATSTACTLPRIMPRODCOMPAREUI.MANDT == T006.MANDT
Well ID number
  • Client
  • Well ID number
  • I_PRATSTACTLPRIMPRODCOMPAREUI.MANDT == OIU_PR_WELL.MANDT
  • I_PRATSTACTLPRIMPRODCOMPAREUI.WELL == OIU_PR_WELL.WL_NO
Well Completion Number
  • Well Completion Number
  • Client
  • Well ID number
  • I_PRATSTACTLPRIMPRODCOMPAREUI.WELLCOMPLETION == OIU_PR_WC.WC_NO
  • I_PRATSTACTLPRIMPRODCOMPAREUI.MANDT == OIU_PR_WC.MANDT
  • I_PRATSTACTLPRIMPRODCOMPAREUI.WELL == OIU_PR_WC.WL_NO