ROIUREP_WY_M1_D SAP (Structure for the Detailed part of M1 report (WY Royalty)) Structure details

Dictionary Type: Structure
Description: Structure for the Detailed part of M1 report (WY Royalty)




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




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

ROIUREP_WY_M1_D 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 "Structure for the Detailed part of M1 report (WY Royalty)" 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_WY_M1_D TYPE ROIUREP_WY_M1_D.

The ROIUREP_WY_M1_D table consists of various fields, each holding specific information or linking keys about Structure for the Detailed part of M1 report (WY Royalty) data available in SAP. These include AGENCY (Agency for Reporting), AGENCY_PD_CD (Agency defined product code), YEAR_MONTH (Reporting Year and Month), YEAR_MONTH_AMND (Year and Month for Amended Reports).. 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_WY_M1_D 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
FIELDField ID OIU_FIELDIDCHAR10Assigned to domainALPHAOIU_FIELDIDOIU_FIELD
AGENCYAgency for Reporting OIUREP_ROY_AGENCYCHAR3CHAR3OIUREP_AGENCYOIUREP_SH_ROY_AGY
AGENCY_PD_CDAgency defined product code OIUREP_AGENCY_PDCDCHAR3OIUREP_AGENCY_PDCD
YEAR_MONTHReporting Year and Month OIUREP_RPT_YYYYMMNUMC6OIUREP_RPT_YYYYMM
YEAR_MONTH_AMNDYear and Month for Amended Reports OIUREP_AMND_YYYYMMNUMC6OIUREP_RPT_YYYYMM
AGENCY_LEASEAgency assigned Lease No. OIUREP_AGENCY_LEASECHAR15OIUREP_AGENCY_LEASE
OIL_GAS_INDOil and Gas Indicator OIUREP_OIL_GAS_INDCHAR1OIUREP_OIL_GAS_INDOIUREP_OIL_GAS_IND
OPR_VOL_W1Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
OPR_PPU_W1Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
OPR_VAL_W1Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
OPR_ROY_PER_W1Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
OPR_VOL_S1Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
OPR_PPU_S1Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
OPR_VAL_S1Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
OPR_ROY_PER_S1Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
OSLD_VOL_W1Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
OSLD_PPU_W1Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
OSLD_VAL_W1Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
OSLD_ROY_PER_W1Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
OSLD_VOL_S1Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
OSLD_PPU_S1Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
OSLD_VAL_S1Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
OSLD_ROY_PER_S1Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
CON_PRD_VOL_W2Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
CON_PRD_PPU_W2Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
CON_PRD_VAL_W2Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
CON_PRD_ROY_PER_W2Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
CON_PRD_VOL_S2Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
CON_PRD_PPU_S2Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
CON_PRD_VAL_S2Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
CON_PRD_ROY_PER_S2Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
CON_SLD_VOL_W2Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
CON_SLD_PPU_W2Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
CON_SLD_VAL_W2Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
CON_SLD_ROY_PER_W2Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
CON_SLD_VOL_S2Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
CON_SLD_PPU_S2Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
CON_SLD_VAL_S2Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
CON_SLD_ROY_PER_S2Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
GAS_PRD_VOL_W3Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
GAS_PRD_PPU_W3Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
GAS_PRD_VAL_W3Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
GAS_PRD_ROY_PER_W3Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
GAS_PRD_VOL_S3Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
GAS_PRD_PPU_S3Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
GAS_PRD_VAL_S3Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
GAS_PRD_ROY_PER_S3Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
GAS_SLD_VOL_W3Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
GAS_SLD_PPU_W3Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
GAS_SLD_VAL_W3Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
GAS_SLD_ROY_PER_W3Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
GAS_SLD_VOL_S3Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
GAS_SLD_PPU_S3Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
GAS_SLD_VAL_S3Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
GAS_SLD_ROY_PER_S3Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
PEN_SLD_VOL_W4Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
PEN_SLD_PPU_W4Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
PEN_SLD_VAL_W4Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
PEN_SLD_ROY_PER_W4Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
PEN_SLD_VOL_S4Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
PEN_SLD_PPU_S4Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
PEN_SLD_VAL_S4Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
PEN_SLD_ROY_PER_S4Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
BUT_SLD_VOL_W5Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
BUT_SLD_PPU_W5Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
BUT_SLD_VAL_W5Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
BUT_SLD_ROY_PER_W5Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
BUT_SLD_VOL_S5Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
BUT_SLD_PPU_S5Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
BUT_SLD_VAL_S5Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
BUT_SLD_ROY_PER_S5Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
SUL_SLD_VOL_W6Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
SUL_SLD_PPU_W6Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
SUL_SLD_VAL_W6Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
SUL_SLD_ROY_PER_W6Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
SUL_SLD_VOL_S6Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
SUL_SLD_PPU_S6Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
SUL_SLD_VAL_S6Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
SUL_SLD_ROY_PER_S6Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
REP_INDIndicator (Current or Amended) Report OIUREP_REPORT_INDCHAR1OIUREP_REPORT_IND
ST_ROY_PEROIUH_CHAR3 OIUH_CHAR3CHAR3CHAR3
COUNTY_NMSecondary Geographical Location Description OIU_SEC_GEO_DESCCHAR30CHAR30

Key field Non-key field



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

As ROIUREP_WY_M1_D 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_WY_M1_D as there is no data to select.

How to access SAP table ROIUREP_WY_M1_D

Within an ECC or HANA version of SAP you can also view further information about ROIUREP_WY_M1_D 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!