I_PRATstActlSecdryCompare

TV - Secondary Products Compare | view: IPRATSTASPC | TRAN | Extraction: Not supported | Component: Production and Revenue Accounting
Column Name Description
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 Transporter number
Column Name Description
Column Name Description
📏 Actual Volume Units (VolumeUnit):
BaselineActualVolume Actual Volume
ActualVolume Actual Volume
BaselineEntitledVolume Entitled Contract Volume
EntitledVolume Entitled Contract Volume
📏 Heating Value Unit (HeatingValUnit):
BaselineActualHeatingValue Heating value
ActualHeatingValue Heating value
📏 Actual Energy Unit (EnergyUnit):
BaselineActualEnergy Actual Energy
ActualEnergy Actual Energy
BaselineEntitledEnergy Entitled Contract Energy
EntitledEnergy Entitled Contract Energy
Column Name Description
SalesDate Sales date
Column Name Description
MajorProduct Major product code Show values
Column Name Description Domain name
ActualVolumeDiffval null
ActualHeatingValueDiffVal null
ActualEnergyDiffVal null
EntitledVolumeDiffVal null
EntitledEnergyDiffVal null
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CreationDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
SequenceNumber null
SecdryActlVolTolVal Test Validation - Secondary Actual Volume Tolerance OIUTV_TOL_ABS
SecdryActlHeatValTolVal Test Validation - Secondary Actual Heating Value Tolerance OIUTV_TOL_ABS
SecdryActlEngyTolVal Test Validation - Secondary Actual Energy Tolerance OIUTV_TOL_ABS
SecdryEntldVolTolVal Test Validation - Secondary Entitled Volume Tolerance OIUTV_TOL_ABS
SecdryEntldEngyTolVal Test Validation - Secondary Entl Energy Tolerance OIUTV_TOL_ABS
Master Data Relations Join Conditions
Delivery network number
  • Client
  • Delivery network number
  • I_PRATSTACTLSECDRYCOMPARE.MANDT == OIU_PR_DN.MANDT
  • I_PRATSTACTLSECDRYCOMPARE.DELIVERYNETWORK == OIU_PR_DN.DN_NO
Actual Energy Unit
  • Client
  • Actual Energy Unit
  • I_PRATSTACTLSECDRYCOMPARE.MANDT == T006.MANDT
  • I_PRATSTACTLSECDRYCOMPARE.ENERGYUNIT == T006.MSEHI
Heating Value Unit
  • Client
  • Heating Value Unit
  • I_PRATSTACTLSECDRYCOMPARE.MANDT == T006.MANDT
  • I_PRATSTACTLSECDRYCOMPARE.HEATINGVALUNIT == T006.MSEHI
Material Number
  • Client
  • Material Number
Original measurement point number
  • Client
  • Original measurement point number
  • I_PRATSTACTLSECDRYCOMPARE.MANDT == OIU_PR_MP.MANDT
  • I_PRATSTACTLSECDRYCOMPARE.ORIGINATINGMEASUREMENTPT == OIU_PR_MP.MP_NO
Participant Interest Type I_PRATSTACTLSECDRYCOMPARE.OWNERINTERESTTYPE == OIU_CM_PINTTY.OWN_INT_TYPE_CD
PRA owner
  • Client
  • PRA owner
  • I_PRATSTACTLSECDRYCOMPARE.MANDT == LFA1.MANDT
  • I_PRATSTACTLSECDRYCOMPARE.PRAOWNER == LFA1.LIFNR
Actual Volume Units
  • Actual Volume Units
  • Client
  • I_PRATSTACTLSECDRYCOMPARE.VOLUMEUNIT == T006.MSEHI
  • I_PRATSTACTLSECDRYCOMPARE.MANDT == T006.MANDT
Well ID number
  • Client
  • Well ID number
Well Completion Number
  • Client
  • Well ID number
  • Well Completion Number
  • I_PRATSTACTLSECDRYCOMPARE.MANDT == OIU_PR_WC.MANDT
  • I_PRATSTACTLSECDRYCOMPARE.WELL == OIU_PR_WC.WL_NO
  • I_PRATSTACTLSECDRYCOMPARE.WELLCOMPLETION == OIU_PR_WC.WC_NO