- Accounting - General (AC)
- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Business intelligence solutions (BI)
- Collaborative Cross Applications (XAP)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Customer Service (CS)
- Discrete Industries (DI)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise Performance Management (EPM)
- Enterprise Portal (EP)
- Enterprise Portal (EP)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Financials (FIN)
- Global Trade Services (SLL)
- Governance, Risk and Compliance (GRC)
- Incentive and Commission Management (ICM) (ICM)
- Investment Management (IM)
- Knowledge Management (KM)
- LOD Components (LOD)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Obsolete Product: mySAP.com Workplace (WP)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Personnel Time Management (PT)
- 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 HANA (HAN)
- SAP NetWeaver Master Data Management (MDM)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Training and Event Management (PE)
- Transportation Management (TM)
- Treasury (TR)
- Web Channel (WEC)
OIUREP_ROY_DATA
Reported Royalty and Volume Data by Reporting Entities
|
#transactional
|
Component: Royalty Reporting
| Column Name | Description | |
|---|---|---|
| MANDT FK | Client | |
| YEAR_MONTH | Reporting Year and Month | |
| ORG_LEVEL1_NO FK | Company Code | |
| AGENCY FK | Agency for Reporting | |
| OIL_GAS_IND | Oil and Gas Indicator | Show values |
| YEAR_MONTH_AMND | Year and Month for Amended Reports | |
| PROPERTY_NO FK | Joint venture | |
| DOI_NO FK | Division of interest (DOI) | |
| WL_NO FK | Well ID number | |
| WC_NO FK | Well Completion Number | |
| MP_NO FK | Measurement point number | |
| AGENCY_PROD_CODE FK | Agency defined product code | |
| AGENCY_VOL_TYPE FK | Agency defined Volume type | |
| GRAVITY_QTY | Gravity Quantity |
| Column Name | Description | |
|---|---|---|
| 💲 Currency (CURRENCY): | ||
| GROSS_VALUE | Gross Value From a Contract/Well | |
| NET_VALUE | Net Value From a Contract/Well | |
| TRANSPORT_COST | Transportation Cost | |
| TAX_AMT | Tax Amount | |
| MARKETING_TOT | Marketing Amount | |
| DEDUCTION_AMT1 | Deduction Amount | |
| DEDUCTION_AMT2 | Deduction Amount | |
| DEDUCTION_AMT3 | Deduction Amount | |
| DEDUCTION_AMT4 | Deduction Amount | |
| ROYALTY_DUE | Royalty Amount due to the State Agency | |
| Column Name | Description | |
|---|---|---|
| 📏 Standard volume unit (STD_VOL_U): | ||
| GROSS_VOLUME | Gross Volume | |
| NGL_VOLUME | NGL Volume | |
| NET_VOLUME | Net Volume | |
| 📏 Energy quantity unit (ENERGY_U): | ||
| ENERGY | energy | |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| OIL_GAS_IND | Oil and Gas Indicator | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| UNIT_PROPERTY_NO | Joint venture | JV_NAME | |
| TRACT_PF | Tract Participation Factor Decimal | OIU_PERCENT98 | |
| API_GRV | Oil/gas density at standard/base conditions | OIU_QCI_OIB_DICHT | |
| UPLOAD_FLAG | Single-Character Flag | CHAR1 | |
| OIU_CRUSER | Name of Person Responsible for Creating the Object | USNAM | |
| OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS |
| Master Data Relations | Join Conditions |
|---|---|
| Agency for Reporting | OIUREP_ROY_DATA.AGENCY == OIUREP_ROY_AGY.AGENCY |
Agency defined product code
|
|
Agency defined Volume type
|
|
Division of interest (DOI)
| |
| Client | OIUREP_ROY_DATA.MANDT == T000.MANDT |
| Measurement point number | |
| Company Code | |
Joint venture
| |
Well Completion Number
| |
| Well ID number |
|