- 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_PRARoyaltyRptgHistTXGLOQry
PRA Royalty Reporting History Texas GLO Query
| view: CPVROYRPTGHTXG
| Extraction:
Not supported
| Component: Production and Revenue Accounting
Column Name | Description | |
---|---|---|
CompanyCode FK | Company Code | |
SalesDate | Sales Date / Month | |
Product FK | Full three char. product code (Major and Detail Products) | |
Well FK | Well ID number | |
WellCompletion FK | Well Completion Number | |
MeasurementPoint FK | Measurement point number | |
JointVenture FK | Joint venture | |
DivisionOfInterest FK | Division of interest (DOI) | |
DeliveryNetwork FK | Delivery network number | |
PRAContract FK | Contract Number | |
VolumeType FK | Volume type code | |
UniqueOwnerReference | Royalty 2.0 - Owner Identifier | |
TaxRptgRvslOrBkgOrAdjmt | Royalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjs | Show values |
Column Name | Description | |
---|---|---|
💲 Currency Key (CompanyCodeCurrency): | ||
GrossValInCoCodeCrcy | Gross Value | |
OwnerGrossValInCoCodeCrcy | Royalty 2.0 - TX GLO - Owner Gross Value | |
DdctnOrReimbmtAmtInCoCdCrcy | Deduction/Reimbursement Amount | |
TranspMktgCostInCoCodeCrcy | Marketing Cost | |
OtherMktgCostInCoCodeCrcy | Marketing Cost | |
TaxReimbmtAmtInCoCodeCrcy | Tax Reimbursement Amount |
Column Name | Description |
---|
Column Name | Description | |
---|---|---|
SalesDate | Sales Date / Month |
Column Name | Description | |
---|---|---|
TaxRptgRvslOrBkgOrAdjmt | Royalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjs | Show values |
IsAffiliatedSale | Royalty 2.0 - TX GLO - Affiliated Sale Indicator | Show values |
AgencyReportType | Royalty 2.0 - TX GLOTAMU - Original Report | Show values |
AgencyGasDispositionType | Royalty 2.0 - TX GLO/TAMU - Royalty Gas Disposition Code | Show values |
JointVentureIsUnit | Roy 2.0 - Texas GLO/TAMU - Unit Venture | Show values |
AgencyPayOrReportType | Royalty 2.0 - TX GLO/TAMU - Pay/Report Flag | Show values |
Column Name | Description | Domain name | |
---|---|---|---|
GLAccount | Account ID | CHAR10 | |
CostCenter | Template Cost Center | KOSTL | |
OwnerPaymentStatus | Pay Code | CHAR2 | |
Purchaser | Purchaser Number | KUNNR | |
MasterDataRecordingLvl | Royalty 2.0 - TX GLO - Master Level | ||
RailRoadCommsnMstrDataRecgLvl | Royalty 2.0 - TX GLO - RRC Master Level | ||
PurchaserIDByAgency | Royalty 2.0 - Texas GLO/TAMU - Purchaser ID | ||
OperatorIDByAgency | Royalty 2.0 - TX GLO - Operator ID | OIUY3_TX_ID | |
TexasRailRoadCommsnDistrict | Royalty 2.0 - TX GLO/TAMU - District Number | ||
TexasRailRoadCommsnOilLease | Royalty 2.0 - TX GLO/TAMU - RRC Oil Lease Number | ||
TexasRailRoadCommsnGasWell | Royalty 2.0 - TX GLO/TAMU - RRC Gas Well ID | ||
TexasRailRoadCommsnDrillPermit | Royalty 2.0 - TX GLO/TAMU - RRC Drilling Permit | ||
TexasRailRoadCommsnFieldName | Royalty 2.0 - TX GLO/TAMU - RRC Field Name | ||
TexasRailRoadCommsnLeaseName | Royalty 2.0 - TX GLO/TAMU - RRC Lease Name | ||
PropertyAliasName | Royalty 2.0 - TX GLO/TAMU - Property Alias Name | ||
ValuationDocumentNumber | Val. document number | OIU_MP_NO | |
ValuationDocumentYear | Document year | GJAHR | |
CreatedByUser | Created By | XUBNAME | |
CreationDateTime | Created On Timestamp | TZNTSTMPS | |
AgencyNetRevenueInterestRatio | Royalty 2.0 - Texas GLO - Royalty Decimal | OIU_PERCENT98 | |
AllocationPercent | Royalty 2.0 - TX GLO/TAMU - Allocation Percent | OIU_PERCENT98 | |
TractParticipationFactor | Royalty 2.0 - Texas GLO - Tract Participation Factor | OIU_PERCENT98 | |
PressureBaseQty | Pressure Base Quantity | OIUH_DEC6_3 | |
APIGravityRatio | Gravity | OIUH_DEC3_1 | |
NetRevenueInterestRatio | Royalty 2.0 - TX GLO - Owner NRI | OIU_PERCENT98 | |
DisbursementDecimalRatio | Owner Disbursement (Balance) Decimal | OIUH_DEC9_8 | |
GrossVolInBaseUnit | Gross Volume | OIUX3_SIGNED_DEC_11_2 | |
JournalEntryTransacAmtVal | JE Transaction Amount | OIUX3_SIGNED_DEC_11_2 | |
JournalEntryTransacQtyVal | JE Transaction Quantity | OIUH_DEC11_2 | |
OwnerEnergyInMMBTU | Owner MMBTU | OIUH_DEC11_2 | |
GrossVolReducnInMCF | Gross Plant Volume Reduction amount | OIUH_DEC11_2 | |
OwnerVolReducnInMCF | Owner Plant Volume Reduction amount | OIUH_DEC11_2 | |
HeatingValue | BTU Quantity | OIUH_DEC7_3 |
Master Data Relations | Join Conditions |
---|---|
Company Code
|
|
Currency Key
| |
Delivery network number
| |
Division of interest (DOI)
| |
Joint venture
| |
Measurement point number
| |
Full three char. product code (Major and Detail Products) | C_PRAROYALTYRPTGHISTTXGLOQRY.PRODUCT == OIUX3_PDCD.PDCD |
Royalty 2.0 - TX GLO/TAMU Lease
|
|
Joint venture
| |
Royalty 2.0 - Texas GLO/TAMU - Unit Number
|
|
Volume type code | C_PRAROYALTYRPTGHISTTXGLOQRY.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD |
Well ID number
|
|
Well Completion Number
|