ROIUREP_OK_CLO109_D SAP (Structure for the Detail Part of CLO-109 Report (OK Royalty)) Structure details

Dictionary Type: Structure
Description: Structure for the Detail Part of CLO-109 Report (OK Royalty)




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




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

ROIUREP_OK_CLO109_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 Detail Part of CLO-109 Report (OK 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_OK_CLO109_D TYPE ROIUREP_OK_CLO109_D.

The ROIUREP_OK_CLO109_D table consists of various fields, each holding specific information or linking keys about Structure for the Detail Part of CLO-109 Report (OK Royalty) data available in SAP. These include AGENCY_LEASE (Agency assigned Lease No.), REP_IND (Indicator (Current or Amended) Report), YEAR_MONTH (Reporting Year and Month), YR_MON_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_OK_CLO109_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_FIELDIDCHAR10OIU_PR_FIELDALPHAOIU_FIELDIDOIU_FIELD
AGENCY_LEASEAgency assigned Lease No. OIUREP_AGENCY_LEASECHAR15OIUREP_AGENCY_LEASE
REP_INDIndicator (Current or Amended) Report OIUREP_REPORT_INDCHAR1OIUREP_REPORT_IND
YEAR_MONTHReporting Year and Month OIUREP_RPT_YYYYMMNUMC6OIUREP_RPT_YYYYMM
YR_MON_AMNDYear and Month for Amended Reports OIUREP_AMND_YYYYMMNUMC6OIUREP_RPT_YYYYMM
AGENCYAgency for Reporting OIUREP_ROY_AGENCYCHAR3CHAR3OIUREP_AGENCYOIUREP_SH_ROY_AGY
GVOL_PRD_WGeneric Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
GVOL_PRD_SGeneric Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
GVAL_DUE_LEASE_WGeneric Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
GVAL_DUE_LEASE_SGeneric Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
BUVAL_DUE_LEASE_WGeneric Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
BUVAL_DUE_LEASE_SGeneric Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
RESG_VOL_SLD_WGeneric Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
RESG_VOL_SLD_SGeneric Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
CRTPER_LEASE_PR_WOIUH_CHAR5 OIUH_CHAR5CHAR5CHAR5
CRTPER_LEASE_PR_SOIUH_CHAR5 OIUH_CHAR5CHAR5CHAR5
PRS_GAS_PRICE_WOIUH_CHAR8 OIUH_CHAR8CHAR8CHAR8
PRS_GAS_PRICE_SOIUH_CHAR8 OIUH_CHAR8CHAR8CHAR8
RESVAL_DUE_LEASE_WGeneric Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
RESVAL_DUE_LEASE_SGeneric Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
TOTVAL_PRS_G_SLD_WGeneric Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
TOTVAL_PRS_G_SLD_SGeneric Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
ADJUST_LN15_WGeneric Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
ADJUST_LN15_SGeneric Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
ADJVAL_PRS_G_WGeneric Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
ADJVAL_PRS_G_SGeneric Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
ROYINTPER_PRS_G_WOIUH_CHAR10 OIUH_CHAR10CHAR10CHAR10H_OIU_RV_CT
ROYINTPER_PRS_G_SOIUH_CHAR10 OIUH_CHAR10CHAR10CHAR10H_OIU_RV_CT
ROYVAL_PRS_G_WGeneric Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
ROYVAL_PRS_G_SGeneric Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
TOTVOL_DRY_G_WGeneric Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
TOTVOL_DRY_G_SGeneric Volume for Oil/Gas OIUREP_PROD_W_01_VOLDEC13(2) OIUH_DEC13_2
DRY_G_RATE_WOIUH_CHAR8 OIUH_CHAR8CHAR8CHAR8
DRY_G_RATE_SOIUH_CHAR8 OIUH_CHAR8CHAR8CHAR8
TOTVAL_DRY_G_WGeneric Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
TOTVAL_DRY_G_SGeneric Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
ADJUST_LN19_WGeneric Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
ADJUST_LN19_SGeneric Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
ADJVAL_DRY_G_WGeneric Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
ADJVAL_DRY_G_SGeneric Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
ROYINTPER_DRY_G_WOIUH_CHAR10 OIUH_CHAR10CHAR10CHAR10H_OIU_RV_CT
ROYINTPER_DRY_G_SOIUH_CHAR10 OIUH_CHAR10CHAR10CHAR10H_OIU_RV_CT
ROYVAL_DRY_G_SGeneric Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
ROYVAL_DRY_G_WGeneric Value for Oil/Gas OIUREP_PROD_W_01_VALUEDEC11(2) OIUH_DEC11_2
OPR_WELLOIUH_CHAR3 OIUH_CHAR3CHAR3CHAR3
SECSection Number OIUY1_SECTION_NOCHAR6CHAR6
TWPTownship number OIU_TWP_NOCHAR3CHAR3
RGERGE OIUY1_RGECHAR3CHAR3
SEC_GEO_LOCSecondary geographic location OIU_SEC_GEO_LOCCHAR3Assigned to domainOIU_SEC_GEO_LOC
DESCPNAgency Lease Text OIUREP_LEASE_TEXTCHAR60CHAR60

Key field Non-key field



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

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

How to access SAP table ROIUREP_OK_CLO109_D

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