C_PRATstActlPrimProdDets

CA - Actual Primary Product Details tab | view: CPRATSTAPPD | TRAN | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: OIU_SB_ACTWC, OIU_SB_RNAWC, OIUTV_SB_ACTWC_B, OIUTV_SB_RNAWC_B, OIUTV_SB_ENTWC_B, OIUTV_SB_RNEWC_B, OIU_SB_ENTWC, OIU_SB_RNEWC, OIU_PR_DN, OIU_PR_DNSTD, OIU_PR_DNSTH, OIU_CM_MAT_PRCD, OIUTV_CA_SCEN, OIUTV_CA_TOL
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 FK Transporter number
AllocationFrequency Frequency Show values
Column Name Description
Column Name Description
📏 Actual Volume Units (VolumeUnit):
BaselineActualVolume Actual Volume
ActualVolume Actual Volume
BaselineEntitledVolume Entitled Contract Volume
EntitledVolume Entitled Contract Volume
BaselineAdjustedEntitledVol Adjusted Entitled Contract Volume
AdjustedEntitledVol Adjusted 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
BaselineAdjustedEntitledEngy Adjusted Entitled Contract Energy
AdjustedEntitledEngy Adjusted Entitled Contract Energy
Column Name Description
SalesDate Sales date
Column Name Description
AllocationFrequency Frequency Show values
MajorProduct Major product code Show values
Column Name Description Domain name
DeliveryNetworkName Delivery network description OIU_TEXT35
ActlPrimStatusCritlty null
ActlPrimStatusText null
PRATstLineStatusCritlty null
PRATstLineStatusText null
ActualVolumeStsCritlty null
ActualHeatingValueStsCritlty null
ActualEnergyStsCritlty null
EntitledVolumeStsCritlty null
AdjustedEntitledVolStsCritlty null
EntitledEnergyStsCritlty null
AdjustedEntitledEngyStsCritlty null
Master Data Relations Join Conditions
Delivery network number
  • Delivery network number
  • Client
  • C_PRATSTACTLPRIMPRODDETS.DELIVERYNETWORK == OIU_PR_DN.DN_NO
  • C_PRATSTACTLPRIMPRODDETS.MANDT == OIU_PR_DN.MANDT
Actual Energy Unit
  • Actual Energy Unit
  • Client
  • C_PRATSTACTLPRIMPRODDETS.ENERGYUNIT == T006.MSEHI
  • C_PRATSTACTLPRIMPRODDETS.MANDT == T006.MANDT
Heating Value Unit
  • Heating Value Unit
  • Client
  • C_PRATSTACTLPRIMPRODDETS.HEATINGVALUNIT == T006.MSEHI
  • C_PRATSTACTLPRIMPRODDETS.MANDT == T006.MANDT
Material Number
  • Material Number
  • Client
Original measurement point number
  • Original measurement point number
  • Client
  • C_PRATSTACTLPRIMPRODDETS.ORIGINATINGMEASUREMENTPT == OIU_PR_MP.MP_NO
  • C_PRATSTACTLPRIMPRODDETS.MANDT == OIU_PR_MP.MANDT
Participant Interest Type C_PRATSTACTLPRIMPRODDETS.OWNERINTERESTTYPE == OIU_CM_PINTTY.OWN_INT_TYPE_CD
PRA owner
  • PRA owner
  • Client
  • C_PRATSTACTLPRIMPRODDETS.PRAOWNER == LFA1.LIFNR
  • C_PRATSTACTLPRIMPRODDETS.MANDT == LFA1.MANDT
Transporter number
  • Transporter number
  • Client
  • C_PRATSTACTLPRIMPRODDETS.TRANSPORTER == KNA1.KUNNR
  • C_PRATSTACTLPRIMPRODDETS.MANDT == KNA1.MANDT
Actual Volume Units
  • Actual Volume Units
  • Client
  • C_PRATSTACTLPRIMPRODDETS.VOLUMEUNIT == T006.MSEHI
  • C_PRATSTACTLPRIMPRODDETS.MANDT == T006.MANDT
Well ID number
  • Well ID number
  • Client
Well Completion Number
  • Well ID number
  • Well Completion Number
  • Client
  • C_PRATSTACTLPRIMPRODDETS.WELL == OIU_PR_WC.WL_NO
  • C_PRATSTACTLPRIMPRODDETS.WELLCOMPLETION == OIU_PR_WC.WC_NO
  • C_PRATSTACTLPRIMPRODDETS.MANDT == OIU_PR_WC.MANDT