Table/Structure Field list used by SAP ABAP Function Module OIUREP_GET_LSEROY_DETAIL (Royalty Reporting Main Processing)
SAP ABAP Function Module 
OIUREP_GET_LSEROY_DETAIL (Royalty Reporting Main Processing) is using
Message Number (1)| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Table/Structure Field |
OIUREP_AGY_PDCD - AGENCY_PROD_CODE | Agency defined product code | |
| 2 | Table/Structure Field |
OIUREP_AGY_PDCD - CA_MAJPD_CD | Major product code | |
| 3 | Table/Structure Field |
OIUREP_AGY_PDCD - AGENCY | Agency for Reporting | |
| 4 | Table/Structure Field |
OIUREP_ENTTY_LOG - RPT_YYYYMM | Reporting Year and Month | |
| 5 | Table/Structure Field |
OIUREP_ENTTY_LOG - ORG_LEVEL1_NO | Company Code | |
| 6 | Table/Structure Field |
OIUREP_ENTTY_LOG - OIL_GAS_IND | Oil and Gas Indicator | |
| 7 | Table/Structure Field |
OIUREP_ENTTY_LOG - DB_ACTION | Type of change (Insert, Delete or Update) | |
| 8 | Table/Structure Field |
OIUREP_ENTTY_LOG - AGENCY_LEASE | Agency assigned Lease No. | |
| 9 | Table/Structure Field |
OIUREP_ENTTY_LOG - AGENCY | Agency for Reporting | |
| 10 | Table/Structure Field |
OIUREP_ROY_DATA - MP_NO | Measurement point number | |
| 11 | Table/Structure Field |
OIUREP_ROY_DATA - NET_VOLUME | Net Volume | |
| 12 | Table/Structure Field |
OIUREP_ROY_DATA - NET_VALUE | Net Value From a Contract/Well | |
| 13 | Table/Structure Field |
OIUREP_ROY_DATA - NGL_VOLUME | NGL Volume | |
| 14 | Table/Structure Field |
OIUREP_ROY_DATA - OIL_GAS_IND | Oil and Gas Indicator | |
| 15 | Table/Structure Field |
OIUREP_ROY_DATA - ORG_LEVEL1_NO | Company Code | |
| 16 | Table/Structure Field |
OIUREP_ROY_DATA - PROPERTY_NO | Joint venture | |
| 17 | Table/Structure Field |
OIUREP_ROY_DATA - ROYALTY_DUE | Royalty Amount due to the State Agency | |
| 18 | Table/Structure Field |
OIUREP_ROY_DATA - STD_VOL_U | Standard volume unit | |
| 19 | Table/Structure Field |
OIUREP_ROY_DATA - TAX_AMT | Tax Amount | |
| 20 | Table/Structure Field |
OIUREP_ROY_DATA - TRANSPORT_COST | Transportation Cost | |
| 21 | Table/Structure Field |
OIUREP_ROY_DATA - WC_NO | Well Completion Number | |
| 22 | Table/Structure Field |
OIUREP_ROY_DATA - WL_NO | Well ID number | |
| 23 | Table/Structure Field |
OIUREP_ROY_DATA - YEAR_MONTH | Reporting Year and Month | |
| 24 | Table/Structure Field |
OIUREP_ROY_DATA - YEAR_MONTH_AMND | Year and Month for Amended Reports | |
| 25 | Table/Structure Field |
OIUREP_ROY_DATA - GROSS_VOLUME | Gross Volume | |
| 26 | Table/Structure Field |
OIUREP_ROY_DATA - AGENCY | Agency for Reporting | |
| 27 | Table/Structure Field |
OIUREP_ROY_DATA - AGENCY_PROD_CODE | Agency defined product code | |
| 28 | Table/Structure Field |
OIUREP_ROY_DATA - AGENCY_VOL_TYPE | Agency defined Volume type | |
| 29 | Table/Structure Field |
OIUREP_ROY_DATA - API_GRV | Oil/gas density at standard/base conditions | |
| 30 | Table/Structure Field |
OIUREP_ROY_DATA - DEDUCTION_AMT1 | Deduction Amount | |
| 31 | Table/Structure Field |
OIUREP_ROY_DATA - DEDUCTION_AMT2 | Deduction Amount | |
| 32 | Table/Structure Field |
OIUREP_ROY_DATA - DEDUCTION_AMT3 | Deduction Amount | |
| 33 | Table/Structure Field |
OIUREP_ROY_DATA - DOI_NO | Division of interest (DOI) | |
| 34 | Table/Structure Field |
OIUREP_ROY_DATA - ENERGY | energy | |
| 35 | Table/Structure Field |
OIUREP_ROY_DATA - ENERGY_U | Energy quantity unit | |
| 36 | Table/Structure Field |
OIUREP_ROY_DATA - GRAVITY_QTY | Gravity Quantity | |
| 37 | Table/Structure Field |
OIUREP_ROY_DATA - GROSS_VALUE | Gross Value From a Contract/Well | |
| 38 | Table/Structure Field |
OIUREP_ROY_DATA - MARKETING_TOT | Marketing Amount | |
| 39 | Table/Structure Field |
OIUREP_ROY_DATA - DEDUCTION_AMT4 | Deduction Amount | |
| 40 | Table/Structure Field |
OIUREP_RPT_ENTTY - ORG_LEVEL1_NO | Company Code | |
| 41 | Table/Structure Field |
OIUREP_RPT_ENTTY - WL_NO | Well ID number | |
| 42 | Table/Structure Field |
OIUREP_RPT_ENTTY - WC_NO | Well Completion Number | |
| 43 | Table/Structure Field |
OIUREP_RPT_ENTTY - ROY_OBLIGATION | Royalty Obligation (Y/N) | |
| 44 | Table/Structure Field |
OIUREP_RPT_ENTTY - PROPERTY_NO | Joint venture | |
| 45 | Table/Structure Field |
OIUREP_RPT_ENTTY - PAYOR_FRACTION | Report factor for royalty reporting | |
| 46 | Table/Structure Field |
OIUREP_RPT_ENTTY - LSE_ALLOC_FAC | Lease Allocation Factor | |
| 47 | Table/Structure Field |
OIUREP_RPT_ENTTY - ENTL_FLAG | Entitlement Flag | |
| 48 | Table/Structure Field |
OIUREP_RPT_ENTTY - DOI_NO | Division of interest (DOI) | |
| 49 | Table/Structure Field |
OIU_SB_DOIWC - WL_NO | Well ID number | |
| 50 | Table/Structure Field |
OIU_SB_DOIWC - DFLT_CD | Default DOI xRef Type | |
| 51 | Table/Structure Field |
OIU_SB_DOIWC - WC_NO | Well Completion Number | |
| 52 | Table/Structure Field |
OIU_SB_DOIWC - VNAME | Joint venture | |
| 53 | Table/Structure Field |
OIU_SB_DOIWC - MAJPD_CD | Major product code 1,2,4 | |
| 54 | Table/Structure Field |
OIU_SB_DOIWC - EFF_FROM_DT | Effective from date | |
| 55 | Table/Structure Field |
OIU_SB_DOIWC - EFF_TO_DT | Effective To Date | |
| 56 | Table/Structure Field |
OIU_SB_DOIWC - BUKRS | Company Code | |
| 57 | Table/Structure Field |
OIU_SB_DOIWC - DOI_NO | Division of interest (DOI) | |
| 58 | Table/Structure Field |
ROIUREP_EXEC_PARAM - AGENCY | Agency for Reporting | |
| 59 | Table/Structure Field |
ROIUREP_EXEC_PARAM - OIL_GAS_IND | Oil and Gas Indicator | |
| 60 | Table/Structure Field |
ROIUREP_EXEC_PARAM - ORG_LEVEL1_NO | Company Code | |
| 61 | Table/Structure Field |
ROIUREP_EXEC_PARAM - YEAR_MONTH | Reporting Year and Month | |
| 62 | Table/Structure Field |
ROIUREP_RE_KEY - AGENCY_LEASE | Agency assigned Lease No. | |
| 63 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - MARKETING_TOT | Marketing Amount | |
| 64 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - YEAR_MONTH_AMND | Year and Month for Amended Reports | |
| 65 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - MP_NO | Measurement point number | |
| 66 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - NET_VALUE | Net Value From a Contract/Well | |
| 67 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - NET_VOLUME | Net Volume | |
| 68 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - NGL_VOLUME | NGL Volume | |
| 69 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - OIL_GAS_IND | Oil and Gas Indicator | |
| 70 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - ORG_LEVEL1_NO | Company Code | |
| 71 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - PAYOR_FRACTION | Payor's fraction of Royalty payment | |
| 72 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - PROPERTY_NO | Joint venture | |
| 73 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - ROYALTY_DUE | Royalty Amount due to the State Agency | |
| 74 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - ROY_OBLIGATION | Royalty Obligation (Y/N) | |
| 75 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - STD_VOL_U | Standard volume unit | |
| 76 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - TAX_AMT | Tax Amount | |
| 77 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - TRANSPORT_COST | Transportation Cost | |
| 78 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - WC_NO | Well Completion Number | |
| 79 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - WL_NO | Well ID number | |
| 80 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - YEAR_MONTH | Reporting Year and Month | |
| 81 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - DEDUCTION_AMT4 | Deduction Amount | |
| 82 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - AGENCY | Agency for Reporting | |
| 83 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - AGENCY_LEASE | Agency assigned Lease No. | |
| 84 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - AGENCY_PROD_CODE | Agency defined product code | |
| 85 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - AGENCY_VOL_TYPE | Agency defined Volume type | |
| 86 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - API_GRV | Oil/gas density at standard/base conditions | |
| 87 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - DEDUCTION_AMT1 | Deduction Amount | |
| 88 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - DEDUCTION_AMT2 | Deduction Amount | |
| 89 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - DEDUCTION_AMT3 | Deduction Amount | |
| 90 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - LSE_ALLOC_FAC | Lease Allocation Factor | |
| 91 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - DOI_NO | Division of interest (DOI) | |
| 92 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - ENERGY | energy | |
| 93 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - ENERGY_U | Energy quantity unit | |
| 94 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - ENTL_FLAG | Entitlement Flag | |
| 95 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - GRAVITY_QTY | Gravity Quantity | |
| 96 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - GROSS_VALUE | Gross Value From a Contract/Well | |
| 97 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - GROSS_VOLUME | Gross Volume | |
| 98 | Table/Structure Field |
ROIUREP_ROY_LEASE_LASTCURR - LAST_CURR_IND | Last/Current indicator |
