Table/Structure Field list used by SAP ABAP Program ROIUREP_MMS_2014_EXTRACTIONTOP (Top include for MMS-014 Extraction Propgram)
SAP ABAP Program
ROIUREP_MMS_2014_EXTRACTIONTOP (Top include for MMS-014 Extraction Propgram) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | DD07V - DOMVALUE_L | Values for Domains: Single Value / Upper Limit | ||
| 2 | OIUH_CM_BA - BA_BA_NO | Business Associate | ||
| 3 | OIUH_CM_BA - BA_SEQ_NO | Sequence Number | ||
| 4 | OIUH_RV_AC - AC_ACCT_NO | OIUH_CHAR10 | ||
| 5 | OIUH_RV_AC - AC_CAT_NO | OIUH_CHAR4 | ||
| 6 | OIUH_RV_AC - AC_ENTY_TYPE_CD | OIUH_CHAR2 | ||
| 7 | OIUH_RV_AC - AC_OR_LVL_1_NO | OIUH_CHAR3 | ||
| 8 | OIUH_RV_AC - AC_PD_CD | OIUH_CHAR3 | ||
| 9 | OIUH_RV_GL - BTCH_TYPE_CODE | OIUH_CHAR2 | ||
| 10 | OIUH_RV_GL - GL_ACCT_NO | OIUH_CHAR10 | ||
| 11 | OIUH_RV_GL - GL_CT_NO | Contract ID | ||
| 12 | OIUH_RV_GL - GL_CT_TYPE_CD | Contract Type | ||
| 13 | OIUH_RV_GL - GL_DN_NO | OIUH_CHAR4 | ||
| 14 | OIUH_RV_GL - GL_DOI_NO | OIUH_CHAR5 | ||
| 15 | OIUH_RV_GL - GL_GL_SYS_NO | OIUH_DEC18 | ||
| 16 | OIUH_RV_GL - GL_GR_AM | Local amount | ||
| 17 | OIUH_RV_GL - GL_GR_QY | OIUH_DEC11_2 | ||
| 18 | OIUH_RV_GL - GL_PD_CD | OIUH_CHAR3 | ||
| 19 | OIUH_RV_GL - GL_PR_NO | OIUH_CHAR8 | ||
| 20 | OIUH_RV_GL - GL_PU_NO | OIUH_CHAR6 | ||
| 21 | OIUH_RV_GL - GL_PU_SEQ_NO | OIUH_CHAR2 | ||
| 22 | OIUH_RV_GL - GL_SA_DT | OIUH_CHAR14 | ||
| 23 | OIUH_RV_GL - GL_SUB_NWK_NO | OIUH_CHAR4 | ||
| 24 | OIUH_RV_GL - GL_TIMESTAMP | OIUH_CHAR14 | ||
| 25 | OIUH_RV_GL - GL_TRANS_AM | Local amount | ||
| 26 | OIUH_RV_GL - GL_TRANS_QY | OIUH_DEC11_2 | ||
| 27 | OIUH_RV_GL - GL_WC_NO | OIUH_CHAR2 | ||
| 28 | OIUH_RV_GL - GL_WL_NO | OIUH_CHAR6 | ||
| 29 | OIUH_RV_GTAX - GTAX_GL_SYS_NO | OIUH_DEC18 | ||
| 30 | OIUH_RV_GTAX - GTAX_TAX_AM | Local amount | ||
| 31 | OIUH_RV_OPSL - L_NET_OTH_MK_AM | Local amount | ||
| 32 | OIUH_RV_OPSL - L_NET_TRANSP_AM | Local amount | ||
| 33 | OIUH_RV_OPSL - MMBTU_OWN_VL_AM | OIUH_DEC11_2 | ||
| 34 | OIUH_RV_OPSL - OPSL_BTU_QY | OIUH_DEC7_3 | ||
| 35 | OIUH_RV_OPSL - OPSL_DED_RMB_AM | Local amount | ||
| 36 | OIUH_RV_OPSL - OPSL_GL_SYS_NO | OIUH_DEC18 | ||
| 37 | OIUH_RV_OPSL - OPSL_GRV_QY | OIUH_DEC3_1 | ||
| 38 | OIUH_RV_OPSL - OPSL_OWN_NO | OIUH_CHAR6 | ||
| 39 | OIUH_RV_OPSL - OPSL_OWN_SEQ_NO | OIUH_CHAR2 | ||
| 40 | OIUH_RV_OPSL - OPSL_PAY_CD | OIUH_CHAR2 | ||
| 41 | OIUH_RV_OPSL - OPSL_PS_BASE_QY | OIUH_DEC6_3 | ||
| 42 | OIUH_RV_OPSL - OPSL_SUS_RSN_CD | OIUH_CHAR2 | ||
| 43 | OIUH_RV_OPSL - OPSL_TAX_RMB_AM | Local amount | ||
| 44 | OIUH_RV_OPSL - OWN_INT_SEQ_NO | OIUH_CHAR2 | ||
| 45 | OIUH_RV_OPSL - OWN_INT_TYPE_CD | OIUH_CHAR2 | ||
| 46 | OIUH_RV_OPSL - UNIT_OF_MEAS_CD | OIUH_CHAR3 | ||
| 47 | OIUH_RV_OTAX - OTAX_GL_SYS_NO | OIUH_DEC18 | ||
| 48 | OIUH_RV_OTAX - OTAX_TAX_AM | Local amount | ||
| 49 | OIUH_RV_STSL - L_NET_OTH_MK_AM | Local amount | ||
| 50 | OIUH_RV_STSL - L_NET_TRANSP_AM | Local amount | ||
| 51 | OIUH_RV_STSL - MMBTU_OWN_VL_AM | OIUH_DEC11_2 | ||
| 52 | OIUH_RV_STSL - OWN_INT_SEQ_NO | OIUH_CHAR2 | ||
| 53 | OIUH_RV_STSL - OWN_INT_TYPE_CD | OIUH_CHAR2 | ||
| 54 | OIUH_RV_STSL - STSL_BTU_QY | OIUH_DEC7_3 | ||
| 55 | OIUH_RV_STSL - STSL_DED_RMB_AM | Local amount | ||
| 56 | OIUH_RV_STSL - STSL_GL_SYS_NO | OIUH_DEC18 | ||
| 57 | OIUH_RV_STSL - STSL_GRV_QY | OIUH_DEC3_1 | ||
| 58 | OIUH_RV_STSL - STSL_OWN_NO | OIUH_CHAR6 | ||
| 59 | OIUH_RV_STSL - STSL_OWN_SEQ_NO | OIUH_CHAR2 | ||
| 60 | OIUH_RV_STSL - STSL_PAY_CD | OIUH_CHAR2 | ||
| 61 | OIUH_RV_STSL - STSL_PS_BASE_QY | OIUH_DEC6_3 | ||
| 62 | OIUH_RV_STSL - STSL_TAX_RMB_AM | Local amount | ||
| 63 | OIUH_RV_STSL - STSL_UNIT_PR_NO | OIUH_CHAR8 | ||
| 64 | OIUH_RV_STSL - UNIT_OF_MEAS_CD | OIUH_CHAR3 | ||
| 65 | OIUREP_LEASE - ALLOCATION_FAC | Production: MMS-2014 - Lease/Agreement Allocation Factor | ||
| 66 | OIUREP_LEASE - COMP_ROYALTY_FL | Production: MMS-2014 - Compensatory Royalty Flag | ||
| 67 | OIUREP_LEASE - REPORT_PART_FAC | Production: MMS-2014 - Report Participation Factor | ||
| 68 | OIUREP_MMS_REJS - ERROR_CD | Error code for the MMS 2014 report | ||
| 69 | OIUREP_OWNER - TRIBAL_ALLOT_CD | Production: MMS-2014 - Tribal/Allottee Code | ||
| 70 | OIUREP_PAYOR - PAYOR_NO | Production: MMS-2014 - Payor | ||
| 71 | OIUREP_PRDCDXREF - MATNR | Material Number | ||
| 72 | OIUREP_PRPAYXREF - PAYORXREF_REC_NO | Production: MMS-2014 - Payor XRef Record Number | ||
| 73 | OIUREP_RTPEND - ADJ_CD | Production: MMS-2014 - Adjustment Reason Code | ||
| 74 | OIUREP_RTPEND - CT_NO | Contract Number | ||
| 75 | OIUREP_RTPEND - DED_REMB_AMT | Production: MMS-2014 - Deduction Reimbursement Amount | ||
| 76 | OIUREP_RTPEND - DOI_NO | Division of interest (DOI) | ||
| 77 | OIUREP_RTPEND - FED_INDIAN_CD | Production: MMS-2014 - Federal or Indian Code | ||
| 78 | OIUREP_RTPEND - GAS_MMBTU_QY | Production: MMS-2014 - Gas MMBTU Qty | ||
| 79 | OIUREP_RTPEND - GL_ACCTID_NO | Account ID | ||
| 80 | OIUREP_RTPEND - HISTORY_FL | Production: MMS-2014 - History Flag | ||
| 81 | OIUREP_RTPEND - INT_SEQ_NO | Interest Sequence Number | ||
| 82 | OIUREP_RTPEND - INT_TYPE_CD | Interest Type Code | ||
| 83 | OIUREP_RTPEND - LEASE_NO | MMS-2014 - Lease Number | ||
| 84 | OIUREP_RTPEND - MATNR | Material Number | ||
| 85 | OIUREP_RTPEND - MMS_PROD_CD | Production: MMS Product Code | ||
| 86 | OIUREP_RTPEND - OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
| 87 | OIUREP_RTPEND - OWN_ISQ_NO | Owner Interest Sequence Number | ||
| 88 | OIUREP_RTPEND - OWN_NO | PRA owner | ||
| 89 | OIUREP_RTPEND - PAYOR_NO | Production: MMS-2014 - Payor | ||
| 90 | OIUREP_RTPEND - PAY_CD | Production: MMS-2014 - Payment Code | ||
| 91 | OIUREP_RTPEND - PAY_METHOD_CD | Production: MMS-2014 - Payment Method Code | ||
| 92 | OIUREP_RTPEND - PROC_ALW_DE_AMT | Production: MMS-2014 - Manufacturing UOM Amount | ||
| 93 | OIUREP_RTPEND - ROY_LS_ALLOW_AMT | Production: MMS-2014 - Royalty Value Less Allows. Amt | ||
| 94 | OIUREP_RTPEND - ROY_PR_ALW_AMT | Production: MMS-2014 - Royalty Value Prior to Allows. Amt | ||
| 95 | OIUREP_RTPEND - ROY_QY | Production: MMS-2014 - Royalty Quantity | ||
| 96 | OIUREP_RTPEND - ROY_QY_U | Production: MMS-2014 - Royalty Quantity Unit | ||
| 97 | OIUREP_RTPEND - RTP_LINE_NUM | MMS-2014 - Line Number | ||
| 98 | OIUREP_RTPEND - SALES_AMT | Production: MMS-2014 - Sales Amount | ||
| 99 | OIUREP_RTPEND - SALES_BTU_QY | Production: MMS-2014 - Sales BTU Quantity | ||
| 100 | OIUREP_RTPEND - SALES_CUR | Production: MMS-2014 - Sales Currency | ||
| 101 | OIUREP_RTPEND - SALES_DATE | Sales Date / Month | ||
| 102 | OIUREP_RTPEND - SALES_GV_QY | Production: MMS-2014 - Sales Gravity Qty | ||
| 103 | OIUREP_RTPEND - SALES_PS_BASE_QY | Pressure Base | ||
| 104 | OIUREP_RTPEND - SALES_QY | Sales Quantity | ||
| 105 | OIUREP_RTPEND - SALES_QY_U | Production: MMS-2014 - Sales Qty Unit | ||
| 106 | OIUREP_RTPEND - TAX_AMT | Production: MMS-2014 - Tax Amount | ||
| 107 | OIUREP_RTPEND - TAX_REMB_AMT | Production: MMS-2014 - Tax Reimbursement Amount | ||
| 108 | OIUREP_RTPEND - TRANS_CD | Production: MMS-2014 - Transaction Code | ||
| 109 | OIUREP_RTPEND - TRNSP_ALW_DE_AMT | Production: MMS-2014 - Transportation Allowance Amount | ||
| 110 | OIUREP_RTPEND - VNAME | MMS-2014 - Venture | ||
| 111 | OIUREP_RTPEND - WC_NO | Well Completion Number | ||
| 112 | OIUREP_RTPEND - WL_NO | Well ID number | ||
| 113 | OIUREP_RT_HIST - ADJ_BTU_QY | Production: MMS-2014 - Adjusted BTU Quantity | ||
| 114 | OIUREP_RT_HIST - ADJ_BTU_QY_U | Production: MMS-2014 - Adjusted BTU Quantity Unit | ||
| 115 | OIUREP_RT_HIST - AGREEMENT_NO | Production: MMS-2014 - Agreement Number | ||
| 116 | OIUREP_RT_HIST - CT_NO | Contract Number | ||
| 117 | OIUREP_RT_HIST - DOI_NO | Division of interest (DOI) | ||
| 118 | OIUREP_RT_HIST - FED_INDIAN_CD | Production: MMS-2014 - Federal or Indian Code | ||
| 119 | OIUREP_RT_HIST - GAS_MMBTU_QY | Production: MMS-2014 - Gas MMBTU Qty | ||
| 120 | OIUREP_RT_HIST - GL_ACCTID_NO | Account ID | ||
| 121 | OIUREP_RT_HIST - INT_SEQ_NO | Interest Sequence Number | ||
| 122 | OIUREP_RT_HIST - INT_TYPE_CD | Interest Type Code | ||
| 123 | OIUREP_RT_HIST - LEASE_NO | MMS-2014 - Lease Number | ||
| 124 | OIUREP_RT_HIST - MATNR | Material Number | ||
| 125 | OIUREP_RT_HIST - OWN_ISQ_NO | Owner Interest Sequence Number | ||
| 126 | OIUREP_RT_HIST - OWN_NO | PRA owner | ||
| 127 | OIUREP_RT_HIST - PAY_CD | Production: MMS-2014 - Payment Code | ||
| 128 | OIUREP_RT_HIST - SALES_BTU_QY | Production: MMS-2014 - Sales BTU Quantity | ||
| 129 | OIUREP_RT_HIST - SALES_BTU_QY_U | Production: MMS-2014 - Sales BTU Qty Unit | ||
| 130 | OIUREP_RT_HIST - SALES_DATE | Sales Date / Month | ||
| 131 | OIUREP_RT_HIST - SALES_TYPE_CD | Production: MMS-2014 - Sales Type Code | ||
| 132 | OIUREP_RT_HIST - TRANS_CD | Production: MMS-2014 - Transaction Code | ||
| 133 | OIUREP_RT_HIST - VNAME | MMS-2014 - Venture | ||
| 134 | OIUREP_RT_HIST - WC_NO | Well Completion Number | ||
| 135 | OIUREP_RT_HIST - WL_NO | Well ID number | ||
| 136 | OIUREP_UOM - DIMID | Dimension key | ||
| 137 | OIUREP_UOM - EFF_FROM_MO | Production Month (YYYYMM) | ||
| 138 | OIUREP_UOM - MAJPD_CD | Major product code | ||
| 139 | OIUREP_UOM - MSEHI | Unit of Measurement | ||
| 140 | OIU_CREATION - OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
| 141 | OIU_ME_UOM_GR_AS - MSEHI | Unit of Measurement | ||
| 142 | OIU_ME_UOM_GR_AS - UOMGR | unit of measure group | ||
| 143 | OIU_PR_DNVD - DN_NO | Delivery network number | ||
| 144 | OIU_PR_DNVD - EFF_FROM_DT | Effective from date | ||
| 145 | OIU_PR_DNVD - EFF_TO_DT | Effective To Date | ||
| 146 | OIU_PR_DNVD - MEAS_GRP_ID | Measurement Group ID | ||
| 147 | OIU_PR_DN_UOMG - CONV_GRP | Conversion Group (Oil, Natural Gas,..) | ||
| 148 | OIU_PR_DN_UOMG - MAJPD_CD | Major product code | ||
| 149 | OIU_PR_DN_UOMG - MEAS_GRP_ID | Measurement Group ID | ||
| 150 | OIU_PR_DN_UOMG - UOM_GRP | unit of measure group | ||
| 151 | ROIUREP_MATNR_PDCD - MATNR | Material Number | ||
| 152 | ROIUREP_MATNR_PDCD - PRODUCT_CODE | Product Code | ||
| 153 | ROIUREP_MMS_2014_LEASE_NON - ALLOCATION_FAC | Production: MMS-2014 - Lease/Agreement Allocation Factor | ||
| 154 | ROIUREP_MMS_2014_LEASE_NON - COMP_ROYALTY_FL | Production: MMS-2014 - Compensatory Royalty Flag | ||
| 155 | ROIUREP_MMS_2014_LEASE_NON - REPORT_PART_FAC | Production: MMS-2014 - Report Participation Factor | ||
| 156 | ROIUREP_MMS_2014_OWNER_NON - TRIBAL_ALLOT_CD | Production: MMS-2014 - Tribal/Allottee Code | ||
| 157 | ROIUREP_MMS_2014_PAYORXREF_NON - PAYORXREF_REC_NO | Production: MMS-2014 - Payor XRef Record Number | ||
| 158 | ROIUREP_MMS_2014_RT_KEY - RTP_LINE_NUM | MMS-2014 - Line Number | ||
| 159 | ROIUREP_MMS_2014_RT_NON - ADJ_BTU_QY | Production: MMS-2014 - Adjusted BTU Quantity | ||
| 160 | ROIUREP_MMS_2014_RT_NON - ADJ_BTU_QY_U | Production: MMS-2014 - Adjusted BTU Quantity Unit | ||
| 161 | ROIUREP_MMS_2014_RT_NON - ADJ_CD | Production: MMS-2014 - Adjustment Reason Code | ||
| 162 | ROIUREP_MMS_2014_RT_NON - AGREEMENT_NO | Production: MMS-2014 - Agreement Number | ||
| 163 | ROIUREP_MMS_2014_RT_NON - CT_NO | Contract Number | ||
| 164 | ROIUREP_MMS_2014_RT_NON - DED_REMB_AMT | Production: MMS-2014 - Deduction Reimbursement Amount | ||
| 165 | ROIUREP_MMS_2014_RT_NON - DOI_NO | Division of interest (DOI) | ||
| 166 | ROIUREP_MMS_2014_RT_NON - FED_INDIAN_CD | Production: MMS-2014 - Federal or Indian Code | ||
| 167 | ROIUREP_MMS_2014_RT_NON - GAS_MMBTU_QY | Production: MMS-2014 - Gas MMBTU Qty | ||
| 168 | ROIUREP_MMS_2014_RT_NON - GL_ACCTID_NO | Account ID | ||
| 169 | ROIUREP_MMS_2014_RT_NON - HISTORY_FL | Production: MMS-2014 - History Flag | ||
| 170 | ROIUREP_MMS_2014_RT_NON - INT_SEQ_NO | Interest Sequence Number | ||
| 171 | ROIUREP_MMS_2014_RT_NON - INT_TYPE_CD | Interest Type Code | ||
| 172 | ROIUREP_MMS_2014_RT_NON - LEASE_NO | MMS-2014 - Lease Number | ||
| 173 | ROIUREP_MMS_2014_RT_NON - MATNR | Material Number | ||
| 174 | ROIUREP_MMS_2014_RT_NON - MMS_PROD_CD | Production: MMS Product Code | ||
| 175 | ROIUREP_MMS_2014_RT_NON - OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
| 176 | ROIUREP_MMS_2014_RT_NON - OWN_ISQ_NO | Owner Interest Sequence Number | ||
| 177 | ROIUREP_MMS_2014_RT_NON - OWN_NO | PRA owner | ||
| 178 | ROIUREP_MMS_2014_RT_NON - PAYOR_NO | Production: MMS-2014 - Payor | ||
| 179 | ROIUREP_MMS_2014_RT_NON - PAY_CD | Production: MMS-2014 - Payment Code | ||
| 180 | ROIUREP_MMS_2014_RT_NON - PAY_METHOD_CD | Production: MMS-2014 - Payment Method Code | ||
| 181 | ROIUREP_MMS_2014_RT_NON - PROC_ALW_DE_AMT | Production: MMS-2014 - Manufacturing UOM Amount | ||
| 182 | ROIUREP_MMS_2014_RT_NON - ROY_LS_ALLOW_AMT | Production: MMS-2014 - Royalty Value Less Allows. Amt | ||
| 183 | ROIUREP_MMS_2014_RT_NON - ROY_PR_ALW_AMT | Production: MMS-2014 - Royalty Value Prior to Allows. Amt | ||
| 184 | ROIUREP_MMS_2014_RT_NON - ROY_QY | Production: MMS-2014 - Royalty Quantity | ||
| 185 | ROIUREP_MMS_2014_RT_NON - ROY_QY_U | Production: MMS-2014 - Royalty Quantity Unit | ||
| 186 | ROIUREP_MMS_2014_RT_NON - SALES_AMT | Production: MMS-2014 - Sales Amount | ||
| 187 | ROIUREP_MMS_2014_RT_NON - SALES_BTU_QY | Production: MMS-2014 - Sales BTU Quantity | ||
| 188 | ROIUREP_MMS_2014_RT_NON - SALES_BTU_QY_U | Production: MMS-2014 - Sales BTU Qty Unit | ||
| 189 | ROIUREP_MMS_2014_RT_NON - SALES_CUR | Production: MMS-2014 - Sales Currency | ||
| 190 | ROIUREP_MMS_2014_RT_NON - SALES_DATE | Sales Date / Month | ||
| 191 | ROIUREP_MMS_2014_RT_NON - SALES_GV_QY | Production: MMS-2014 - Sales Gravity Qty | ||
| 192 | ROIUREP_MMS_2014_RT_NON - SALES_PS_BASE_QY | Pressure Base | ||
| 193 | ROIUREP_MMS_2014_RT_NON - SALES_QY | Sales Quantity | ||
| 194 | ROIUREP_MMS_2014_RT_NON - SALES_QY_U | Production: MMS-2014 - Sales Qty Unit | ||
| 195 | ROIUREP_MMS_2014_RT_NON - SALES_TYPE_CD | Production: MMS-2014 - Sales Type Code | ||
| 196 | ROIUREP_MMS_2014_RT_NON - TAX_AMT | Production: MMS-2014 - Tax Amount | ||
| 197 | ROIUREP_MMS_2014_RT_NON - TAX_REMB_AMT | Production: MMS-2014 - Tax Reimbursement Amount | ||
| 198 | ROIUREP_MMS_2014_RT_NON - TRANS_CD | Production: MMS-2014 - Transaction Code | ||
| 199 | ROIUREP_MMS_2014_RT_NON - TRNSP_ALW_DE_AMT | Production: MMS-2014 - Transportation Allowance Amount | ||
| 200 | ROIUREP_MMS_2014_RT_NON - VNAME | MMS-2014 - Venture | ||
| 201 | ROIUREP_MMS_2014_RT_NON - WC_NO | Well Completion Number | ||
| 202 | ROIUREP_MMS_2014_RT_NON - WL_NO | Well ID number | ||
| 203 | SYST - DATUM | ABAP System Field: Current Date of Application Server | ||
| 204 | SYST - DBCNT | ABAP System Field: Edited Database Table Rows | ||
| 205 | SYST - TABIX | ABAP System Field: Row Index of Internal Tables | ||
| 206 | T006 - DIMID | Dimension key | ||
| 207 | T006 - MSEHI | Unit of Measurement |