I_PRATstBslnActlPrimProd

PRA Test Validation - Baseline Primary Products Actual Vols | view: IPRATBCAACTWC | TRAN | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: OIUTV_SB_ACTWC_B
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
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
AllocationFrequency Frequency Show values
Column Name Description Domain name
WetGasOverridePct Wet Gas Override Percent OIU_PERCENT98
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CreationDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
SequenceNumber null
Master Data Relations Join Conditions
Delivery network number
  • Delivery network number
  • Client
  • I_PRATSTBSLNACTLPRIMPROD.DELIVERYNETWORK == OIU_PR_DN.DN_NO
  • I_PRATSTBSLNACTLPRIMPROD.MANDT == OIU_PR_DN.MANDT
Actual Energy Unit
  • Client
  • Actual Energy Unit
  • I_PRATSTBSLNACTLPRIMPROD.MANDT == T006.MANDT
  • I_PRATSTBSLNACTLPRIMPROD.ENERGYUNIT == T006.MSEHI
Heating Value Unit
  • Heating Value Unit
  • Client
  • I_PRATSTBSLNACTLPRIMPROD.HEATINGVALUNIT == T006.MSEHI
  • I_PRATSTBSLNACTLPRIMPROD.MANDT == T006.MANDT
Material Number
  • Client
  • Material Number
Original measurement point number
  • Original measurement point number
  • Client
  • I_PRATSTBSLNACTLPRIMPROD.ORIGINATINGMEASUREMENTPT == OIU_PR_MP.MP_NO
  • I_PRATSTBSLNACTLPRIMPROD.MANDT == OIU_PR_MP.MANDT
Participant Interest Type I_PRATSTBSLNACTLPRIMPROD.OWNERINTERESTTYPE == OIU_CM_PINTTY.OWN_INT_TYPE_CD
PRA owner
  • PRA owner
  • Client
  • I_PRATSTBSLNACTLPRIMPROD.PRAOWNER == LFA1.LIFNR
  • I_PRATSTBSLNACTLPRIMPROD.MANDT == LFA1.MANDT
Transporter number
  • Client
  • Transporter number
  • I_PRATSTBSLNACTLPRIMPROD.MANDT == KNA1.MANDT
  • I_PRATSTBSLNACTLPRIMPROD.TRANSPORTER == KNA1.KUNNR
Actual Volume Units
  • Actual Volume Units
  • Client
  • I_PRATSTBSLNACTLPRIMPROD.VOLUMEUNIT == T006.MSEHI
  • I_PRATSTBSLNACTLPRIMPROD.MANDT == T006.MANDT
Well ID number
  • Client
  • Well ID number
Well Completion Number
  • Client
  • Well Completion Number
  • Well ID number
  • I_PRATSTBSLNACTLPRIMPROD.MANDT == OIU_PR_WC.MANDT
  • I_PRATSTBSLNACTLPRIMPROD.WELLCOMPLETION == OIU_PR_WC.WC_NO
  • I_PRATSTBSLNACTLPRIMPROD.WELL == OIU_PR_WC.WL_NO