I_PRATstEntldPrimProd

PRA - Entitlement Primary Products Actual Vols | view: IPRATSTEPP | TRAN | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: OIU_SB_ENTWC
Column Name Description
DeliveryNetwork FK Delivery network number
Material FK Material Number
Well FK Well ID number
WellCompletion FK Well Completion Number
ProcessingCompanyCode FK Company Code
PRAJointVenture FK Joint venture
DivisionOfInterest FK Division of interest (DOI)
SalesDate Sales date
AllocationFrequency Frequency Show values
VolumeType FK Volume type code
PRAOwner FK PRA owner
OwnerInterestType FK Participant Interest Type
OwnerInterestSequence Owner Interest Sequence Number
Column Name Description
Column Name Description
📏 Volume Unit (VolumeUnit):
EntitledVolume Entitled Volume
AdjustedEntitledVol Adjusted Entitlement Volume
📏 Energy quantity unit (EnergyUnit):
EntitledEnergy Entitlement Energy
AdjustedEntitledEngy Adjusted Entitlement Energy
Column Name Description
SalesDate Sales date
Column Name Description
AllocationFrequency Frequency Show values
Column Name Description Domain name
MarketingRepIntrstSequNmbr Marketing Representative Interest Sequence No OIU_MK_REP_ISQ_NO
GrossRevenueInterestRatio Gross Revenue Interest Decimal OIU_PERCENT98
AdjdGrossRevenueInterestRatio Adjusted GRI Percentage OIU_PERCENT98
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CreationDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Delivery network number
  • Client
  • Delivery network number
  • I_PRATSTENTLDPRIMPROD.MANDT == OIU_PR_DN.MANDT
  • I_PRATSTENTLDPRIMPROD.DELIVERYNETWORK == OIU_PR_DN.DN_NO
Division of interest (DOI)
  • Company Code
  • Client
  • Joint venture
  • Division of interest (DOI)
  • I_PRATSTENTLDPRIMPROD.PROCESSINGCOMPANYCODE == OIU_DO_DI.BUKRS
  • I_PRATSTENTLDPRIMPROD.MANDT == OIU_DO_DI.MANDT
  • I_PRATSTENTLDPRIMPROD.PRAJOINTVENTURE == OIU_DO_DI.VNAME
  • I_PRATSTENTLDPRIMPROD.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
Energy quantity unit
  • Client
  • Energy quantity unit
  • I_PRATSTENTLDPRIMPROD.MANDT == T006.MANDT
  • I_PRATSTENTLDPRIMPROD.ENERGYUNIT == T006.MSEHI
Marketing Representative No
  • Client
  • Marketing Representative No
  • I_PRATSTENTLDPRIMPROD.MANDT == KNA1.MANDT
  • I_PRATSTENTLDPRIMPROD.MARKETINGREP == KNA1.KUNNR
Material Number
  • Client
  • Material Number
Participant Interest Type I_PRATSTENTLDPRIMPROD.OWNERINTERESTTYPE == OIU_CM_PINTTY.OWN_INT_TYPE_CD
Joint venture
  • Company Code
  • Client
  • Joint venture
  • I_PRATSTENTLDPRIMPROD.PROCESSINGCOMPANYCODE == OIU_DO_JV.BUKRS
  • I_PRATSTENTLDPRIMPROD.MANDT == OIU_DO_JV.MANDT
  • I_PRATSTENTLDPRIMPROD.PRAJOINTVENTURE == OIU_DO_JV.VNAME
PRA owner
  • Client
  • PRA owner
  • I_PRATSTENTLDPRIMPROD.MANDT == LFA1.MANDT
  • I_PRATSTENTLDPRIMPROD.PRAOWNER == LFA1.LIFNR
Company Code
  • Company Code
  • Client
  • I_PRATSTENTLDPRIMPROD.PROCESSINGCOMPANYCODE == T001.BUKRS
  • I_PRATSTENTLDPRIMPROD.MANDT == T001.MANDT
Volume type code I_PRATSTENTLDPRIMPROD.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD
Volume Unit
  • Client
  • Volume Unit
  • I_PRATSTENTLDPRIMPROD.MANDT == T006.MANDT
  • I_PRATSTENTLDPRIMPROD.VOLUMEUNIT == T006.MSEHI
Well ID number
  • Client
  • Well ID number
Well Completion Number
  • Client
  • Well Completion Number
  • Well ID number
  • I_PRATSTENTLDPRIMPROD.MANDT == OIU_PR_WC.MANDT
  • I_PRATSTENTLDPRIMPROD.WELLCOMPLETION == OIU_PR_WC.WC_NO
  • I_PRATSTENTLDPRIMPROD.WELL == OIU_PR_WC.WL_NO