I_PRATstBslnActlSecdryProd

PRA Test Validation - Secondary Products Baseline | view: IPRATSTBASP | TRAN | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: OIUTV_SB_RNAWC_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 Transporter number
Column Name Description
Column Name Description
📏 Actual Volume Units (VolumeUnit):
ActualVolume Actual Volume
EntitledVolume Entitled Contract Volume
📏 Heating Value Unit (HeatingValUnit):
HeatingValue Heating value
📏 Actual Energy Unit (EnergyUnit):
ActualEnergy Actual Energy
EntitledEnergy Entitled Contract Energy
Column Name Description
SalesDate Sales date
Column Name Description
Column Name Description Domain name
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_PRATSTBSLNACTLSECDRYPROD.DELIVERYNETWORK == OIU_PR_DN.DN_NO
  • I_PRATSTBSLNACTLSECDRYPROD.MANDT == OIU_PR_DN.MANDT
Actual Energy Unit
  • Actual Energy Unit
  • Client
  • I_PRATSTBSLNACTLSECDRYPROD.ENERGYUNIT == T006.MSEHI
  • I_PRATSTBSLNACTLSECDRYPROD.MANDT == T006.MANDT
Heating Value Unit
  • Heating Value Unit
  • Client
  • I_PRATSTBSLNACTLSECDRYPROD.HEATINGVALUNIT == T006.MSEHI
  • I_PRATSTBSLNACTLSECDRYPROD.MANDT == T006.MANDT
Material Number
  • Material Number
  • Client
Original measurement point number
  • Original measurement point number
  • Client
  • I_PRATSTBSLNACTLSECDRYPROD.ORIGINATINGMEASUREMENTPT == OIU_PR_MP.MP_NO
  • I_PRATSTBSLNACTLSECDRYPROD.MANDT == OIU_PR_MP.MANDT
Participant Interest Type I_PRATSTBSLNACTLSECDRYPROD.OWNERINTERESTTYPE == OIU_CM_PINTTY.OWN_INT_TYPE_CD
PRA owner
  • PRA owner
  • Client
  • I_PRATSTBSLNACTLSECDRYPROD.PRAOWNER == LFA1.LIFNR
  • I_PRATSTBSLNACTLSECDRYPROD.MANDT == LFA1.MANDT
Actual Volume Units
  • Actual Volume Units
  • Client
  • I_PRATSTBSLNACTLSECDRYPROD.VOLUMEUNIT == T006.MSEHI
  • I_PRATSTBSLNACTLSECDRYPROD.MANDT == T006.MANDT
Well ID number
  • Well ID number
  • Client
Well Completion Number
  • Well Completion Number
  • Well ID number
  • Client
  • I_PRATSTBSLNACTLSECDRYPROD.WELLCOMPLETION == OIU_PR_WC.WC_NO
  • I_PRATSTBSLNACTLSECDRYPROD.WELL == OIU_PR_WC.WL_NO
  • I_PRATSTBSLNACTLSECDRYPROD.MANDT == OIU_PR_WC.MANDT