I_ONRRRptgHistoryPRADetails

ONRR Reporting History PRA Details | view: IPVONRRRRHPRA | TRAN | Extraction: Full only | Component: Production and Revenue Accounting
Tables used: /PRA/FP_PRDT_HST
Column Name Description
SalesDate Sales Date / Month
CompanyCode FK Company Code
JointVenture FK Joint venture
DivisionOfInterest FK Division of interest (DOI)
Well FK Well ID number
WellCompletion FK Well Completion Number
PRAContract FK Contract Number
VolumeType FK Volume Type Code
Product FK Full three char. product code (Major and Detail Products)
PRAOwner FK PRA owner
GLAccount FK G/L Account Number
CostCenter FK Cost Center
ONRRBusinessTransactionType ONRR-2014 - PRA Detail Line Type Show values
Column Name Description
💲 Currency Key (Currency):
OwnerNetAmount Owner Net Value
OwnerGrossAmount Owner Gross Value
GrossAmount Gross value
TranspAllwncDeductAdjmtAmt ONRR-2014 - Transportation Allowance Deduction Adjustment
ProcgAllwncDeductAdjmtAmt ONRR-2014 - Processing Allowance Deduction Adjustment
RoyaltyDueAdjustmentAmount ONRR-2014 - Royalty Due Adjustment
TranspAllwncDeductAmt ONRR-2014 - Transportation Allowance Deduction
ProcgAllwncDeductAmt ONRR-2014 - Processing Allowance Deduction
TaxAmount ONRR-2014 - Tax
TaxReimbursementAmount ONRR-2014 - Tax Reimbursement
MarketingReimbursementAmount ONRR-2014 - Marketing Reimbursement
Column Name Description
📏 Volume Base Unit of Measure (VolumeUnit):
OwnerNetVolInVolUnit Owner Net Volume
GrossVolInVolUnit Total Gross Volume
📏 Energy Base Unit Of Measure (EnergyUnit):
OwnerEnergyInEnergyUnit Owner Energy
GrossEnergyInEnergyUnit Gross Energy
Column Name Description
SalesDate Sales Date / Month
Column Name Description
ONRRBusinessTransactionType ONRR-2014 - PRA Detail Line Type Show values
AgencyReportType Proc 2.0 - Amended/Current Indicator Show values
MasterDataRecordingLvl ONRR-2014 - Master Level Show values
IsCompensatoryRoyalty ONRR-2014 - Compensatory Royalty Flag Show values
IsSection6LeaseOverride ONRR-2014 - Section 6 Lease Flag Show values
IsShallowWaterRoyaltyRelieved ONRR-2014 - Royalty Relief - Shallow Flag Show values
IsDeepWaterRoyaltyRelieved ONRR-2014 - Royalty Relief - Deep Flag Show values
IsRptgAtAPIWellLvl ONRR-2014 - Report API Well Flag Show values
ONRRLessorType ONRR-2014 - Lessor Code Show values
TribalOrAllotteeLeaseType ONRR-2014 - Tribal / Allottee Indicator Show values
OnOrOffShoreLeaseSale ONRR-2014 - On-Shore/Off-Shore Indicator Show values
IsSection6Lease Section 6 Show values
HasTransactionCode37 Transaction 37 Show values
HasTransactionCode38 Transaction 38 Show values
ONRRReportedProduct ONRR-2014 - Product Code Show values
ONRRReportedTransType ONRR-2014 - Transaction Code Show values
ONRRPaymentMethod ONRR-2014 - Payment Method Code Show values
ONRRReportStatus ONRR-2014 - Status Show values
ONRROverrideAdjmtReason ONRR-2014 - Override Adjustment Code Show values
IsRejectOverridden ONRR-2014 - Override Reject Flag Show values
FutureRptHasRoyaltyDueAdjmt ONRR-2014: Persist Royalty Due Adjustment Show values
SalesFigureIsToBeRecalculated ONRR-2014: Recalculate Sales Vol/Val Show values
Column Name Description Domain name
DeliveryNetwork Delivery network number OIU_DN_NO
AllocationPercent ONRR-2014 - Allocation Percent OIU_PERCENT98
OverrideRoyaltyRate ONRR-2014 - Override Royalty Rate OIU_PERCENT98
ONRRLeaseName ONRR-2014 - Lease Name TEXT20
APIWellNumber ONRR-2014 - API Well Number
RoyaltyRate ONRR-2014 - Royalty Rate /PRA/FP_ROYALTY_RATE
OverrideDocument ONRR-2014 - Override Payor Assigned Document Number
CreatedByUser Created By XUBNAME
CreationDateTime Created On Timestamp TZNTSTMPS
OriginTransaction Source Transaction ID FQM_ORIGIN_TRANS_ID
Master Data Relations | to Other Relations ↓ Join Conditions
Company Code
  • Client
  • Company Code
