Table/Structure Field list used by SAP ABAP Function Module OIUREP_ROY_EXTRACT_BY_SYSNO (Extract for Royalty Data by sysnos)
SAP ABAP Function Module 
OIUREP_ROY_EXTRACT_BY_SYSNO (Extract for Royalty Data by sysnos) is using
Message Number (3)| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Table/Structure Field |
OIUH_RV_GL - GL_GL_SYS_NO | OIUH_DEC18 | |
| 2 | Table/Structure Field |
OIUH_RV_GTAX - GTAX_GL_SYS_NO | OIUH_DEC18 | |
| 3 | Table/Structure Field |
OIUH_RV_GTAX - GTAX_TAX_AM | Local amount | |
| 4 | Table/Structure Field |
OIUH_RV_GTAX - GTAX_TAX_POS_NO | OIUH_DEC5 | |
| 5 | Table/Structure Field |
OIUH_RV_ODED - DED_DED_TYPE_CD | Other Deduction Type Codes | |
| 6 | Table/Structure Field |
OIUH_RV_ODED - D_DED_CK_DED_AM | Local amount | |
| 7 | Table/Structure Field |
OIUH_RV_ODED - ODED_GL_SYS_NO | OIUH_DEC18 | |
| 8 | Table/Structure Field |
OIUH_RV_OPSL - OPSL_GL_SYS_NO | OIUH_DEC18 | |
| 9 | Table/Structure Field |
OIUH_RV_OTAX - OTAX_GL_SYS_NO | OIUH_DEC18 | |
| 10 | Table/Structure Field |
OIUH_RV_OTAX - OTAX_TAX_AM | Local amount | |
| 11 | Table/Structure Field |
OIUH_RV_OTAX - OTAX_TAX_POS_NO | OIUH_DEC5 | |
| 12 | Table/Structure Field |
OIUREP_EXEC_STAT - AGENCY | Agency for Reporting | |
| 13 | Table/Structure Field |
OIUREP_EXEC_STAT - OIL_GAS_IND | Oil and Gas Indicator | |
| 14 | Table/Structure Field |
OIUREP_EXEC_STAT - ORG_LEVEL1_NO | Company Code | |
| 15 | Table/Structure Field |
OIUREP_EXEC_STAT - RUN_MODE | Mode of report execution | |
| 16 | Table/Structure Field |
OIUREP_EXEC_STAT - TRIAL_FINAL_IND | Run type indicator | |
| 17 | Table/Structure Field |
OIUREP_EXEC_STAT - YEAR_MONTH | Reporting Year and Month | |
| 18 | Table/Structure Field |
OIUREP_PDCD_XREF - AGENCY | Agency for Reporting | |
| 19 | Table/Structure Field |
OIUREP_PDCD_XREF - AGENCY_PROD_CODE | Agency defined product code | |
| 20 | Table/Structure Field |
OIUREP_PDCD_XREF - OIL_GAS_IND | Oil and Gas Indicator | |
| 21 | Table/Structure Field |
OIUREP_PDCD_XREF - PRODUCT_CODE | Material Number | |
| 22 | Table/Structure Field |
OIUREP_RPT_ENTTY - AGENCY_LEASE | Agency assigned Lease No. | |
| 23 | Table/Structure Field |
OIUREP_RPT_ENTTY - PAYOR_FRACTION | Report factor for royalty reporting | |
| 24 | Table/Structure Field |
OIUREP_VLTP_XREF - AGENCY | Agency for Reporting | |
| 25 | Table/Structure Field |
OIUREP_VLTP_XREF - OIL_GAS_IND | Oil and Gas Indicator | |
| 26 | Table/Structure Field |
OIUREP_VLTP_XREF - VOL_TYPE | Volume type code | |
| 27 | Table/Structure Field |
OIUREP_XTRCT_ROY - GL_DOI_NO | Division of interest (DOI) | |
| 28 | Table/Structure Field |
OIUREP_XTRCT_ROY - GL_GR_AM | GL Gross Amount | |
| 29 | Table/Structure Field |
OIUREP_XTRCT_ROY - GL_GR_QY | GL Gross Quantity | |
| 30 | Table/Structure Field |
OIUREP_XTRCT_ROY - GL_OR_LVL_1_NO | Company Code | |
| 31 | Table/Structure Field |
OIUREP_XTRCT_ROY - GL_PD_CD | Material Number | |
| 32 | Table/Structure Field |
OIUREP_XTRCT_ROY - GL_PR_NO | Joint venture | |
| 33 | Table/Structure Field |
OIUREP_XTRCT_ROY - GL_SA_DT | GL Sales Date | |
| 34 | Table/Structure Field |
OIUREP_XTRCT_ROY - GL_SA_MP_NO | Measurement point number | |
| 35 | Table/Structure Field |
OIUREP_XTRCT_ROY - GL_TRANS_AM | GL Transaction Amount | |
| 36 | Table/Structure Field |
OIUREP_XTRCT_ROY - GL_TRANS_QY | GL Transaction Quantity | |
| 37 | Table/Structure Field |
OIUREP_XTRCT_ROY - GL_WC_NO | Well Completion Number | |
| 38 | Table/Structure Field |
OIUREP_XTRCT_ROY - GL_WL_NO | Well ID number | |
| 39 | Table/Structure Field |
OIUREP_XTRCT_ROY - GTAX_TAX_AM1 | Tax Amount | |
| 40 | Table/Structure Field |
OIUREP_XTRCT_ROY - GTAX_TAX_AM10 | Tax Amount | |
| 41 | Table/Structure Field |
OIUREP_XTRCT_ROY - GTAX_TAX_AM2 | Tax Amount | |
| 42 | Table/Structure Field |
OIUREP_XTRCT_ROY - GTAX_TAX_AM3 | Tax Amount | |
| 43 | Table/Structure Field |
OIUREP_XTRCT_ROY - GTAX_TAX_AM4 | Tax Amount | |
| 44 | Table/Structure Field |
OIUREP_XTRCT_ROY - GTAX_TAX_AM5 | Tax Amount | |
| 45 | Table/Structure Field |
OIUREP_XTRCT_ROY - GTAX_TAX_AM6 | Tax Amount | |
| 46 | Table/Structure Field |
OIUREP_XTRCT_ROY - GTAX_TAX_AM7 | Tax Amount | |
| 47 | Table/Structure Field |
OIUREP_XTRCT_ROY - GTAX_TAX_AM8 | Tax Amount | |
| 48 | Table/Structure Field |
OIUREP_XTRCT_ROY - GTAX_TAX_AM9 | Tax Amount | |
| 49 | Table/Structure Field |
OIUREP_XTRCT_ROY - L_DED_GR_RMB_AM | Local amount | |
| 50 | Table/Structure Field |
OIUREP_XTRCT_ROY - L_NET_OTH_MK_AM | Local amount | |
| 51 | Table/Structure Field |
OIUREP_XTRCT_ROY - L_NET_TRANSP_AM | Local amount | |
| 52 | Table/Structure Field |
OIUREP_XTRCT_ROY - L_TAX_GR_RMB_AM | Local amount | |
| 53 | Table/Structure Field |
OIUREP_XTRCT_ROY - MMBTU_OWN_VL_AM | OIUH_DEC11_2 | |
| 54 | Table/Structure Field |
OIUREP_XTRCT_ROY - ODED_DED_AM1 | Deduction Amount | |
| 55 | Table/Structure Field |
OIUREP_XTRCT_ROY - ODED_DED_AM10 | Deduction Amount | |
| 56 | Table/Structure Field |
OIUREP_XTRCT_ROY - ODED_DED_AM11 | Deduction Amount | |
| 57 | Table/Structure Field |
OIUREP_XTRCT_ROY - ODED_DED_AM12 | Deduction Amount | |
| 58 | Table/Structure Field |
OIUREP_XTRCT_ROY - ODED_DED_AM13 | Deduction Amount | |
| 59 | Table/Structure Field |
OIUREP_XTRCT_ROY - ODED_DED_AM14 | Deduction Amount | |
| 60 | Table/Structure Field |
OIUREP_XTRCT_ROY - ODED_DED_AM15 | Deduction Amount | |
| 61 | Table/Structure Field |
OIUREP_XTRCT_ROY - ODED_DED_AM16 | Deduction Amount | |
| 62 | Table/Structure Field |
OIUREP_XTRCT_ROY - ODED_DED_AM17 | Deduction Amount | |
| 63 | Table/Structure Field |
OIUREP_XTRCT_ROY - ODED_DED_AM18 | Deduction Amount | |
| 64 | Table/Structure Field |
OIUREP_XTRCT_ROY - ODED_DED_AM2 | Deduction Amount | |
| 65 | Table/Structure Field |
OIUREP_XTRCT_ROY - ODED_DED_AM3 | Deduction Amount | |
| 66 | Table/Structure Field |
OIUREP_XTRCT_ROY - ODED_DED_AM4 | Deduction Amount | |
| 67 | Table/Structure Field |
OIUREP_XTRCT_ROY - ODED_DED_AM5 | Deduction Amount | |
| 68 | Table/Structure Field |
OIUREP_XTRCT_ROY - ODED_DED_AM6 | Deduction Amount | |
| 69 | Table/Structure Field |
OIUREP_XTRCT_ROY - ODED_DED_AM7 | Deduction Amount | |
| 70 | Table/Structure Field |
OIUREP_XTRCT_ROY - ODED_DED_AM8 | Deduction Amount | |
| 71 | Table/Structure Field |
OIUREP_XTRCT_ROY - ODED_DED_AM9 | Deduction Amount | |
| 72 | Table/Structure Field |
OIUREP_XTRCT_ROY - OPSL_DED_RMB_AM | Local amount | |
| 73 | Table/Structure Field |
OIUREP_XTRCT_ROY - OPSL_GRV_QY | Gravity Quantity | |
| 74 | Table/Structure Field |
OIUREP_XTRCT_ROY - OPSL_GR_PVR_AM | OIUH_DEC11_2 | |
| 75 | Table/Structure Field |
OIUREP_XTRCT_ROY - OPSL_ORIG_MP_NO | Measurement point number | |
| 76 | Table/Structure Field |
OIUREP_XTRCT_ROY - OPSL_OWN_NO | Master Record | |
| 77 | Table/Structure Field |
OIUREP_XTRCT_ROY - OPSL_OWN_PVR_AM | OIUH_DEC11_2 | |
| 78 | Table/Structure Field |
OIUREP_XTRCT_ROY - OPSL_TAX_RMB_AM | Local amount | |
| 79 | Table/Structure Field |
OIUREP_XTRCT_ROY - OPSL_TXN_VAL_AM | Local amount | |
| 80 | Table/Structure Field |
OIUREP_XTRCT_ROY - OPSL_UNIT_PR_NO | Joint venture | |
| 81 | Table/Structure Field |
OIUREP_XTRCT_ROY - OTAX_TAX_AM1 | Tax Amount | |
| 82 | Table/Structure Field |
OIUREP_XTRCT_ROY - OTAX_TAX_AM10 | Tax Amount | |
| 83 | Table/Structure Field |
OIUREP_XTRCT_ROY - OTAX_TAX_AM2 | Tax Amount | |
| 84 | Table/Structure Field |
OIUREP_XTRCT_ROY - OTAX_TAX_AM3 | Tax Amount | |
| 85 | Table/Structure Field |
OIUREP_XTRCT_ROY - OTAX_TAX_AM4 | Tax Amount | |
| 86 | Table/Structure Field |
OIUREP_XTRCT_ROY - OTAX_TAX_AM5 | Tax Amount | |
| 87 | Table/Structure Field |
OIUREP_XTRCT_ROY - OTAX_TAX_AM6 | Tax Amount | |
| 88 | Table/Structure Field |
OIUREP_XTRCT_ROY - OTAX_TAX_AM7 | Tax Amount | |
| 89 | Table/Structure Field |
OIUREP_XTRCT_ROY - OTAX_TAX_AM8 | Tax Amount | |
| 90 | Table/Structure Field |
OIUREP_XTRCT_ROY - OTAX_TAX_AM9 | Tax Amount | |
| 91 | Table/Structure Field |
OIUREP_ZERO_REJS - AGENCY | Agency for Reporting | |
| 92 | Table/Structure Field |
OIUREP_ZERO_REJS - BTCH_TYPE_CODE | Batch Type Code | |
| 93 | Table/Structure Field |
OIUREP_ZERO_REJS - SYS_SRC_CODE | System source code | |
| 94 | Table/Structure Field |
ROIUREP_EPMP_RZMP - EP_MP_NO | Measurement point number | |
| 95 | Table/Structure Field |
ROIUREP_EPMP_RZMP - RZ_MP_NO | Measurement Point No. | |
| 96 | Table/Structure Field |
ROIUREP_EPWLWC_RZWLWC - EP_WC_NO | Well Completion Number | |
| 97 | Table/Structure Field |
ROIUREP_EPWLWC_RZWLWC - EP_WL_NO | Well ID number | |
| 98 | Table/Structure Field |
ROIUREP_EPWLWC_RZWLWC - RZ_WC_NO | Well Completion No. | |
| 99 | Table/Structure Field |
ROIUREP_EPWLWC_RZWLWC - RZ_WL_NO | Well No. | |
| 100 | Table/Structure Field |
ROIUREP_EXEC_PARAM - AGENCY | Agency for Reporting | |
| 101 | Table/Structure Field |
ROIUREP_EXEC_PARAM - OIL_GAS_IND | Oil and Gas Indicator | |
| 102 | Table/Structure Field |
ROIUREP_EXEC_PARAM - ORG_LEVEL1_NO | Company Code | |
| 103 | Table/Structure Field |
ROIUREP_EXEC_PARAM - YEAR_MONTH | Reporting Year and Month | |
| 104 | Table/Structure Field |
ROIUREP_MATNR_PDCD - MATNR | Material Number | |
| 105 | Table/Structure Field |
ROIUREP_MATNR_PDCD - PRODUCT_CODE | Product Code | |
| 106 | Table/Structure Field |
ROIUREP_OPSL_KEY - OPSL_GL_SYS_NO | OIUH_DEC18 | |
| 107 | Table/Structure Field |
ROIUREP_OWNER_BA - BA_NO | Business Associate | |
| 108 | Table/Structure Field |
ROIUREP_OWNER_BA - BA_SEQ | Sequence Number | |
| 109 | Table/Structure Field |
ROIUREP_OWNER_BA - OWNER_NO | Master Record | |
| 110 | Table/Structure Field |
ROIUREP_REJECT_DETAIL - AGENCY_LEASE | Agency assigned Lease No. | |
| 111 | Table/Structure Field |
ROIUREP_REJECT_DETAIL - AGENCY_PROD_CD | Agency defined product code | |
| 112 | Table/Structure Field |
ROIUREP_REJECT_DETAIL - AMENNDED_FLAG | Indicator (Current or Amended) Report | |
| 113 | Table/Structure Field |
ROIUREP_REJECT_DETAIL - GROSS_SALES_VAL | Generic Value for Oil/Gas | |
| 114 | Table/Structure Field |
ROIUREP_REJECT_DETAIL - GROSS_SALES_VOL | Generic Value for Oil/Gas | |
| 115 | Table/Structure Field |
ROIUREP_REJECT_DETAIL - NET_SALES_VAL | Generic Value for Oil/Gas | |
| 116 | Table/Structure Field |
ROIUREP_REJECT_DETAIL - PROCESSING_DED | Generic Value for Oil/Gas | |
| 117 | Table/Structure Field |
ROIUREP_REJECT_DETAIL - PROPERTY_ID | Char 20 | |
| 118 | Table/Structure Field |
ROIUREP_REJECT_DETAIL - REJECT_CD | 3-Byte field | |
| 119 | Table/Structure Field |
ROIUREP_REJECT_DETAIL - REJECT_REASON | Comment | |
| 120 | Table/Structure Field |
ROIUREP_REJECT_DETAIL - ROYALTY_DUE | Generic Value for Oil/Gas | |
| 121 | Table/Structure Field |
ROIUREP_REJECT_DETAIL - SALES_YYYYMM | Year and Month for Amended Reports | |
| 122 | Table/Structure Field |
ROIUREP_REJECT_DETAIL - TRACT_ALLOC | Report factor for royalty reporting | |
| 123 | Table/Structure Field |
ROIUREP_REJECT_DETAIL - TRANSPORT_DED | Generic Value for Oil/Gas | |
| 124 | Table/Structure Field |
ROIUREP_RE_KEY - DOI_NO | Division of interest (DOI) | |
| 125 | Table/Structure Field |
ROIUREP_RE_KEY - PROPERTY_NO | Joint venture | |
| 126 | Table/Structure Field |
ROIUREP_VENTURE_PROP - PROPERTY_NO | Property No. | |
| 127 | Table/Structure Field |
ROIUREP_VENTURE_PROP - VNAME | Joint venture | |
| 128 | Table/Structure Field |
ROIUREP_XTRCT_ROY - BTCH_TYPE_CODE | Batch Type | |
| 129 | Table/Structure Field |
ROIUREP_XTRCT_ROY - GL_PD_CD | GL Product Code | |
| 130 | Table/Structure Field |
ROIUREP_XTRCT_ROY - GL_PR_NO | Property No. | |
| 131 | Table/Structure Field |
ROIUREP_XTRCT_ROY - GL_SA_MP_NO | Measurement Point No. | |
| 132 | Table/Structure Field |
ROIUREP_XTRCT_ROY - GL_SYS_SRCE_CD | OIUH_CHAR2 | |
| 133 | Table/Structure Field |
ROIUREP_XTRCT_ROY - GL_VL_TYPE_CD | GL Volume Type Code | |
| 134 | Table/Structure Field |
ROIUREP_XTRCT_ROY - GL_WC_NO | Well Completion No. | |
| 135 | Table/Structure Field |
ROIUREP_XTRCT_ROY - GL_WL_NO | Well No. | |
| 136 | Table/Structure Field |
ROIUREP_XTRCT_ROY - OPSL_GL_SYS_NO | OIUH_DEC18 | |
| 137 | Table/Structure Field |
ROIUREP_XTRCT_ROY - OPSL_GRV_QY | OIUH_DEC3_1 | |
| 138 | Table/Structure Field |
ROIUREP_XTRCT_ROY - OPSL_ORIG_MP_NO | Measurement Point No. | |
| 139 | Table/Structure Field |
ROIUREP_XTRCT_ROY - OPSL_OWN_NO | OIUH_CHAR6 | |
| 140 | Table/Structure Field |
ROIUREP_XTRCT_ROY - OPSL_OWN_SEQ_NO | OIUH_CHAR2 | |
| 141 | Table/Structure Field |
ROIUREP_XTRCT_ROY - OPSL_UNIT_PR_NO | Property No. |
