ROIUREP_MMS_2014_RT_NON SAP (Production: MMS-2014 - Royalty Transactions Non-Key Fields) Structure details

Dictionary Type: Structure
Description: Production: MMS-2014 - Royalty Transactions Non-Key Fields




ABAP Code to SELECT data from ROIUREP_MMS_2014_RT_NON
Related tables to ROIUREP_MMS_2014_RT_NON
Access table ROIUREP_MMS_2014_RT_NON




Structure field list including key, data, relationships and ABAP select examples

ROIUREP_MMS_2014_RT_NON is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Production: MMS-2014 - Royalty Transactions Non-Key Fields" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_ROIUREP_MMS_2014_RT_NON TYPE ROIUREP_MMS_2014_RT_NON.

The ROIUREP_MMS_2014_RT_NON table consists of various fields, each holding specific information or linking keys about Production: MMS-2014 - Royalty Transactions Non-Key Fields data available in SAP. These include FED_INDIAN_CD (Production: MMS-2014 - Federal or Indian Code), INDIAN_TRIBE_NO (Production: MMS-2014 - Indian Tribe Number), API_WELL_NO (API well number), API_WELL_CM_NO (API well completion number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP ROIUREP_MMS_2014_RT_NON structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
PAYOR_NOProduction: MMS-2014 - Payor OIUREP_MMS_2014_PAYORCHAR5
FED_INDIAN_CDProduction: MMS-2014 - Federal or Indian Code OIUREP_MMS_2014_FED_INDIAN_CDCHAR1OIUREP_MMS_2014_FED_INDIAN_CD
INDIAN_TRIBE_NOProduction: MMS-2014 - Indian Tribe Number OIUREP_MMS_2014_INDN_TRIBE_NOCHAR2OIUREP_INDIAN_TROIUREP_MMS_2014_INDN_TRIBE_NO
API_WELL_NOAPI well number OIU_WLAPICHAR12CHRNMOIU_WLAPIOIU_API_NO
API_WELL_CM_NOAPI well completion number OIU_API_WC_NOCHAR3OIU_API_WC_NO
LEASE_NOMMS-2014 - Lease Number OIUREP_MMS_2014_LEASE_NOCHAR11OIUREP_FEDINDIANOIUREP_2014_LEASE
AGREEMENT_NOProduction: MMS-2014 - Agreement Number OIUREP_MMS_2014_AGREEMENT_NOCHAR11OIUREP_LEASE
MMS_PROD_CDProduction: MMS Product Code OIUREP_MMS_PRODUCT_CODECHAR2OIUREP_MMS_PRODUCT_CODE
SALES_TYPE_CDProduction: MMS-2014 - Sales Type Code OIUREP_MMS_2014_SALES_TYPE_CDCHAR4OIUREP_SALESTYOIUREP_MMS_2014_SALES_TYPE_CD
SALES_DATESales Date / Month OIU_SALE_DTDATS8DATUM
TRANS_CDProduction: MMS-2014 - Transaction Code OIUREP_MMS_2014_TRANS_CDCHAR2OIUREP_MMS_2014_TRANS_CD
PAY_METHOD_CDProduction: MMS-2014 - Payment Method Code OIUREP_MMS_2014_PAY_METHOD_CDCHAR1OIUREP_MMS_2014_PAY_METHOD_CD
WL_NOWell ID number OIU_WL_NOCHAR15OIU_PR_WELLALPHAOIU_WL_NOOIU_WELLH_OIU_PR_WELL
WC_NOWell Completion Number OIU_WC_NOCHAR5OIU_PR_WCALPHAOIU_WC_NOOIU_WCH_OIU_PR_WC
VNAMEMMS-2014 - Venture OIUREP_MMS_2014_PROPERTYCHAR6OIU_DO_JVALPHAJV_NAMEJVV
DOI_NODivision of interest (DOI) OIU_DOI_NOCHAR5OIU_DO_DIALPHAOIU_DOI_NOOIU_DOIH_OIU_DO_DI
PU_NOPurchaser OIU_PU_NOCHAR10Assigned to domainALPHAKUNNROIU_PU
PU_SEQ_NOPurchasing Representative Interest Sequence No OIU_PU_REP_ISQ_NOCHAR2ALPHAOIU_PU_REP_ISQ_NO
PU_AFFIL_FLProduction: MMS-2014 - Purchaser Affiliation Flag OIUREP_MMS_2014_PU_AFFIL_FLCHAR1YESNO
MATNRMaterial Number MATNRCHAR18OIU_CM_MAT_PRCDMATN1MATNRMATS_MAT1
OWN_NOPRA owner OIU_OWN_NOCHAR10LFA1ALPHALIFNROIU_OWN_NO
OWN_ISQ_NOOwner Interest Sequence Number OIU_OWN_ISQ_NOCHAR2ALPHAOIU_OWN_ISQ_NOOIU_OWN_ISQ_NO
CT_NOContract Number OIU_CT_NOCHAR10OIUCM_CONTRACTALPHAOIUCM_CONTRACT_NUMBEROIU_CID
GL_ACCTID_NOAccount ID OIUH_ACCTIDCHAR10CHAR10
NWK_NONetwork Number OIUREP_MMS_2014_NWK_NOCHAR4OIUREP_MMS_2014_NWK_NO
SUB_NWK_NOSub Network Number OIUREP_MMS_2014_SUB_NWK_NOCHAR4OIUREP_MMS_2014_SUB_NWK_NO
INT_TYPE_CDInterest Type Code OIUREP_MMS_2014_INT_TYPE_CDCHAR2OIUREP_MMS_2014_INT_TYPE_CD
INT_SEQ_NOInterest Sequence Number OIUREP_MMS_2014_INT_SEQ_NOCHAR2OIUREP_MMS_2014_INT_SEQ_NO
SALES_QYSales Quantity OIUREP_MMS_2014_SALES_QYQUAN13(3) OIUCM_QUANTITY_13_DECIMAL_3
SALES_QY_UProduction: MMS-2014 - Sales Qty Unit OIUREP_MMS_2014_SALES_QY_UUNIT3T006CUNITMEINS
SALES_GV_QYProduction: MMS-2014 - Sales Gravity Qty OIUREP_MMS_2014_SALES_GV_QYQUAN4(1)
SALES_GV_QY_UProduction: MMS-2014 - Sales Gravity Qty Unit OIUREP_MMS_2014_SALES_GV_QY_UUNIT3T006CUNITMEINS
SALES_BTU_QYProduction: MMS-2014 - Sales BTU Quantity OIUREP_MMS_2014_SALES_BTU_QYQUAN13(3) OIUCM_QUANTITY_13_DECIMAL_3
SALES_BTU_QY_UProduction: MMS-2014 - Sales BTU Qty Unit OIUREP_MMS_2014_SALES_BTU_QY_UUNIT3T006CUNITMEINS
SALES_PS_BASE_QYPressure Base OIU_PS_BASEQUAN13(3) MENGE
SALES_PS_BASE_UPressure Base Unit OIU_PS_BASE_UUNIT3T006CUNITMEINS
SALES_AMTProduction: MMS-2014 - Sales Amount OIUREP_MMS_2014_SALES_AMTCURR15(2) OIUCM_CURRENCY_15_DECIMAL_2
SALES_CURProduction: MMS-2014 - Sales Currency OIUREP_MMS_2014_SALES_CURCUKY5TCURCWAERS
ROY_PR_ALW_AMTProduction: MMS-2014 - Royalty Value Prior to Allows. Amt OIUREP_MMS_2014_ROY_PR_ALW_AMTCURR15(2) OIUCM_CURRENCY_15_DECIMAL_2
ROY_PR_ALW_CURProduction: MMS-2014 - Royalty Value Prior to Allows. Curr OIUREP_MMS_2014_ROY_PR_ALW_CURCUKY5TCURCWAERS
TRNSP_ALW_DE_AMTProduction: MMS-2014 - Transportation Allowance Amount OIUREP_MMS_2014_TRNSP_ALLW_AMTCURR15(2) OIUCM_CURRENCY_15_DECIMAL_2
TRNSP_ALW_DE_CURMMS-2014 - Transportation Allowance Currency OIUREP_MMS_2014_TRNSP_ALLW_CURCUKY5TCURCWAERS
PROC_ALW_DE_AMTProduction: MMS-2014 - Manufacturing UOM Amount OIUREP_MMS_2014_MFRING_UOM_AMTCURR15(2) OIUCM_CURRENCY_15_DECIMAL_2
PROC_ALW_DE_CURProduction: MMS-2014 - Manufacturing UOM Currency OIUREP_MMS_2014_MFRING_UOM_CURCUKY5TCURCWAERS
ROY_LS_ALLOW_AMTProduction: MMS-2014 - Royalty Value Less Allows. Amt OIUREP_MMS_2014_ROY_LS_ALW_AMTCURR15(2) OIUCM_CURRENCY_15_DECIMAL_2
ROY_LS_ALLOW_CURProduction: MMS-2014 - Royalty Value Less Allows Curr OIUREP_MMS_2014_ROY_LS_ALW_CURCUKY5TCURCWAERS
ROY_QYProduction: MMS-2014 - Royalty Quantity OIUREP_MMS_2014_ROY_QYQUAN13(3) OIUCM_QUANTITY_13_DECIMAL_3
ROY_QY_UProduction: MMS-2014 - Royalty Quantity Unit OIUREP_MMS_2014_ROY_QY_UUNIT3T006CUNITMEINS
DED_REMB_AMTProduction: MMS-2014 - Deduction Reimbursement Amount OIUREP_MMS_2014_DED_REMB_AMTCURR15(2) OIUCM_CURRENCY_15_DECIMAL_2
DED_REMB_CURProduction: MMS-2014 - Deduction Reimbursement Currency OIUREP_MMS_2014_DED_REMB_CURCUKY5TCURCWAERS
TAX_AMTProduction: MMS-2014 - Tax Amount OIUREP_MMS_2014_TAX_AMTCURR15(2) OIUCM_CURRENCY_15_DECIMAL_2
TAX_CURProduction: MMS-2014 - Tax Currency OIUREP_MMS_2014_TAX_CURCUKY5TCURCWAERS
TAX_REMB_AMTProduction: MMS-2014 - Tax Reimbursement Amount OIUREP_MMS_2014_TAX_REMB_AMTCURR15(2) OIUCM_CURRENCY_15_DECIMAL_2
TAX_REMB_CURProduction: MMS-2014 - Tax Reimbursement Currency OIUREP_MMS_2014_TAX_REMB_CURCUKY5TCURCWAERS
MMS_ROY_QYProduction: MMS-2014 - MMS Royalty Quantity OIUREP_MMS_2014_MMS_ROY_QYQUAN13(3) OIUCM_QUANTITY_13_DECIMAL_3
MMS_ROY_QY_UProduction: MMS-2014 - MMS Royalty Quantity Unit OIUREP_MMS_2014_MMS_ROY_QY_UUNIT3T006CUNITMEINS
MMS_PS_BASE_QYPressure Base OIU_PS_BASEQUAN13(3) MENGE
MMS_PS_BASE_QY_UPressure Base Unit OIU_PS_BASE_UUNIT3T006CUNITMEINS
MMS_ROY_AMTMMS-2014 - JE Offset Amount OIUREP_MMS_2014_MMS_ROY_AMTCURR15(2) OIUCM_CURRENCY_15_DECIMAL_2
MMS_ROY_CURMMS-2014 - JE Offset Currency OIUREP_MMS_2014_MMS_ROY_CURCUKY5TCURCWAERS
MMS_SA_QYProduction: MMS-2014 - MMS Sales Quantity OIUREP_MMS_2014_MMS_SA_QYQUAN13(3) OIUCM_QUANTITY_13_DECIMAL_3
MMS_SA_QY_UProduction: MMS-2014 - MMS Sales Quantity Unit OIUREP_MMS_2014_MMS_SA_QY_UUNIT3T006CUNITMEINS
MMS_SA_AMTProduction: MMS-2014 - MMS Sales Amount OIUREP_MMS_2014_MMS_SA_AMTCURR15(2) OIUCM_CURRENCY_15_DECIMAL_2
MMS_SA_CURProduction: MMS-2014 - MMS Sales Currency OIUREP_MMS_2014_MMS_SA_CURCUKY5TCURCWAERS
SUSPEND_RSN_CDSuspense Reason Code OIU_SUSP_CDCHAR3OIU_CM_SUSPOIU_SUSP_CD
ADJ_CDProduction: MMS-2014 - Adjustment Reason Code OIUREP_MMS_2014_ADJ_CDNUMC2OIUREP_MMS_2014_ADJ_CD
ADJ_SA_QYProduction: MMS-2014 - Adjusted Sales Quantity OIUREP_MMS_2014_ADJ_SA_QYQUAN13(3) OIUCM_QUANTITY_13_DECIMAL_3
ADJ_SA_QY_UProduction: MMS-2014 - Adjusted Sales Quantity Unit OIUREP_MMS_2014_ADJ_SA_QY_UUNIT3T006CUNITMEINS
ADJ_ROY_QYProduction: MMS-2014 - Adjusted Royalty Quantity OIUREP_MMS_2014_ADJ_ROY_QYQUAN13(3) OIUCM_QUANTITY_13_DECIMAL_3
ADJ_ROY_QY_UProduction: MMS-2014 - Adjusted Royalty Quantity Unit OIUREP_MMS_2014_ADJ_ROY_QY_UUNIT3T006CUNITMEINS
ADJ_BTU_QYProduction: MMS-2014 - Adjusted BTU Quantity OIUREP_MMS_2014_ADJ_BTU_QYQUAN13(3) OIUCM_QUANTITY_13_DECIMAL_3
ADJ_BTU_QY_UProduction: MMS-2014 - Adjusted BTU Quantity Unit OIUREP_MMS_2014_ADJ_BTU_QY_UUNIT3T006CUNITMEINS
GAS_MMBTU_QYProduction: MMS-2014 - Gas MMBTU Qty OIUREP_MMS_2014_GAS_MMBTU_QYQUAN13(3) OIUCM_QUANTITY_13_DECIMAL_3
GAS_MMBTU_QY_UProduction: MMS-2014 - Gas MMBTU Qty Unit OIUREP_MMS_2014_GAS_MMBTU_QY_UUNIT3T006CUNITMEINS
HISTORY_FLProduction: MMS-2014 - History Flag OIUREP_MMS_2014_HISTORY_FLCHAR1YESNO
REPORT_PART_FACProduction: MMS-2014 - Report Participation Factor OIUREP_MMS_2014_RPT_PART_FACDEC9(8)
TRIBAL_ALLOT_CDProduction: MMS-2014 - Tribal/Allottee Code OIUREP_MMS_2014_TRIB_ALLOT_CDCHAR1OIUREP_MMS_2014_TRIB_ALLOT_CD
COMP_ROY_FLProduction: MMS-2014 - Compensatory Royalty Flag OIUREP_MMS_2014_COMP_ROY_FLCHAR1YESNO
ROY_IN_KIND_FLProduction: MMS-2014 - Royalty In Kind Flag OIUREP_MMS_2014_ROY_IN_KIND_FLCHAR1YESNO
PAY_CDProduction: MMS-2014 - Payment Code OIUREP_MMS_2014_PAY_CDCHAR2
EXTRACTED_FLMMS-2014: Extracted OIUREP_MMS_2014_EXTRACTED_FLCHAR1YESNO
EXTRACT_RUN_TYPEDefines whether the run is direct pay or not OIUREP_MMS_2014_RUN_TYPECHAR1OIUREP_RUN_TYPE
MANUAL_CREATE_FL Manually Created Entry Flag0
OIU_CRUSERName of Person who Created the Object ERNAMCHAR12USNAM
OIU_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPSDEC15TZNTSTMPS
CHANGE_USERName of Person Who Changed Object AENAMCHAR12USNAM
CHANGE_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPSDEC15TZNTSTMPS

Key field Non-key field



How do I retrieve data from SAP structure ROIUREP_MMS_2014_RT_NON using ABAP code?

As ROIUREP_MMS_2014_RT_NON is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on ROIUREP_MMS_2014_RT_NON as there is no data to select.

How to access SAP table ROIUREP_MMS_2014_RT_NON

Within an ECC or HANA version of SAP you can also view further information about ROIUREP_MMS_2014_RT_NON and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!