Cost Center
  • ?
  • ?
  • Cost Center
  • Client
  • I_ONRRRPTGHISTORYPRADETAILS.[column in domain "KOKRS"] == CSKS.KOKRS
  • I_ONRRRPTGHISTORYPRADETAILS.[column in domain "DATBI"] == CSKS.DATBI
  • I_ONRRRPTGHISTORYPRADETAILS.COSTCENTER == CSKS.KOSTL
  • I_ONRRRPTGHISTORYPRADETAILS.MANDT == CSKS.MANDT
Currency Key
  • Client
  • Currency Key
  • I_ONRRRPTGHISTORYPRADETAILS.MANDT == TCURC.MANDT
  • I_ONRRRPTGHISTORYPRADETAILS.CURRENCY == TCURC.WAERS
Division of interest (DOI)
  • Client
  • Joint venture
  • Company Code
  • Division of interest (DOI)
  • I_ONRRRPTGHISTORYPRADETAILS.MANDT == OIU_DO_DI.MANDT
  • I_ONRRRPTGHISTORYPRADETAILS.JOINTVENTURE == OIU_DO_DI.VNAME
  • I_ONRRRPTGHISTORYPRADETAILS.COMPANYCODE == OIU_DO_DI.BUKRS
  • I_ONRRRPTGHISTORYPRADETAILS.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
Energy Base Unit Of Measure
  • Energy Base Unit Of Measure
  • Client
  • I_ONRRRPTGHISTORYPRADETAILS.ENERGYUNIT == T006.MSEHI
  • I_ONRRRPTGHISTORYPRADETAILS.MANDT == T006.MANDT
G/L Account Number
  • Client
  • Company Code
  • G/L Account Number
  • I_ONRRRPTGHISTORYPRADETAILS.MANDT == SKB1.MANDT
  • I_ONRRRPTGHISTORYPRADETAILS.COMPANYCODE == SKB1.BUKRS
  • I_ONRRRPTGHISTORYPRADETAILS.GLACCOUNT == SKB1.SAKNR
ONRR-2014 - Index Zone
  • ONRR-2014 - Index Zone
  • Client
Joint venture
  • Client
  • Joint venture
  • Company Code
  • I_ONRRRPTGHISTORYPRADETAILS.MANDT == OIU_DO_JV.MANDT
  • I_ONRRRPTGHISTORYPRADETAILS.JOINTVENTURE == OIU_DO_JV.VNAME
  • I_ONRRRPTGHISTORYPRADETAILS.COMPANYCODE == OIU_DO_JV.BUKRS
ONRR-2014 - Agreement Number
  • Client
  • ONRR-2014 - Lease Number
ONRR-2014 - Lease Number
  • ?
  • Client
  • I_ONRRRPTGHISTORYPRADETAILS.[column in domain "/PRA/FP_LEASE_NO"] == /PRA/FP_LEASE.LEASE_NO
  • I_ONRRRPTGHISTORYPRADETAILS.MANDT == /PRA/FP_LEASE.MANDT
ONRR-2014 - Sales Type Code
  • Client
  • ONRR-2014 - Sales Type Code
Contract Number
  • Client
  • Contract Number
PRA owner
  • Client
  • PRA owner
  • I_ONRRRPTGHISTORYPRADETAILS.MANDT == LFA1.MANDT
  • I_ONRRRPTGHISTORYPRADETAILS.PRAOWNER == LFA1.LIFNR
Prior Period Adjustment Reason Code
  • Client
  • Prior Period Adjustment Reason Code
  • I_ONRRRPTGHISTORYPRADETAILS.MANDT == OIU_CM_PPARSN.MANDT
  • I_ONRRRPTGHISTORYPRADETAILS.PRIORPERIODADJUSTMENTREASON == OIU_CM_PPARSN.PPA_RSN_CD
Full three char. product code (Major and Detail Products) I_ONRRRPTGHISTORYPRADETAILS.PRODUCT == OIUX3_PDCD.PDCD
Volume Type Code I_ONRRRPTGHISTORYPRADETAILS.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD
Volume Base Unit of Measure
  • Client
  • Volume Base Unit of Measure
  • I_ONRRRPTGHISTORYPRADETAILS.MANDT == T006.MANDT
  • I_ONRRRPTGHISTORYPRADETAILS.VOLUMEUNIT == T006.MSEHI
Well ID number
  • Client
  • Well ID number
Well Completion Number
  • Client
  • Well ID number
  • Well Completion Number
  • I_ONRRRPTGHISTORYPRADETAILS.MANDT == OIU_PR_WC.MANDT
  • I_ONRRRPTGHISTORYPRADETAILS.WELL == OIU_PR_WC.WL_NO
  • I_ONRRRPTGHISTORYPRADETAILS.WELLCOMPLETION == OIU_PR_WC.WC_NO
Other Relations | to Master Data Relations ↑ Join Conditions
ONRR-2014 - Payor Code
  • Client
  • ONRR-2014 - Payor Code
ONRR-2014 - Distributee Code
  • ONRR-2014 - Distributee Code
  • Client