I_PRATstBslnProdnRslts

PRA Test validation - Baseline production result | view: IPRATBPR | TRAN | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: OIUTV_WCDVLH_B
Column Name Description
PRATstAllocVersion Unique Version ID
WellCompltnVolDoc Well Completion Delivery Volume Header Number
WellCompltnVolDocYr Fiscal Year
Column Name Description
Column Name Description
📏 Theoretical Unit (ThrtclVolUnit):
TheoreticalVolume Theoretical Volume
📏 Standard volume unit (StandardVolUnit):
BaselineStandardVolume Standard volume
📏 Energy quantity unit (EnergyUnit):
BaselineEnergy Energy quantity
📏 Heating Value Unit (HeatingValUnit):
BaselineHeatingValue Heating value
GasMolarVolume Gas mol volume
Column Name Description
EffectiveValidityStartDate Effective from date
EffectiveValidityEndDate Effective To Date
ProductionDate Production date
InventoryDate Inventory date
Column Name Description
AllocationFrequency Frequency Show values
VolumeClass Volume class code Show values
DensityType Density Type Show values
Column Name Description Domain name
TransporterReference Transporter Reference Number OIU_TEXT25
BslnNmbrOfDaysProduced Days of Production
TicketNumber Ticket number OIU_TKT_NO
TicketDateTime Ticket Timestamp (Date) TZNTSTMPS
BaselineStandardDensity Oil/gas density at standard/base conditions OIU_DICHT
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
Process code
  • Client
  • Material Number
Conversion Group
  • Client
  • Conversion Group (Oil, Natural Gas,..)
  • I_PRATSTBSLNPRODNRSLTS.MANDT == OIB01.MANDT
  • I_PRATSTBSLNPRODNRSLTS.CONVERSIONGROUP == OIB01.UMRSL
Well Number
  • Client
  • Cross-Reference Well Number
Well Compleation
  • Client
  • Cross-Reference Wellcompletion Number
  • Well ID number
  • I_PRATSTBSLNPRODNRSLTS.MANDT == OIU_PR_WC.MANDT
  • I_PRATSTBSLNPRODNRSLTS.CROSSREFWELLCOMPLETION == OIU_PR_WC.WC_NO
  • I_PRATSTBSLNPRODNRSLTS.WELL == OIU_PR_WC.WL_NO
Delivery Network
  • Delivery network number
  • Client
  • I_PRATSTBSLNPRODNRSLTS.DELIVERYNETWORK == OIU_PR_DN.DN_NO
  • I_PRATSTBSLNPRODNRSLTS.MANDT == OIU_PR_DN.MANDT
UOM
  • Energy quantity unit
  • Client
  • I_PRATSTBSLNPRODNRSLTS.ENERGYUNIT == T006.MSEHI
  • I_PRATSTBSLNPRODNRSLTS.MANDT == T006.MANDT
UOM
  • Client
  • Heating Value Unit
  • I_PRATSTBSLNPRODNRSLTS.MANDT == T006.MANDT
  • I_PRATSTBSLNPRODNRSLTS.HEATINGVALUNIT == T006.MSEHI
Measruement Point
  • Client
  • Original measurement point number
  • I_PRATSTBSLNPRODNRSLTS.MANDT == OIU_PR_MP.MANDT
  • I_PRATSTBSLNPRODNRSLTS.ORIGINATINGMEASUREMENTPT == OIU_PR_MP.MP_NO
Material/Process code
  • Client
  • Production Material
UOM
  • Client
  • Standard volume unit
  • I_PRATSTBSLNPRODNRSLTS.MANDT == T006.MANDT
  • I_PRATSTBSLNPRODNRSLTS.STANDARDVOLUNIT == T006.MSEHI
Measurement Point
  • Client
  • Tank battery measurement point number
  • I_PRATSTBSLNPRODNRSLTS.MANDT == OIU_PR_MP.MANDT
  • I_PRATSTBSLNPRODNRSLTS.TANKBATTERYMEASUREMENTPT == OIU_PR_MP.MP_NO
UOM
  • Client
  • Theoretical Unit
  • I_PRATSTBSLNPRODNRSLTS.MANDT == T006.MANDT
  • I_PRATSTBSLNPRODNRSLTS.THRTCLVOLUNIT == T006.MSEHI
Customer
  • Client
  • Transporter number
  • I_PRATSTBSLNPRODNRSLTS.MANDT == KNA1.MANDT
  • I_PRATSTBSLNPRODNRSLTS.TRANSPORTER == KNA1.KUNNR
Volume Source Code
  • Client
  • Volume Source Code
Volume type code I_PRATSTBSLNPRODNRSLTS.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD
Well
  • Client
  • Well ID number
Well Completion
  • Client
  • Well Completion Number
  • Well ID number
  • I_PRATSTBSLNPRODNRSLTS.MANDT == OIU_PR_WC.MANDT
  • I_PRATSTBSLNPRODNRSLTS.WELLCOMPLETION == OIU_PR_WC.WC_NO
  • I_PRATSTBSLNPRODNRSLTS.WELL == OIU_PR_WC.WL_NO