C_ONRRRptgHistPRADetQ

ONRR PRA Reporting Details Query | view: CPVONRRREPHISDQ | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: /PRA/FP_PRDT_HST
Column Name Description
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
ONRRLeaseName ONRR-2014 - Lease Name TEXT20
APIWellNumber ONRR-2014 - API Well Number
OverrideDocument ONRR-2014 - Override Payor Assigned Document Number
CreatedByUser Created By XUBNAME
CreationDateTime Created On Timestamp TZNTSTMPS
RoyaltyRate ONRR-2014 - Royalty Rate /PRA/FP_ROYALTY_RATE
AllocationPercent ONRR-2014 - Allocation Percent OIU_PERCENT98
OverrideRoyaltyRate ONRR-2014 - Override Royalty Rate OIU_PERCENT98
Master Data Relations | to Other Relations ↓ Join Conditions
Company Code
  • Company Code
  • Client
Cost Center
  • Cost Center
  • ?
  • ?
  • Client
  • C_ONRRRPTGHISTPRADETQ.COSTCENTER == CSKS.KOSTL
  • C_ONRRRPTGHISTPRADETQ.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_ONRRRPTGHISTPRADETQ.[column in domain "DATBI"] == CSKS.DATBI
  • C_ONRRRPTGHISTPRADETQ.MANDT == CSKS.MANDT
Currency Key
  • Currency Key
  • Client
  • C_ONRRRPTGHISTPRADETQ.CURRENCY == TCURC.WAERS
  • C_ONRRRPTGHISTPRADETQ.MANDT == TCURC.MANDT
Division of interest (DOI)
  • Company Code
  • Division of interest (DOI)
  • Client
  • Joint venture
  • C_ONRRRPTGHISTPRADETQ.COMPANYCODE == OIU_DO_DI.BUKRS
  • C_ONRRRPTGHISTPRADETQ.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
  • C_ONRRRPTGHISTPRADETQ.MANDT == OIU_DO_DI.MANDT
  • C_ONRRRPTGHISTPRADETQ.JOINTVENTURE == OIU_DO_DI.VNAME
Energy Base Unit Of Measure
  • Client
  • Energy Base Unit Of Measure
  • C_ONRRRPTGHISTPRADETQ.MANDT == T006.MANDT
  • C_ONRRRPTGHISTPRADETQ.ENERGYUNIT == T006.MSEHI
G/L Account Number
  • G/L Account Number
  • Company Code
  • Client
  • C_ONRRRPTGHISTPRADETQ.GLACCOUNT == SKB1.SAKNR
  • C_ONRRRPTGHISTPRADETQ.COMPANYCODE == SKB1.BUKRS
  • C_ONRRRPTGHISTPRADETQ.MANDT == SKB1.MANDT
ONRR-2014 - Index Zone
  • Client
  • ONRR-2014 - Index Zone
Joint venture
  • Company Code
  • Client
  • Joint venture
  • C_ONRRRPTGHISTPRADETQ.COMPANYCODE == OIU_DO_JV.BUKRS
  • C_ONRRRPTGHISTPRADETQ.MANDT == OIU_DO_JV.MANDT
  • C_ONRRRPTGHISTPRADETQ.JOINTVENTURE == OIU_DO_JV.VNAME
ONRR-2014 - Agreement Number
  • ONRR-2014 - Lease Number
  • Client
ONRR-2014 - Lease Number
  • ?
  • Client
  • C_ONRRRPTGHISTPRADETQ.[column in domain "/PRA/FP_LEASE_NO"] == /PRA/FP_LEASE.LEASE_NO
  • C_ONRRRPTGHISTPRADETQ.MANDT == /PRA/FP_LEASE.MANDT
ONRR-2014 - Sales Type Code
  • Client
  • ONRR-2014 - Sales Type Code
Contract Number
  • Contract Number
  • Client
PRA owner
  • Client
  • PRA owner
  • C_ONRRRPTGHISTPRADETQ.MANDT == LFA1.MANDT
  • C_ONRRRPTGHISTPRADETQ.PRAOWNER == LFA1.LIFNR
Prior Period Adjustment Reason Code
  • Client
  • Prior Period Adjustment Reason Code
Full three char. product code (Major and Detail Products) C_ONRRRPTGHISTPRADETQ.PRODUCT == OIUX3_PDCD.PDCD
Volume Type Code C_ONRRRPTGHISTPRADETQ.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD
Volume Base Unit of Measure
  • Client
  • Volume Base Unit of Measure
  • C_ONRRRPTGHISTPRADETQ.MANDT == T006.MANDT
  • C_ONRRRPTGHISTPRADETQ.VOLUMEUNIT == T006.MSEHI
Well ID number
  • Well ID number
  • Client
Well Completion Number
  • Well Completion Number
  • Well ID number
  • Client
  • C_ONRRRPTGHISTPRADETQ.WELLCOMPLETION == OIU_PR_WC.WC_NO
  • C_ONRRRPTGHISTPRADETQ.WELL == OIU_PR_WC.WL_NO
  • C_ONRRRPTGHISTPRADETQ.MANDT == OIU_PR_WC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
ONRR-2014 - Payor Code
  • ONRR-2014 - Payor Code
  • Client
ONRR-2014 - Distributee Code
  • Client
  • ONRR-2014 - Distributee Code