I_PRATstProdnCompare

Test Validation: Production compare | view: IPRATPC | TRAN | Extraction: Not supported | Component: Production and Revenue Accounting
Column Name Description
PRATstAllocVersion Unique Version ID
WellCompltnVolDoc Well Completion Delivery Volume Header Number
WellCompltnVolDocYr Fiscal Year
Column Name Description
Column Name Description
📏 Standard volume unit (StandardVolUnit):
BaselineStandardVolume Standard volume
StandardVolume Standard volume
📏 Energy quantity unit (EnergyUnit):
BaselineEnergy Energy quantity
Energy Energy quantity
📏 Heating Value Unit (HeatingValUnit):
BaselineHeatingValue Heating value
HeatingValue Heating value
Column Name Description
ProductionDate Production date
InventoryDate Inventory date
EffectiveValidityStartDate Effective from date
Column Name Description
AllocationFrequency Frequency Show values
MajorProduct Major product code Show values
Column Name Description Domain name
EnergyDiffPct null
StandardDensityDiffPct null
StandardVolumeDiffPct null
BaselineStandardDensity Oil/gas density at standard/base conditions OIU_DICHT
StandardDensity Oil/gas density at standard/base conditions OIU_DICHT
BslnNmbrOfDaysProduced Days of Production
NmbrOfDaysProduced Days of Production
StandardVolumeTolPct Test Validation - Standard Volume Tolerance OIUTV_TOL_ABS
EnergyTolVal Test Validation - Energy Tolerance OIUTV_TOL_ABS
StandardDensityTolInPct Test Validatoin - Density Tolerance OIUTV_TOL_ABS
TicketNumber Ticket number OIU_TKT_NO
Master Data Relations Join Conditions
Process code
  • Client
  • Material Number
  • Material Number
Delivery Network
  • Client
  • Delivery network number
  • I_PRATSTPRODNCOMPARE.MANDT == OIU_PR_DN.MANDT
  • I_PRATSTPRODNCOMPARE.DELIVERYNETWORK == OIU_PR_DN.DN_NO
UOM
  • Energy quantity unit
  • Client
  • I_PRATSTPRODNCOMPARE.ENERGYUNIT == T006.MSEHI
  • I_PRATSTPRODNCOMPARE.MANDT == T006.MANDT
UOM
  • Heating Value Unit
  • Client
  • I_PRATSTPRODNCOMPARE.HEATINGVALUNIT == T006.MSEHI
  • I_PRATSTPRODNCOMPARE.MANDT == T006.MANDT
Process code
  • Client
  • Material Number
  • Material Number
Measruement Point
  • Original measurement point number
  • Client
  • I_PRATSTPRODNCOMPARE.ORIGINATINGMEASUREMENTPT == OIU_PR_MP.MP_NO
  • I_PRATSTPRODNCOMPARE.MANDT == OIU_PR_MP.MANDT
UOM
  • Standard volume unit
  • Client
  • I_PRATSTPRODNCOMPARE.STANDARDVOLUNIT == T006.MSEHI
  • I_PRATSTPRODNCOMPARE.MANDT == T006.MANDT
Customer
  • Transporter number
  • Client
  • I_PRATSTPRODNCOMPARE.TRANSPORTER == KNA1.KUNNR
  • I_PRATSTPRODNCOMPARE.MANDT == KNA1.MANDT
Volume type code I_PRATSTPRODNCOMPARE.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD
Well
  • Client
  • Well ID number
Well Completion
  • Client
  • Well ID number
  • Well Completion Number
  • I_PRATSTPRODNCOMPARE.MANDT == OIU_PR_WC.MANDT
  • I_PRATSTPRODNCOMPARE.WELL == OIU_PR_WC.WL_NO
  • I_PRATSTPRODNCOMPARE.WELLCOMPLETION == OIU_PR_WC.WC_NO