ROIUREP_WY_M2_D SAP (Structure for the Detailed part of M2 Report (WY Royalty)) Structure details

Dictionary Type: Structure
Description: Structure for the Detailed part of M2 Report (WY Royalty)




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




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

ROIUREP_WY_M2_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 M2 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_M2_D TYPE ROIUREP_WY_M2_D.

The ROIUREP_WY_M2_D table consists of various fields, each holding specific information or linking keys about Structure for the Detailed part of M2 Report (WY Royalty) data available in SAP. These include AGENCY_LEASE (Agency assigned Lease No.), AGENCY (Agency for Reporting), REP_IND (Indicator (Current or Amended) Report), YEAR_MONTH (Reporting Year and Month).. 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_M2_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
AGENCY_LEASEAgency assigned Lease No. OIUREP_AGENCY_LEASECHAR15OIUREP_AGENCY_LEASE
AGENCYAgency for Reporting OIUREP_ROY_AGENCYCHAR3CHAR3OIUREP_AGENCYOIUREP_SH_ROY_AGY
REP_INDIndicator (Current or Amended) Report OIUREP_REPORT_INDCHAR1OIUREP_REPORT_IND
YEAR_MONTHReporting Year and Month OIUREP_RPT_YYYYMMNUMC6OIUREP_RPT_YYYYMM
YEAR_MONTH_AMNDYear and Month for Amended Reports OIUREP_AMND_YYYYMMNUMC6OIUREP_RPT_YYYYMM
OIL_GAS_INDOil and Gas Indicator OIUREP_OIL_GAS_INDCHAR1OIUREP_OIL_GAS_INDOIUREP_OIL_GAS_IND
ST_ROY_PEROIUH_CHAR5 OIUH_CHAR5CHAR5CHAR5
OPR_VOL_W1Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
OPR_VAL_W1Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
OPR_ALL_LSE_W1Lease Allocation Factor OIUREP_LSE_ALLOC_FACDEC9(8) OIUREP_LSE_ALLOC_FAC
OPR_SLS_PPU_W1Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
OPR_VOL_BY_PRD_W1Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
OPR_VAL_BY_PRD_W1Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
OPR_ROY_AMT_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_VAL_S1Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
OPR_ALL_LSE_S1Lease Allocation Factor OIUREP_LSE_ALLOC_FACDEC9(8) OIUREP_LSE_ALLOC_FAC
OPR_SLS_PPU_S1Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
OPR_VOL_BY_PRD_S1Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
OPR_VAL_BY_PRD_S1Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
OPR_ROY_AMT_S1Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
OSD_VOL_W1Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
OSD_VAL_W1Value OIUY1_STD_VALDEC13(2)
OSD_ALL_LSE_W1Lease Allocation Factor OIUREP_LSE_ALLOC_FACDEC9(8) OIUREP_LSE_ALLOC_FAC
OSD_SLS_PPU_W1Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
OSD_VOL_BY_PRD_W1Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
OSD_VAL_BY_PRD_W1Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
OSD_ROY_AMT_W1Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
OSD_VOL_S1Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
OSD_VAL_S1Value OIUY1_STD_VALDEC13(2)
OSD_ALL_LSE_S1Lease Allocation Factor OIUREP_LSE_ALLOC_FACDEC9(8) OIUREP_LSE_ALLOC_FAC
OSD_SLS_PPU_S1Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
OSD_VOL_BY_PRD_S1Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
OSD_VAL_BY_PRD_S1Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
OSD_ROY_AMT_S1Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
CPR_VOL_W2Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
CPR_VAL_W2Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
CPR_ALL_LSE_W2Lease Allocation Factor OIUREP_LSE_ALLOC_FACDEC9(8) OIUREP_LSE_ALLOC_FAC
CPR_SLS_PPU_W2Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
CPR_VOL_BY_PRD_W2Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
CPR_VAL_BY_PRD_W2Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
CPR_ROY_AMT_W2Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
CPR_VOL_S2Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
CPR_VAL_S2Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
CPR_ALL_LSE_S2Lease Allocation Factor OIUREP_LSE_ALLOC_FACDEC9(8) OIUREP_LSE_ALLOC_FAC
CPR_SLS_PPU_S2Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
CPR_VOL_BY_PRD_S2Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
CPR_VAL_BY_PRD_S2Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
CPR_ROY_AMT_S2Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
CSD_VOL_W2Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
CSD_VAL_W2Value OIUY1_STD_VALDEC13(2)
CSD_ALL_LSE_W2Lease Allocation Factor OIUREP_LSE_ALLOC_FACDEC9(8) OIUREP_LSE_ALLOC_FAC
CSD_SLS_PPU_W2Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
CSD_VOL_BY_PRD_W2Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
CSD_VAL_BY_PRD_W2Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
CSD_ROY_AMT_W2Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
CSD_VOL_S2Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
CSD_VAL_S2Value OIUY1_STD_VALDEC13(2)
CSD_ALL_LSE_S2Lease Allocation Factor OIUREP_LSE_ALLOC_FACDEC9(8) OIUREP_LSE_ALLOC_FAC
CSD_SLS_PPU_S2Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
CSD_VOL_BY_PRD_S2Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
CSD_VAL_BY_PRD_S2Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
CSD_ROY_AMT_S2Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
GPR_VOL_W3Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
GPR_VAL_W3Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
GPR_ALL_LSE_W3Lease Allocation Factor OIUREP_LSE_ALLOC_FACDEC9(8) OIUREP_LSE_ALLOC_FAC
GPR_SLS_PPU_W3Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
GPR_VOL_BY_PRD_W3Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
GPR_VAL_BY_PRD_W3Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
GPR_ROY_AMT_W3Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
GPR_VOL_S3Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
GPR_VAL_S3Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
GPR_ALL_LSE_S3Lease Allocation Factor OIUREP_LSE_ALLOC_FACDEC9(8) OIUREP_LSE_ALLOC_FAC
GPR_SLS_PPU_S3Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
GPR_VOL_BY_PRD_S3Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
GPR_VAL_BY_PRD_S3Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
GPR_ROY_AMT_S3Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
GSD_VOL_W3Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
GSD_VAL_W3Value OIUY1_STD_VALDEC13(2)
GSD_ALL_LSE_W3Lease Allocation Factor OIUREP_LSE_ALLOC_FACDEC9(8) OIUREP_LSE_ALLOC_FAC
GSD_SLS_PPU_W3Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
GSD_VOL_BY_PRD_W3Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
GSD_VAL_BY_PRD_W3Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
GSD_ROY_AMT_W3Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
GSD_VOL_S3Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
GSD_VAL_S3Value OIUY1_STD_VALDEC13(2)
GSD_ALL_LSE_S3Lease Allocation Factor OIUREP_LSE_ALLOC_FACDEC9(8) OIUREP_LSE_ALLOC_FAC
GSD_SLS_PPU_S3Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
GSD_VOL_BY_PRD_S3Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
GSD_VAL_BY_PRD_S3Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
GSD_ROY_AMT_S3Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
PSD_VOL_W4Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
PSD_VAL_W4Value OIUY1_STD_VALDEC13(2)
PSD_ALL_LSE_W4Lease Allocation Factor OIUREP_LSE_ALLOC_FACDEC9(8) OIUREP_LSE_ALLOC_FAC
PSD_SLS_PPU_W4Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
PSD_VOL_BY_PRD_W4Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
PSD_VAL_BY_PRD_W4Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
PSD_ROY_AMT_W4Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
PSD_VOL_S4Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
PSD_VAL_S4Value OIUY1_STD_VALDEC13(2)
PSD_ALL_LSE_S4Lease Allocation Factor OIUREP_LSE_ALLOC_FACDEC9(8) OIUREP_LSE_ALLOC_FAC
PSD_SLS_PPU_S4Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
PSD_VOL_BY_PRD_S4Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
PSD_VAL_BY_PRD_S4Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
PSD_ROY_AMT_S4Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
BSD_VOL_W5Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
BSD_VAL_W5Value OIUY1_STD_VALDEC13(2)
BSD_ALL_LSE_W5Lease Allocation Factor OIUREP_LSE_ALLOC_FACDEC9(8) OIUREP_LSE_ALLOC_FAC
BSD_SLS_PPU_W5Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
BSD_VOL_BY_PRD_W5Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
BSD_VAL_BY_PRD_W5Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
BSD_ROY_AMT_W5Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
BSD_VOL_S5Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
BSD_VAL_S5Value OIUY1_STD_VALDEC13(2)
BSD_ALL_LSE_S5Lease Allocation Factor OIUREP_LSE_ALLOC_FACDEC9(8) OIUREP_LSE_ALLOC_FAC
BSD_SLS_PPU_S5Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
BSD_VOL_BY_PRD_S5Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
BSD_VAL_BY_PRD_S5Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
BSD_ROY_AMT_S5Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
SSD_VOL_W6Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
SSD_VAL_W6Value OIUY1_STD_VALDEC13(2)
SSD_ALL_LSE_W6Lease Allocation Factor OIUREP_LSE_ALLOC_FACDEC9(8) OIUREP_LSE_ALLOC_FAC
SSD_SLS_PPU_W6Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
SSD_VOL_BY_PRD_W6Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
SSD_VAL_BY_PRD_W6Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
SSD_ROY_AMT_W6Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
SSD_VOL_S6Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
SSD_VAL_S6Value OIUY1_STD_VALDEC13(2)
SSD_ALL_LSE_S6Lease Allocation Factor OIUREP_LSE_ALLOC_FACDEC9(8) OIUREP_LSE_ALLOC_FAC
SSD_SLS_PPU_S6Generic Price Per Unit for Oil/Gas OIUREP_OIL_PPU_W_01DEC5(2) OIUH_DEC5_2
SSD_VOL_BY_PRD_S6Generic Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
SSD_VAL_BY_PRD_S6Generic Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
SSD_ROY_AMT_S6Generic State'sfor Oil/Gas Percentage OIUREP_OIL_PROD_W_01_ROY_PERDEC11(2) OIUH_DEC11_2
COUNTY_NMSecondary Geographical Location Description OIU_SEC_GEO_DESCCHAR30CHAR30

Key field Non-key field



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

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

How to access SAP table ROIUREP_WY_M2_D

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