ROIUREP_MASTER SAP (Regulatory Reporting Master Data structure) Structure details
Description: Regulatory Reporting Master Data structure
Related tables to ROIUREP_MASTER
Access table ROIUREP_MASTER
Structure field list including key, data, relationships and ABAP select examples
ROIUREP_MASTER 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 "Regulatory Reporting Master Data structure" 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_MASTER TYPE ROIUREP_MASTER.
The ROIUREP_MASTER table consists of various fields, each holding specific information or linking keys about Regulatory Reporting Master Data structure data available in SAP. These include MANDT (Client), AGENCY (Agency for Reporting), REP_NAME (Regulatory Report Name), WL_NO (Well ID 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_MASTER 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
AGENCY | Agency for Reporting | OIUREP_AGENCY | CHAR | 3 | OIUREP_REPORTS | CHAR3 | OIUREP_AGENCY | ||
REP_NAME | Regulatory Report Name | OIU_REP_REPNAME | CHAR | 40 | OIUREP_REPORTS | PROGNAME | OIUREP_REP_NAME | ||
WL_NO | Well ID number | OIU_WL_NO | CHAR | 15 | OIU_PR_WELL | ALPHA | OIU_WL_NO | OIU_WELL | H_OIU_PR_WELL |
WC_NO | Well Completion Number | OIU_WC_NO | CHAR | 5 | OIU_PR_WC | ALPHA | OIU_WC_NO | OIU_WC | H_OIU_PR_WC |
EFF_FROM_DT | Effective from date | OIU_EFF_FROM_DT | DATS | 8 | DATUM | OIU_EFD | |||
EFF_TO_DT | Effective To Date | OIU_EFF_TO_DT | DATS | 8 | DATUM | OIU_ETD | |||
EFF_TO_CD | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC | 15 | TZNTSTMPS | ||||
USERID | User Name | SYUNAME | CHAR | 12 | SYCHAR12 | ||||
DIST_NO | District number for Texas Reg ID | OIU_REP_DIST_NO | CHAR | 3 | CHAR3 | ||||
GAS_WL_NO | Regulatory Reporting: Gas Well Number | OIUREP_GAS_WL_NO | CHAR | 6 | |||||
CMGL_PRMT_NO | Commingled Permit Number | OIUREP_CMGL_PRMT_NO | CHAR | 8 | CHAR8 | ||||
RPT_CD | Texas Report Code | OIUREP_RPT_CD | CHAR | 1 | CHAR1 | ||||
RRC_GAS_WL_NO | Texas Railroad Commission Gas Well number | OIUREP_RRCGAS_WL_NO | CHAR | 16 | CHAR16 | ||||
RRC_OIL_NO | Reg Reporting - TX H-10 Lease Number | OIUREP_TX_LEASE_NO | CHAR | 5 | ALPHA | OIUREP_TX_LEASE_NO | |||
RRC_SP_DSC_TX | 30 Characters | CHAR30 | CHAR | 30 | CHAR30 | ||||
UNITZ_FLG | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
GAS_RRC_ID_NO | Regulatory Reporting: Gas RRC ID | OIUREP_TX_GAS_RRC_ID_NO | NUMC | 6 | |||||
P1B_RRC_OIL_LSE | Texas P-1B RRC Oil Lease | OIUREP_TX_P1B_RRC_OIL_LSE | NUMC | 5 | |||||
PARTIALLY_UNTZ | Texas P-1B Partially Unitized | OIUREP_TX_PARTIALLY_UNITIZED | CHAR | 1 | |||||
SPECIAL_PROJECT | Texas P-1B Special Project | OIUREP_TX_SPECIAL_PROJECT | CHAR | 6 | |||||
DRILL_PRMT_NO | Regulatory Reporting: Texas Drilling Permit Number | OIUREP_TX_DRILL_PERMIT | CHAR | 6 | ALPHA | OIUREP_TX_DRILL_PERMIT | |||
OPER_LSE_NO | Operator Lease Number (internal id) | OIUREP_OPER_LSE_NO | CHAR | 20 | |||||
LSE_NO | Lease Number (Externally-Issued ID) | OIUREP_LSE_NO | CHAR | 11 | |||||
AGY_LSE_NO | Agency Lease Number (externally issued id) | OIUREP_AGY_LSE_NO | CHAR | 25 | |||||
MMS_ACT_CD | MMS Well Status Action Code (OGOR-A) | OIUREP_MMS_ACTION_CD | CHAR | 1 | OIUREP_MMS_ACTION_CD | ||||
MMS_GRP_API_WL | API well number group | OIUREP_WLAPI_GRP | CHAR | 12 | CHRNM | OIU_WLAPI | OIU_API_NO | ||
MMS_GRP_API_WC | API well completion number group | OIUREP_API_WC_NO_GRP | CHAR | 3 | OIU_API_WC_NO | ||||
OPER_WELL_NO | OGOR-A Operator Well Number | OIUREP_OGA_OPER_WELL_NO | CHAR | 15 | |||||
MMS_WELL_STAT | MMS Well Status Code (OGOR-A) | OIUREP_WELL_STAT | CHAR | 2 | OIUREP_WELL_STAT | ||||
MMS_REAS_CD | MMS Well Status Reason Code (OGOR-A) | OIUREP_MMS_REAS_CD | CHAR | 2 | OIUREP_MMS_REAS_CD | ||||
OP_WL_NO | Operator Well number (9-Character, NM) | OIU_REP_OP_WL_NO | CHAR | 9 | |||||
NM_POOL_CD | Pool Code (Reg ID) | OIUREP_NM_POOL | CHAR | 6 | |||||
NM_ST_PR_NO | NM State Property Number | OIUREP_PR_NO | NUMC | 6 | |||||
UNIT_NO | Unit No (NM Reg ID) | OIUREP_UNIT_NO | CHAR | 1 | |||||
OGRID_NO | OGRID number | OIUREP_OGRID_NO | NUMC | 6 | |||||
H2O_POD_NO | Reg.Reporting New Mexico - H2O POD Code | OIUREP_NM_H2O_POD_CD | CHAR | 7 | |||||
CA_H2O_SRCE_CD | Regulatory Rep: California H2O Source Code | OIUREP_CA_H2O_SRCE_CD | CHAR | 1 | |||||
CA_H2O_DISP_CD | Regulatory Rep: California H2O Disposition Code | OIUREP_CA_H2O_DISP_CD | CHAR | 1 | |||||
FIELD_NO | Reg. ID specific field number - override | OIUREP_FIELD_NO | CHAR | 8 | CHAR8 | ||||
UNIT_NUMBER | Unit Number (WY Form 2) | OIUREP_UNIT_NUM | CHAR | 11 | |||||
INJ_SRCE_CD | Injection Source | OIUREP_INJ_SRCE_CD | CHAR | 1 | |||||
ALLOW_QTY | Daily production allowable quantity | OIUREP_ALLOW_QTY | QUAN | 13(3) | MENGE | ||||
ALLOW_UOM | Unit of measure of production allowable | OIUREP_ALLOW_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
AGY_WELL_ID | Agency well ID | OIUREP_AGY_WELL_ID | CHAR | 6 | |||||
START_CUM_ALLOW | Starting cummulative over/under allowance | OIUREP_START_CUM_ALLOW | QUAN | 13(3) | OIUCM_QUANTITY_13_DECIMAL_3 | ||||
ND_WELL_NAME | Well Description | OIU_WL_DE_CONV | CHAR | 35 | OIUNM | OIU_TEXT35_CONV | |||
ND_WELL_NO | Well ID number | OIU_WL_NO | CHAR | 15 | Assigned to domain | ALPHA | OIU_WL_NO | OIU_WELL | H_OIU_PR_WELL |
ND_WL_FILE_NO | Regulatory Reporting - North Dakota Well File Number | OIUREP_ND_WELL_FILE_NO | CHAR | 6 | |||||
UIC_NO | Reg. Reporting - ND Undergound Injection Control Number | OIUREP_ND_UIC_NO | CHAR | 11 | |||||
ST_RESVR_CD | Regulatory Reporting: Wyoming Form 2 Reservoir Code | OIUREP_WY_RESERVOIR_CD | CHAR | 4 | |||||
RESVR_CD | Regulatory Reporting: Wyoming Form 2 Reservoir Code | OIUREP_WY_RESERVOIR_CD | CHAR | 4 | |||||
PROJ_CD | Regulatory Reporting: Wyoming Form 2 Project Code | OIUREP_WY_PROJECT_CD | CHAR | 3 | |||||
CONS_DIST_NO | Regulatory Reporting - Conservation District Number | OIUREP_CONS_DIST_NO | CHAR | 4 | |||||
AREA_CD | Regulatory Reporting - Area Code | OIUREP_AREA_CD | CHAR | 1 | |||||
WL_SERIAL_NO | Well Serial Number | OIUREP_WL_SER_NO | CHAR | 6 | |||||
COMNG_FAC_NO | Regulatory Reporting - Commingling Facility Number | OIUREP_COMM_FAC_NO | CHAR | 6 | |||||
LUW_NO | Regulatory Reporting - Lease Unit / Well No | OIUREP_LUW_NO | CHAR | 6 | |||||
INAC_STATUS_CD | Inactive Status Code | OIUREP_INAC_STATUS_CD | CHAR | 2 | |||||
INAC_FUTURE_CD | Inactive Future Code | OIUREP_INAC_FUTURE_CD | CHAR | 4 | |||||
INAC_ABANDON | Inactive Abandon Date | OIUREP_INAC_ABANDON | DATS | 8 | |||||
SPLIT_GUID | GUID in 'CHAR' Format in Uppercase | GUID_32 | CHAR | 32 | SYSUUID_C | ||||
INACTIVE_FLAG | Report on inactive well report only | OIUREP_INACTIVE_FLAG | CHAR | 1 | XFELD | ||||
OVERRIDE_GRP | Override Group | OIUREP_OVERRIDE_GRP | CHAR | 5 | |||||
ND_PIPE_OR_TRUCK | Regulatory Reporting - North Dakota Pipeline or Truck | OIUREP_ND_PIPE_OR_TRUCK | CHAR | 1 | |||||
ND_CTB_NO | Regulatory Reporting - North Dakorta Central Tank Battery | OIUREP_ND_CTB_NO | CHAR | 11 | |||||
FLPT_CD | Regulatory Reporting - Field Plant Code | OIUREP_FLPT_CD | CHAR | 4 | |||||
OIU_PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | OIU_PRI_GEO_LOC | CHAR | 2 | Assigned to domain | OIU_PRI_GEO_LOC | OIU_PRI_GEO_LOC | ||
ADD_HDR1 | Additional Master Data-Header Data | OIU_HDR_DATA | CHAR | 35 | |||||
ADD_HDR2 | Additional Master Data-Header Data | OIU_HDR_DATA | CHAR | 35 | |||||
ADD_DTL1 | Additional Master Data | OIU_ADD_DATA2 | CHAR | 15 | |||||
ADD_DTL2 | Additional Master Data | OIU_ADD_DATA3 | CHAR | 30 | |||||
ADD_DTL3 | Additional Master Data | OIU_ADD_DATA2 | CHAR | 15 | |||||
ADD_DTL4 | Additional Master Data | OIU_ADD_DATA3 | CHAR | 30 | |||||
ADD_DTL5 | Additional Master Data | OIU_ADD_DATA1 | CHAR | 10 | |||||
ADD_DTL6 | Additional Master Data | OIU_ADD_DATA1 | CHAR | 10 | |||||
ADD_DTL7 | Additional Master Data | OIU_ADD_DATA1 | CHAR | 10 | |||||
ADD_DTL8 | Additional Master Data | OIU_ADD_DATA1 | CHAR | 10 | |||||
ADD_DTL9 | Additional Master Data | OIU_ADD_DATA1 | CHAR | 10 | |||||
ADD_DTL10 | Additional Master Data | OIU_ADD_DATA1 | CHAR | 10 |
Key field | Non-key field |
How do I retrieve data from SAP structure ROIUREP_MASTER using ABAP code?
As ROIUREP_MASTER 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_MASTER as there is no data to select.How to access SAP table ROIUREP_MASTER
Within an ECC or HANA version of SAP you can also view further information about ROIUREP_MASTER and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects