1. Home
  2. Resources
  3. SAP Tables
  4. ROIUREP_MMS_EDIT_REJS - MRT_HIST rejects with New and Revised MMS EDITS

SAP Table ROIUREP_MMS_EDIT_REJS

MRT_HIST rejects with New and Revised MMS EDITS

ROIUREP_MMS_EDIT_REJS (MRT_HIST rejects with New and Revised MMS EDITS) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ROIUREP_MMS_EDIT_REJS to other SAP tables.

ROIUREP_MMS_EDIT_REJS table fields

Field Data element Checktable Datatype Length Decimals
ERROR_CD_LIST Text for error class 1 FEHT1 CHAR 60 0
1 Reorder level and safety stock
2 Model selection and test
3 Initialization
4 Parameter optimization
5 Difficulties during the forecast
6 Forecast not calculated
7 Missing table entries
8 Terminations
MANDT Client MANDT T000 CLNT 3 0
DOC_ID Production: MMS-2104 - Document ID OIUREP_MMS_2014_DOC_ID CHAR 8 0
DET_LINE_NO Line Number OIU_LIN_NO NUMC 5 0
BUKRS Company Code BUKRS T001 CHAR 4 0
PAYOR_NO Production: MMS-2014 - Payor OIUREP_MMS_2014_PAYOR CHAR 5 0
SALES_YEAR MMS-2014 - Year OIUREP_MMS_2014_YEAR NUMC 4 0
SALES_MONTH MMS-2014 - Month OIUREP_MMS_2014_MONTH NUMC 2 0
01 January
02 February
03 March
04 April
05 May
06 June
07 July
08 August
09 September
10 October
11 November
12 December
FED_INDIAN_CD Production: MMS-2014 - Federal or Indian Code OIUREP_MMS_2014_FED_INDIAN_CD CHAR 1 0
F Federal
I Indian
RESERV_SPACE Production: MMS-2104 - Reserve Space OIUREP_MMS_2014_RESERV_SPACE CHAR 20 0
LEASE_NO MMS-2014 - Lease Number OIUREP_MMS_2014_LEASE_NO OIUREP_FEDINDIAN CHAR 11 0
AGREEMENT_NO Production: MMS-2014 - Agreement Number OIUREP_MMS_2014_AGREEMENT_NO OIUREP_LEASE CHAR 11 0
API_WELL_NO API well number OIU_WLAPI CHAR 12 0
API_WELL_CM_NO API well completion number OIU_API_WC_NO CHAR 3 0
MMS_PROD_CD Production: MMS Product Code OIUREP_MMS_PRODUCT_CODE CHAR 2 0
01 Oil
02 Condensate
03 Processed (Residue) Gas
04 Unprocessed (Wet) Gas
05 Drip or Scrubber Condensate
06 Inlet Scrubber
07 Gas Plant Products
09 Nitrogen
12 Flash Gas
13 Fuel Oil
14 Oil Lost
15 Fuel Gas
16 Gas Lost - Flared or Vented
17 Carbon Dioxide Gas (CO2)
19 Sulfur
20 Other Liquid Hydrocarbons
22 Helium
25 Geothermal - Hot Water
26 Geothermal - Effluent Disposal
27 Geothermal - Steam
31 Geothermal - Electrical Generation, Kilowatt Hours
32 Geothermal - Electrical Generation, Thousands of Pounds
33 Geothermal - Electrical Generation, Millions of BTUs
34 Geothermal - Electrical Generation, Other
35 Geothermal - Direct Utilitzation, Millions of BTUs
36 Geothermal - Direct Utilitzation, Hundreds of Gallons
37 Geothermal - Direct Utilitzation, Other
38 Geothermal - Commercially Demineralized H2O
39 Coalbed Methane
SALES_TYPE_CD Production: MMS-2014 - Sales Type Code OIUREP_MMS_2014_SALES_TYPE_CD OIUREP_SALESTY CHAR 4 0
TRANS_CD Production: MMS-2014 - Transaction Code OIUREP_MMS_2014_TRANS_CD CHAR 2 0
01 Royalty Due
02 Minimum Royalty Due
03 Estimated Royalty Due
04 Rental Payment
05 Advance Rental Credit
06 Royalty In Kind Transaction - No Cash Payment to MMS
08 Royalty In Kind
10 Compensatory Royalty Payment
11 Transportation Allowance
12 Tax Cedit
13 RIK Quality Bank and Gravity Bank Adjustment
14 Tax Reimbursement Payment
15 Processing Allowance
16 Well Fees
17 Gas Storage Agreement - Flat Fee
18 Gas Storage Agreement - Injection Fee
19 Gas Storage Agreement - Withdrawal Fee
20 No Sales (Solids Only)
21 Interest Amount Due MMS
22 Interest Amount Owed to Payor
25 Recoup Advance Rental Credit
31 Contract Settlements Payment
32 Advance Royalty (Solids Coal Leases Only)
33 Recoup Advance Royalty (Solids Only)
37 Royalties Due In Lieu of Severance Tax
38 Additional Royalties Due for 6A9 Leases
39 Net Profit Share - Unprofitable
40 Net Profit - Profitable
41 Offshore Deep Water Royalty Relief
42 Net Revenue Share Lease, Allot. for Operating Cost
50 Indian Recoupable Balance (Indian Leases Only)
51 Indian Recoupable Taken (Indian Leases Only)
52 Recoup Minimum Royalty Paid In Advance
53 Effluent Injection Payment or Reimbursement
54 Geothermal Field Operations Payment or Reimbursement
60 Reserved for Future Use
07 MMS Settlement Agreement
44 Shallow Water Deep Gas Royalty Relief
55 Deep Water Royalty Relief
ADJ_CD Production: MMS-2014 - Adjustment Reason Code OIUREP_MMS_2014_ADJ_CD NUMC 2 0
10 Adjustment
15 Marginal Property True Up
16 Major Portion/Dual Accounting
17 MMS-Initiated Compliance Adjustment
20 DOE Strategic Petroleum Reserve (SPR) RIK With Royalty Value
21 DOE SPR Without Royalty Value
25 Netback Costs True Up (Geothermal Lease Only)
26 Change Valuation Method (Geothermal Lease Only)
31 Retroactive Manadatory Price Adj. (Geothermal Lease Only)
32 Estimate Adjustment
35 Unit Particpating Area/Communitiazation Agr. Adjustment
49 Index Zone/Dual Accounting Price Adjustment
71 Estimate Underpayment/Overpayment Interest
72 Audit Underpayment/Overpaymenr Interest
MMS_SA_QY Production: MMS-2014 - MMS Sales Quantity OIUREP_MMS_2014_MMS_SA_QY QUAN 13 3
MMS_SA_QY_U Production: MMS-2014 - MMS Sales Quantity Unit OIUREP_MMS_2014_MMS_SA_QY_U T006 UNIT 3 0
GAS_MMBTU_QY Production: MMS-2014 - Gas MMBTU Qty OIUREP_MMS_2014_GAS_MMBTU_QY QUAN 13 3
GAS_MMBTU_QY_U Production: MMS-2014 - Gas MMBTU Qty Unit OIUREP_MMS_2014_GAS_MMBTU_QY_U T006 UNIT 3 0
MMS_SA_AMT Production: MMS-2014 - MMS Sales Amount OIUREP_MMS_2014_MMS_SA_AMT CURR 15 2
MMS_SA_CUR Production: MMS-2014 - MMS Sales Currency OIUREP_MMS_2014_MMS_SA_CUR TCURC CUKY 5 0
ROY_PR_ALW_AMT Production: MMS-2014 - Royalty Value Prior to Allows. Amt OIUREP_MMS_2014_ROY_PR_ALW_AMT CURR 15 2
ROY_PR_ALW_CUR Production: MMS-2014 - Royalty Value Prior to Allows. Curr OIUREP_MMS_2014_ROY_PR_ALW_CUR TCURC CUKY 5 0
TRNSP_ALW_DE_AMT Production: MMS-2014 - Transportation Allowance Amount OIUREP_MMS_2014_TRNSP_ALLW_AMT CURR 15 2
TRNSP_ALW_DE_CUR MMS-2014 - Transportation Allowance Currency OIUREP_MMS_2014_TRNSP_ALLW_CUR TCURC CUKY 5 0
PROC_ALW_DE_AMT Production: MMS-2014 - Manufacturing UOM Amount OIUREP_MMS_2014_MFRING_UOM_AMT CURR 15 2
PROC_ALW_DE_CUR Production: MMS-2014 - Manufacturing UOM Currency OIUREP_MMS_2014_MFRING_UOM_CUR TCURC CUKY 5 0
ROY_LS_ALLOW_AMT Production: MMS-2014 - Royalty Value Less Allows. Amt OIUREP_MMS_2014_ROY_LS_ALW_AMT CURR 15 2
ROY_LS_ALLOW_CUR Production: MMS-2014 - Royalty Value Less Allows Curr OIUREP_MMS_2014_ROY_LS_ALW_CUR TCURC CUKY 5 0
PAY_METHOD_CD Production: MMS-2014 - Payment Method Code OIUREP_MMS_2014_PAY_METHOD_CD CHAR 1 0
1 Checks to MMS
2 Indian Direct Pay
3 EFT Payment
4 Royalty-In-Kind
5 Checks to MMS for BIA
6 Other (reserved for future use)
7 Indian Lockbox
INDIAN_TRIBE_NO Production: MMS-2014 - Indian Tribe Number OIUREP_MMS_2014_INDN_TRIBE_NO OIUREP_INDIAN_TR CHAR 2 0
REVERSAL_FL Production: MMS-2014 - Reversal History Flag OIUREP_MMS_2014_REVERSAL_FL CHAR 1 0
X Yes
NULL No
REVERSAL_YEAR MMS-2014 - Year OIUREP_MMS_2014_YEAR NUMC 4 0
REVERSAL_MONTH MMS-2014 - Month OIUREP_MMS_2014_MONTH NUMC 2 0
01 January
02 February
03 March
04 April
05 May
06 June
07 July
08 August
09 September
10 October
11 November
12 December
SALES_DATE Sales Date / Month OIU_SALE_DT DATS 8 0
OIU_CRUSER Name of Person who Created the Object ERNAM CHAR 12 0
OIU_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS DEC 15 0

ROIUREP_MMS_EDIT_REJS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ROIUREP_MMS_EDIT_REJS AGREEMENT_NO * OIUREP_LEASE MMS-2014 - Lease MANDT
ROIUREP_MMS_EDIT_REJS AGREEMENT_NO ROIUREP_MMS_EDIT_REJS LEASE_NO OIUREP_LEASE MMS-2014 - Lease PAYORXREF_REC_NO
ROIUREP_MMS_EDIT_REJS AGREEMENT_NO ROIUREP_MMS_EDIT_REJS FED_INDIAN_CD OIUREP_LEASE MMS-2014 - Lease LEASE_NO
ROIUREP_MMS_EDIT_REJS AGREEMENT_NO ROIUREP_MMS_EDIT_REJS AGREEMENT_NO OIUREP_LEASE MMS-2014 - Lease FED_INDIAN_CD
ROIUREP_MMS_EDIT_REJS AGREEMENT_NO * OIUREP_LEASE MMS-2014 - Lease AGREEMENT_NO
ROIUREP_MMS_EDIT_REJS AGREEMENT_NO SYST MANDT OIUREP_LEASE MMS-2014 - Lease .INCLUDE
ROIUREP_MMS_EDIT_REJS BUKRS SYST MANDT T001 Company Codes MANDT
ROIUREP_MMS_EDIT_REJS BUKRS ROIUREP_MMS_EDIT_REJS BUKRS T001 Company Codes BUKRS
ROIUREP_MMS_EDIT_REJS GAS_MMBTU_QY_U ROIUREP_MMS_EDIT_REJS GAS_MMBTU_QY_U T006 Units of Measurement MSEHI
ROIUREP_MMS_EDIT_REJS GAS_MMBTU_QY_U SYST MANDT T006 Units of Measurement MANDT
ROIUREP_MMS_EDIT_REJS INDIAN_TRIBE_NO SYST MANDT OIUREP_INDIAN_TR MMS-2014 - Indian Tribes MANDT
ROIUREP_MMS_EDIT_REJS INDIAN_TRIBE_NO ROIUREP_MMS_EDIT_REJS INDIAN_TRIBE_NO OIUREP_INDIAN_TR MMS-2014 - Indian Tribes INDIAN_TRIBE_NO
ROIUREP_MMS_EDIT_REJS LEASE_NO SYST MANDT OIUREP_FEDINDIAN MMS-2014 - Federal or Indian Leases MANDT
ROIUREP_MMS_EDIT_REJS LEASE_NO ROIUREP_MMS_EDIT_REJS LEASE_NO OIUREP_FEDINDIAN MMS-2014 - Federal or Indian Leases LEASE_NO
ROIUREP_MMS_EDIT_REJS MANDT ROIUREP_MMS_EDIT_REJS MANDT T000 Clients MANDT
ROIUREP_MMS_EDIT_REJS MMS_SA_CUR SYST MANDT TCURC Currency Codes MANDT
ROIUREP_MMS_EDIT_REJS MMS_SA_CUR ROIUREP_MMS_EDIT_REJS MMS_SA_CUR TCURC Currency Codes WAERS
ROIUREP_MMS_EDIT_REJS MMS_SA_QY_U SYST MANDT T006 Units of Measurement MANDT
ROIUREP_MMS_EDIT_REJS MMS_SA_QY_U ROIUREP_MMS_EDIT_REJS MMS_SA_QY_U T006 Units of Measurement MSEHI
ROIUREP_MMS_EDIT_REJS PROC_ALW_DE_CUR SYST MANDT TCURC Currency Codes MANDT
ROIUREP_MMS_EDIT_REJS PROC_ALW_DE_CUR ROIUREP_MMS_EDIT_REJS PROC_ALW_DE_CUR TCURC Currency Codes WAERS
ROIUREP_MMS_EDIT_REJS ROY_LS_ALLOW_CUR SYST MANDT TCURC Currency Codes MANDT
ROIUREP_MMS_EDIT_REJS ROY_LS_ALLOW_CUR ROIUREP_MMS_EDIT_REJS ROY_LS_ALLOW_CUR TCURC Currency Codes WAERS
ROIUREP_MMS_EDIT_REJS ROY_PR_ALW_CUR ROIUREP_MMS_EDIT_REJS ROY_PR_ALW_CUR TCURC Currency Codes WAERS
ROIUREP_MMS_EDIT_REJS ROY_PR_ALW_CUR SYST MANDT TCURC Currency Codes MANDT
ROIUREP_MMS_EDIT_REJS SALES_TYPE_CD SYST MANDT OIUREP_SALESTY MMS-2014: Sales Type Control Table MANDT
ROIUREP_MMS_EDIT_REJS SALES_TYPE_CD ROIUREP_MMS_EDIT_REJS SALES_TYPE_CD OIUREP_SALESTY MMS-2014: Sales Type Control Table SALES_TYPE_CD
ROIUREP_MMS_EDIT_REJS TRNSP_ALW_DE_CUR SYST MANDT TCURC Currency Codes MANDT
ROIUREP_MMS_EDIT_REJS TRNSP_ALW_DE_CUR ROIUREP_MMS_EDIT_REJS TRNSP_ALW_DE_CUR TCURC Currency Codes WAERS