- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
C_ONRRRptgHistReportDetQ
ONRR Reporting History Report Detail Qry
| view: CPVONRRRHISTRDQ
| Extraction:
Not supported
| Component: Production and Revenue Accounting
Tables used:
/PRA/FP_RPDT_HST
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| 💲 Currency Key (Currency): | ||
| ReportedSalesValue | ONRR-2014 - Sales Value | |
| GrossRoyaltyAmount | ONRR-2014 - Royalty Value Prior To Allowance | |
| TranspAllwncDeductAmt | ONRR-2014 - Transportation Allowance Deduction | |
| ProcgAllwncDeductAmt | ONRR-2014 - Processing Allowance Deduction | |
| NetRoyaltyAmount | ONRR-2014 - Royalty Value Less Allowance | |
| TranspAllwncDeductAdjmtAmt | ONRR-2014 - Transportation Allowance Deduction Adjustment | |
| ProcgAllwncDeductAdjmtAmt | ONRR-2014 - Processing Allowance Deduction Adjustment | |
| RoyaltyDueAdjustmentAmount | ONRR-2014 - Royalty Due Adjustment | |
| Column Name | Description | |
|---|---|---|
| 📏 Volume Base Unit of Measure (VolumeUnit): | ||
| LeaseSalesVolumeInVolUnit | ONRR-2014 - Sales Volume | |
| 📏 Energy Base Unit Of Measure (EnergyUnit): | ||
| LeaseGasEnergyInEnergyUnit | ONRR-2014 - Gas Energy | |
| 📏 Heating Unit Of Measure (HeatingValUnit): | ||
| HeatingValue | Heating value | |
| Column Name | Description | |
|---|---|---|
| SalesDate | Sales Date / Month |
| Column Name | Description | |
|---|---|---|
| ONRRLessorType | ONRR-2014 - Lessor Code | Show values |
| ONRRReportedProduct | ONRR-2014 - Product Code | Show values |
| ONRRReportedTransType | ONRR-2014 - Transaction Code | Show values |
| ONRRPaymentMethod | ONRR-2014 - Payment Method Code | Show values |
| ONRRReportedRefTransType | ONRR-2014 - Reference Transaction Code | Show values |
| ONRRBusinessTransactionType | ONRR-2014 - Line Type | Show values |
| ONRRAdjmtReason | ONRR-2014 - Adjustment Code | Show values |
| TribalOrAllotteeLeaseType | ONRR-2014 - Tribal / Allottee Indicator | Show values |
| AgencyReportType | Proc 2.0 - Amended/Current Indicator | Show values |
| ONRRReportStatus | ONRR-2014 - Status | Show values |
| AgencyReportIsManual | ONRR-2014 - Manual 2014 Flag | Show values |
| IsRejectOverridden | ONRR-2014 - Override Reject Flag | Show values |
| ONRROverrideAdjmtReason | ONRR-2014 - Override Adjustment Code | Show values |
| SalesFigureIsToBeRecalculated | ONRR-2014: Recalculate Sales Vol/Val | Show values |
| FutureRptHasRoyaltyDueAdjmt | ONRR-2014: Persist Royalty Due Adjustment | Show values |
| IsManualReversal | ONRR-2014 - Manual Reversal Flag | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| APIWellNumber | ONRR-2014 - API Well Number | ||
| RoyaltyRate | ONRR-2014 - Royalty Rate | /PRA/FP_ROYALTY_RATE | |
| ProcessRun | Proc 2.0 - Run ID | ||
| PayerAssignedDocument | ONRR-2014 - Payor Assigned Document Number | ||
| PayerAssignedDocumentItem | ONRR-2014 - Line Number | ||
| SalesYearMonth | Fiscal Period | OIU_VDM_FIS_PERIOD | |
| IndianIndexZone | ONRR-2014 - Index Zone | /PRA/FP_INDEX_ZONE | |
| RefPayerAssignedDocument | ONRR- Ref Payor Assigned Document Number | ||
| RefPayerAssignedDocumentItem | ONRR-Ref Payor Assigned Document Line Number | ||
| ONRRLeaseName | ONRR-2014 - Lease Name | TEXT20 | |
| OverrideDocument | ONRR-2014 - Override Payor Assigned Document Number | ||
| CreatedByUser | Created By | XUBNAME | |
| CreationDateTime | Created On Timestamp | TZNTSTMPS | |
| AgencyReportedPrice | ONRR-2014 - Price | /PRA/FP_PRICE | |
| IndianIndexPrice | ONRR-2014 - Index Price | /PRA/FP_PRICE |
| Master Data Relations | to Other Relations ↓ | Join Conditions |
|---|---|
Company Code
|
|
Currency Key
| |
Energy Base Unit Of Measure
| |
Heating Unit Of Measure
| |
ONRR-2014 - Agreement Number
|
|
ONRR-2014 - Lease Number
|
|
ONRR-2014 - Sales Type Code
|
|
Volume Base Unit of Measure
|
| Other Relations | to Master Data Relations ↑ | Join Conditions |
|---|---|
ONRR-2014 - Payor Code
|
|
ONRR-2014 - Distributee Code
|
|