I_PRATstEntldSecdryProd

TV Entld Secdry Actual Vols | view: IPRATSTESP | TRAN | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: OIU_SB_RNEWC
Column Name Description
DeliveryNetwork FK Delivery network number
Well FK Well ID number
WellCompletion FK Well Completion Number
Material FK Material Number
VolumeType FK Volume type code
SalesDate Sales date
PRAOwner FK PRA owner
OwnerInterestType FK Participant Interest Type
OwnerInterestSequence Owner Interest Sequence Number
Column Name Description
Column Name Description
📏 Entitled Volume Unit (VolumeUnit):
EntitledVolume Entitled Volume
LeaseSalesVolumeInVolUnit Lease Volume
📏 Energy quantity unit (EnergyUnit):
EntitledEnergy Entitlement Energy
Column Name Description
SalesDate Sales date
Column Name Description
Column Name Description Domain name
GrossRevenueInterestRatio Gross Revenue Interest Decimal OIU_PERCENT98
PRAContract Contract Number OIUCM_CONTRACT_NUMBER
BaselineMarketingRep Marketing Representative No KUNNR
BslnMktRepIntrstSequNmbr Marketing Representative Interest Sequence No OIU_MK_REP_ISQ_NO
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_PRATSTENTLDSECDRYPROD.MANDT == OIU_PR_DN.MANDT
  • I_PRATSTENTLDSECDRYPROD.DELIVERYNETWORK == OIU_PR_DN.DN_NO
Heating Value Unit
  • Heating Value Unit
  • Client
  • I_PRATSTENTLDSECDRYPROD.HEATINGVALUNIT == T006.MSEHI
  • I_PRATSTENTLDSECDRYPROD.MANDT == T006.MANDT
Material Number
  • Client
  • Material Number
Participant Interest Type I_PRATSTENTLDSECDRYPROD.OWNERINTERESTTYPE == OIU_CM_PINTTY.OWN_INT_TYPE_CD
PRA owner
  • PRA owner
  • Client
  • I_PRATSTENTLDSECDRYPROD.PRAOWNER == LFA1.LIFNR
  • I_PRATSTENTLDSECDRYPROD.MANDT == LFA1.MANDT
Volume type code I_PRATSTENTLDSECDRYPROD.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD
Entitled Volume Unit
  • Entitled Volume Unit
  • Client
  • I_PRATSTENTLDSECDRYPROD.VOLUMEUNIT == T006.MSEHI
  • I_PRATSTENTLDSECDRYPROD.MANDT == T006.MANDT
Well ID number
  • Client
  • Well ID number
Well Completion Number
  • Well Completion Number
  • Client
  • Well ID number
  • I_PRATSTENTLDSECDRYPROD.WELLCOMPLETION == OIU_PR_WC.WC_NO
  • I_PRATSTENTLDSECDRYPROD.MANDT == OIU_PR_WC.MANDT
  • I_PRATSTENTLDSECDRYPROD.WELL == OIU_PR_WC.WL_NO