OIUREP_ROY_DATA - Reported Royalty and Volume Data by Reporting Entities
Reported Royalty and Volume Data by Reporting Entities information is stored in SAP table OIUREP_ROY_DATA.
It is part of development package OIU_REP in software component IS-OIL-PRA-REP-ROY. This development package consists of objects that can be grouped under "Production, Tax & Royalty Reporting".
It is part of development package OIU_REP in software component IS-OIL-PRA-REP-ROY. This development package consists of objects that can be grouped under "Production, Tax & Royalty Reporting".
Fields for table OIUREP_ROY_DATA
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| YEAR_MONTH | Reporting Year and Month | X | OIUREP_RPT_YYYYMM | NUMC | 12 | |
| ORG_LEVEL1_NO | Company Code | X | BUKRS | CHAR | 8 | T001 |
| AGENCY | Agency for Reporting | X | OIUREP_ROY_AGENCY | CHAR | 6 | OIUREP_ROY_AGY |
| OIL_GAS_IND | Oil and Gas Indicator | X | OIUREP_OIL_GAS_IND | CHAR | 2 | |
| YEAR_MONTH_AMND | Year and Month for Amended Reports | X | OIUREP_AMND_YYYYMM | NUMC | 12 | |
| PROPERTY_NO | Joint venture | X | JV_NAME | CHAR | 12 | OIU_DO_JV |
| DOI_NO | Division of interest (DOI) | X | OIU_DOI_NO | CHAR | 10 | OIU_DO_DI |
| WL_NO | Well ID number | X | OIU_WL_NO | CHAR | 30 | OIU_PR_WELL |
| WC_NO | Well Completion Number | X | OIU_WC_NO | CHAR | 10 | OIU_PR_WC |
| MP_NO | Measurement point number | X | OIU_MP_NO | CHAR | 40 | OIU_PR_MP |
| AGENCY_PROD_CODE | Agency defined product code | X | OIUREP_AGENCY_PDCD | CHAR | 6 | OIUREP_AGY_PDCD |
| AGENCY_VOL_TYPE | Agency defined Volume type | X | OIUREP_AGENCY_VOL_TYPE | CHAR | 4 | OIUREP_AGY_VLTP |
| GRAVITY_QTY | Gravity Quantity | X | OIUREP_GRV_QY_NUMC4 | NUMC | 8 | |
| UNIT_PROPERTY_NO | Joint venture | JV_NAME | CHAR | 12 | ||
| GROSS_VOLUME | Gross Volume | OIUREP_GROSS_VOLUME | QUAN | 7 | ||
| NGL_VOLUME | NGL Volume | OIUY1_NGL_VOLUME | QUAN | 7 | ||
| NET_VOLUME | Net Volume | OIUREP_NET_VOLUME | QUAN | 7 | ||
| STD_VOL_U | Standard volume unit | OIU_STD_VOL_U | UNIT | 6 | ||
| GROSS_VALUE | Gross Value From a Contract/Well | OIUREP_GROSS_VALUE | CURR | 7 | ||
| NET_VALUE | Net Value From a Contract/Well | OIUREP_NET_VALUE | CURR | 7 | ||
| TRANSPORT_COST | Transportation Cost | OIUREP_TRANSPORT_COST | CURR | 7 | ||
| TAX_AMT | Tax Amount | OIUREP_TAX_AMOUNT | CURR | 6 | ||
| MARKETING_TOT | Marketing Amount | OIUREP_MKT_AMOUNT | CURR | 6 | ||
| DEDUCTION_AMT1 | Deduction Amount | OIUREP_DED_AMOUNT | CURR | 6 | ||
| DEDUCTION_AMT2 | Deduction Amount | OIUREP_DED_AMOUNT | CURR | 6 | ||
| DEDUCTION_AMT3 | Deduction Amount | OIUREP_DED_AMOUNT | CURR | 6 | ||
| DEDUCTION_AMT4 | Deduction Amount | OIUREP_DED_AMOUNT | CURR | 6 | ||
| ROYALTY_DUE | Royalty Amount due to the State Agency | OIUREP_ROYALTY_DUE | CURR | 7 | ||
| CURRENCY | Currency | OIUREP_CURRENCY | CUKY | 10 | ||
| ENERGY | energy | OIUREP_ENERGY | QUAN | 11 | ||
| ENERGY_U | Energy quantity unit | OIU_ENERGY_U | UNIT | 6 | ||
| TRACT_PF | Tract Participation Factor Decimal | OIU_TR_PART_FACT_PC | DEC | 5 | ||
| API_GRV | Oil/gas density at standard/base conditions | OIU_OIB_BDICH | FLTP | 8 | ||
| UPLOAD_FLAG | Single-Character Flag | CHAR1 | CHAR | 2 | ||
| .INCLUDE | OIU_CREATION | 0 | ||||
| OIU_CRUSER | Name of Person Responsible for Creating the Object | ERNAM | CHAR | 24 | ||
| OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC | 8 |