Select data from sap tables ROIUY
Display SAP table details
ROIUY1_LA_D - Details for the LA Smart Form
ROIUY1_LA_DL1 - Download structure for the LA - OIL
ROIUY1_LA_DL2 - Download structure for the LA - GAS
ROIUY1_LA_DL3 - Download structure for the LA - PP
ROIUY1_LA_H - Header structure for the LA Smart Form
ROIUY1_NM_D - Details for the NM Smart Form
ROIUY1_NM_H - Header structure for the NM Smart Form
ROIUY1_OK_DL - Oklahoma Royalty Oil and Gas Downloads
ROIUY1_ROY_DOWNLOAD - Structure for Report Data
ROIUY1_ROY_FILE - Structure for uploading royalty values from flat file
ROIUY1_ROY_TX_DOWNLOAD - Structure for Report Data
ROIUY1_TX_AM1A_D - Structure to store detail records for AM1A Report
ROIUY1_TX_AM1A_DL - Download Structure for Amendment report Oil A & M
ROIUY1_TX_AM1_D - Structure for AM1 DETAIL
ROIUY1_TX_AM1_DL - Download for A&M oil Report
ROIUY1_TX_AM2A_D - Structure to store detail records for UT2 Amendment report
ROIUY1_TX_AM2A_DL - Download structure for AM2A
ROIUY1_TX_AM2_D - Structure to store AM2 details
ROIUY1_TX_AM2_DL - Download for AM2 Current Report
ROIUY1_TX_AM3_D - Structure to store AM3 detail
ROIUY1_TX_AM3_DL - Structure to download Royalty Payment Summary
ROIUY1_TX_AM3_H - Structure to store AM3 details
ROIUY1_TX_AM_H - Structure to store the AM header.
ROIUY1_TX_GLO1A_DL - Downlaod Structure for Amendment report Oil
ROIUY1_TX_GLO1_D - Structure for GLO1 and GLO1A detail.
ROIUY1_TX_GLO1_DL - Download for GLO1 oil Current Report
ROIUY1_TX_GLO1_DS - Structure for GLO1 and GLO1A Smartform.
ROIUY1_TX_GLO2A_DL - Download structure for GLO2A
ROIUY1_TX_GLO2_D - Structure to store GLO2 details
ROIUY1_TX_GLO2_DL - Download for GLO2 Gas Current Report
ROIUY1_TX_GLO2_DS - Structure to store GLO2 smartform
ROIUY1_TX_GLO3_D - Structure to store GLO3 detail
ROIUY1_TX_GLO3_DL - Structure to download Royalty Payment Summary
ROIUY1_TX_GLO3_H - Structure to store GLO3 details
ROIUY1_TX_GLO_H - Structure to store the GLO header.
ROIUY1_TX_UT1A_D - Structure to store detail records for UT1A Report
ROIUY1_TX_UT1A_DL - Downlaod Structure for Amendment report Oil
ROIUY1_TX_UT1_D - Structure to store detail records for UT1 Report
ROIUY1_TX_UT1_DL - Download for UT1 oil Report
ROIUY1_TX_UT1_H - Header Structure for UT1 Reports
ROIUY1_TX_UT2A_D - Structure to store detail records for UT2 Amendment report
ROIUY1_TX_UT2A_DL - Download structure for UT2A
ROIUY1_TX_UT2_D - Structure to store detail records for UT2 report
ROIUY1_TX_UT2_DL - Download Structure for Gas Current Report
ROIUY1_TX_UT2_H - Header Structure for UT2 Gas Reports
ROIUY1_TX_UT3_D - Structure to store detail records for UT3 Report
ROIUY1_TX_UT3_DL - Structure to download Royalty Payment Summary
ROIUY1_TX_UT3_H - Structure to store header records for UT3 Report
ROIUY1_TX_UT_T - Structure to store the footer details in UT reports
ROIUY1_UT1UT2_DOWNLOAD - Structure to download UT1/UT2 Royalty file
ROIUY1_UT3_DOWNLOAD - Structure to download UT3 Royalty file
ROIUY1_VOL_FILE - Structure for uploading volume from flat files
ROIUY1_WY_MR10_MR20_DETAIL - Detail structure for Wyoming MR10,MR20 reports
ROIUY1_WY_MR10_MR20_HEADER - Header structure for Wyoming MR10,MR20 Lease Level Reports
ROIUY3_DISPLAY_BALANCING_DTL - Roy 2.0 - TX GLO/TAMU - Balancing Report Detail ALV Struct
ROIUY3_DISPLAY_BALANCING_HDR - Roy 2.0 - TX GLO/TAMU - Balancing Report Header ALV Struct
ROIUY3_DISPLAY_PAYABLES_RECON - Roy 2.0 - Texas GLO/TAMU - Payables Recon ALV Structure
ROIUY3_DISP_TX_OOSWO_ALV_0100 - Royalty 2.0 - TX GLO OOS Write Off Display Batch ALV Struct
ROIUY3_DISP_TX_VARIANCE_RPGDT - Royalty 2.0 - Display TX GLO Gas Report Detail Variance
ROIUY3_DISP_TX_VARIANCE_RPODT - Royalty 2.0 - Display TX GLO Oil Report Detail Variance
ROIUY3_MIG_TX_ROYHST_DOC - Royalty 2.0 - TX GLO/A&M - Migration - VL Doc
ROIUY3_TX_ASU - Royalty 2.0 - TX GLO/TAMU - ASU Structure
ROIUY3_TX_ASUE_ALV_0200 - Roy 2.0 TX - Auto-Suspend Exception Screen 0200 ALV
ROIUY3_TX_ASUE_DT_KEY - Roy 2.0 TX - Auto Suspend Exception Detail Key
ROIUY3_TX_ASUE_HD_NONKEY - Roy 2.0 - Auto Suspend Exception Header Non-Key
ROIUY3_TX_ASUE_ROYTXN_EVAL - Roy 2.0 TX ASUE Roy Transaction Evaluated Fields
ROIUY3_TX_ASUE_TC_0300 - Roy 2.0 TX - Auto-Suspend Exception Screen 0300 Table Contro
ROIUY3_TX_ASU_ALV_0200 - Royalty 2.0 - TX GLO/TAMU - ASU ALV Structure
ROIUY3_TX_ASU_DT - Change Document Structure; Generated by RSSCD000
ROIUY3_TX_ASU_TC_0300 - Royalty 2.0 - TX GLO/TAMU - ASU Detail Table Control Struct
ROIUY3_TX_BAXRF_ALV_0200 - Royalty 2.0 - TX GLO/TAMU - BA Xref Screen 0200 ALV Struct
ROIUY3_TX_CTRL_ALV_0200 - Royalty 2.0 - TX GLO - Rpt Control Screen 0200 ALV Structure
ROIUY3_TX_GLO1 - Royalty 2.0 - TX GLO/TAMU - Oil Report structure
ROIUY3_TX_GLO2 - Royalty 2.0 - TX GLO/TAMU - Gas Report structure
ROIUY3_TX_GLO_GAS - Royalty 2.0 - TX GLO/TAMU - Gas Report
ROIUY3_TX_GLO_HDR - Royalty 2.0 - TX GLO/TAMU - Structure for Report Header
ROIUY3_TX_GLO_OIL - Royalty 2.0 - Texas GLO/TAMU Oil report volumes and Values
ROIUY3_TX_GLO_REPCNTRL - Royalty 2.0 - TX GLO/TAMU - Report Detail - Masters
ROIUY3_TX_LEASE_ALV_0200 - Royalty 2.0 - TX GLO - Lease Master Screen 0200 ALV Struct
ROIUY3_TX_MASTER_ALV_0200 - Royalty 2.0 - TX GLO - Master Data Screen 0200 ALV Structure
ROIUY3_TX_MASTER_KEY - Royalty 2.0 - TX GLO/TAMU - Master Data Key Fields
ROIUY3_TX_MASTER_MAINKEY - Royalty 2.0 - TX GLO/TAMU - Master Data Main Key Fields
ROIUY3_TX_MASTER_NONKEY - Royalty 2.0 - TX GLO/TAMU - Master Non-Key Fields
ROIUY3_TX_MASTER_SUBKEY - Royalty 2,.0 - TX GLO/TAMU - Master Sub Key
ROIUY3_TX_MASTER_TC_0300 - Royalty 2.0 - TX GLO - Master Data Screen 0300 TC Structure
ROIUY3_TX_NON_ROUTINE_ADJ_ALV - Roy 2.0 TX - Non-Routine Adjustment Report ALV
ROIUY3_TX_OOS_WO_ALV_0100 - Roy 2.0 - TX GLO/TAMU Out Of Statute Write Off ALV Structure
ROIUY3_TX_OWNOVR_ALV_0200 - Roy 2.0 - TX GLO - Own Lvl Rpt Override Screen 0200 ALV Stru
ROIUY3_TX_PDCXRF_ALV_0200 - Royalty 2.0 - TX GLO - Prod Disp XRef Screen 0200 ALV Struct
ROIUY3_TX_PRDT - Royalty 2.0 - TX GLO - PRA Detail (Allocation Percentage)
ROIUY3_TX_PRDT_TC - Royalty 2.0 - TX GLO/TAMU - PRA Detail Transactions Struct
ROIUY3_TX_RDCXRF_ALV_0200 - Royalty 2.0 - TX GLO - Roy Disp XRef Screen 0200 ALV Struct
ROIUY3_TX_REVTXN_KEY - Royalty 2.0 - TX GLO - Royalty Reversal Key Fields
ROIUY3_TX_ROYHST - Change Document Structure; Generated by RSSCD000
ROIUY3_TX_ROYHST_TC_0300 - Roy 2.0 - Texas GLO/TAMU History Maint Table Control Struct
ROIUY3_TX_ROYTXN_ALV_0200 - Royalty 2.0 - TX GLO User Tax Trans Screen 0200 ALV Struct
ROIUY3_TX_ROYTXN_KEY - Royalty 2.0 - TX GLO - Royalty Transactions Key Fields
ROIUY3_TX_ROYTXN_NONKEY - Royalty 2.0 - TX GLO - Royalty Transactions Non-Key Fields
ROIUY3_TX_ROYTXN_NONKEY_NUM - Royalty 2.0 - TX GLO - Royalty Transactions Non-Key Vol/Val
ROIUY3_TX_ROYTXN_NONKEY_VAL - Royalty 2.0 - TX GLO - Royalty Transactions Non-Key Validate
ROIUY3_TX_RPDTM_NONNKEY - Royalty 2.0 - TX GLO/TAMU - Report Detail Master Non-Key
ROIUY3_TX_RPGDT_KEY - Royalty 2.0 - Texas GLO/TAMU - Gas Report Key
ROIUY3_TX_RPGDT_NONKEY - Royalty 2.0 - Texas GLO/TAMU - Gas Report Non-Key
ROIUY3_TX_RPGDT_NONKEY_PROD - Royalty 2.0 - Texas GLO/TAMU - Gas Report Non-Key Prod Vol
ROIUY3_TX_RPGDT_TC - Royalty 2.0 - TX GLO/TAMU - Gas Report Detail Structure
ROIUY3_TX_RPGDT_TC_DELTA - Royalty 2.0 - TX GLO/TAMU - Gas Report Detail Delta Struc
ROIUY3_TX_RPODT_KEY - Royalty 2.0 - Texas GLO/TAMU - Oil Report Key
ROIUY3_TX_RPODT_NONKEY - Royalty 2.0 - Texas GLO/TAMU - Oil Report Non-Key
ROIUY3_TX_RPODT_NONKEY_PROD - Royalty 2.0 - Texas GLO/TAMU - Oil Report Non-Key Prod Vol
ROIUY3_TX_RPODT_TC - Royalty 2.0 - TX GLO/TAMU - Oil Report Detail Structure
ROIUY3_TX_RRC_ALV_0200 - Royalty 2.0 - TX GLO - RRC Master Screen 0200 ALV Structure
ROIUY3_TX_RRC_KEY - Royalty 2.0 - TX GLO/TAMU - RRC Master Key Fields
ROIUY3_TX_RRC_NONKEY - Royalty 2.0 - TX GLO/TAMU - RRC Master Non-Key Fields
ROIUY3_TX_SOLE - Royalty 2.0 - TX GLO/TAMU - SOL Exception Structure
ROIUY3_TX_SOLEDT - Change Document Structure; Generated by RSSCD000
ROIUY3_TX_SOLE_ALV_0200 - Royalty 2.0 - TX GLO/TAMU SOL Exception Header ALV Structure
ROIUY3_TX_SOLE_ALV_0400 - Royalty 2.0 - Texas GLO/TAMU SOL Exception ALV Structure
ROIUY3_TX_SOLE_TC_0300 - Royalty 2.0 - TX GLO SOL Except Detail Table Control Struct
ROIUY3_TX_SOL_ALV_0200 - Royalty 2.0 - TX GLO - SOL ALV Structure
ROIUY3_TX_UNIT - Change Document Structure; Generated by RSSCD000
ROIUY3_TX_UNIT_ALV_0200 - Royalty 2.0 - TX GLO - Unit Data Screen 0200 ALV Structure
ROIUY3_TX_UNIT_TC_0300 - Royalty 2.0 - TX GLO - Unit Master Screen 0300 TC Structure
ROIUY5_OK_CLO_108 - Roy 2.0 OK CLO-108 (Oil) CSV File Format
ROIUY5_OK_CLO_109 - Roy 2.0 OK CLO-109 (Gas) CSV File Format
ROIUY5_OK_ENTITY_NONKEY - Roy 2.0 OK Entity Non-Key
ROIUY5_OK_GAS_DISP_RP_VARIANCE - Roy 2.0 OK Gas ñ Display Royalty Report Variance
ROIUY5_OK_GR_GAS_ROYHSTA - Roy 2.0 OK & GR ñ Royalty History Gasl (Allocated) l
ROIUY5_OK_GR_OIL_ROYHSTA - Roy 2.0 OK & GR ñ Royalty History Oil (Allocated) l
ROIUY5_OK_GR_PRDT - Roy 2.0 OK & GR PRA Details
ROIUY5_OK_GR_ROYHSTA - Roy 2.0 OK & GR ñ Royalty History (Allocated)
ROIUY5_OK_KEY - Key level for OK Roy
ROIUY5_OK_OIL_DISP_RP_VARIANCE - Roy 2.0 OK Oil ñ Display Royalty Report Variance
ROIUY5_OK_PROF_NONKEY - Roy 2.0 OK - Reporting Profile Non-Key
ROIUY5_OK_RPDT_KEY - Roy 2.0 OK - Report Details Key
ROIUY5_OK_RPGDT_ALV_0100 - Roy OK(Gas) - Report Detail ALV Structure
ROIUY5_OK_RPGDT_NONKEY_NUMERIC - Roy 2.0 OK Gas Report Details Non-Key Numeric
ROIUY5_OK_RPODT_ALV_0100 - Roy OK(Oil) - Report Detail ALV Structure
ROIUY5_OK_RPODT_NONKEY_NUMERIC - Roy 2.0 OK Oil Report Details Non-Key Numeric
ROIUY6_DISPLAY_BALANCING_DTL - Roy 2.0 - Wyoming - Balancing Report Detail ALV Structure
ROIUY6_DISPLAY_BALANCING_HDR - Roy 2.0 - Wyoming - Balancing Report Header ALV Structure
ROIUY6_DISPLAY_PAYABLES_RECON - Roy 2.0 - Wyoming - Payables Recon ALV Structure
ROIUY6_DISP_WY_OOSWO_ALV_0100 - Royalty 2.0 - WY OOS Write Off Display Batch ALV Struct
ROIUY6_DISP_WY_VARIANCE_RPDTD - Royalty 2.0 - Display Wyoming Report Detail Variance
ROIUY6_MIG_WY_ROYHST_DOC - Royalty 2.0 - WY - Migration - VL Doc
ROIUY6_WY_ASU - Royalty 2.0 - WY - ASU Structure
ROIUY6_WY_ASUE_ALV_0200 - Roy 2.0 WY - Auto-Suspend Exception Screen 0200 ALV
ROIUY6_WY_ASUE_DT_KEY - Roy 2.0 WY - Auto Suspend Exception Detail Key
ROIUY6_WY_ASUE_HD_NONKEY - Roy 2.0 - Auto Suspend Exception Header Non-Key
ROIUY6_WY_ASUE_ROYTXN_EVAL - Roy 2.0 WY ASUE Roy Transaction Evaluated Fields
ROIUY6_WY_ASUE_TC_0300 - Roy 2.0 WY - Auto-Suspend Exception Screen 0300 Table Contro
ROIUY6_WY_ASU_ALV_0200 - Royalty 2.0 - WY - ASU ALV Structure
ROIUY6_WY_ASU_DT - Change Document Structure; Generated by RSSCD000
ROIUY6_WY_ASU_TC_0300 - Royalty 2.0 - WY - ASU Detail Table Control Structure
ROIUY6_WY_CAPOVR_ALV_0200 - Roy 2.0 - Wyoming - CA Percent Override Screen 0200 ALV
ROIUY6_WY_CBMOVR_ALV_0200 - Royalty 2.0 - WY - Coal Bed Methane Override Screen 0200 ALV
ROIUY6_WY_LEASE_ALV_0200 - Royalty 2.0 - WY - Lease Master Data Screen 0200 ALV Struct
ROIUY6_WY_LEASE_KEY - Royalty 2.0 - WY - Lease Data Key Fields
ROIUY6_WY_MASTER_ALV_0200 - Royalty 2.0 - WY - Master Data Screen 0200 ALV Structure
ROIUY6_WY_MASTER_KEY - Royalty 2.0 - WY - Master Data Key Fields
ROIUY6_WY_MASTER_MAINKEY - Royalty 2.0 - WY - Master Data Main Key Fields
ROIUY6_WY_MASTER_NONKEY - Royalty 2.0 - Wyoming Master Non-Key Fields
ROIUY6_WY_MASTER_SUBKEY - Royalty 2,.0 - WY - Master Sub Key
ROIUY6_WY_MASTER_TC_0300 - Royalty 2.0 - WY - Master Data Screen 0300 TC Structure
ROIUY6_WY_OOS_WO_ALV_0100 - Roy 2.0 - Wyoming Out Of Statute Write Off ALV Structure
ROIUY6_WY_PRDT - Royalty 2.0 - WY - PRA Detail (Allocation Percentage)
ROIUY6_WY_PRDT_TC - Royalty 2.0 - WY - PRA Detail Transactions Structure
ROIUY6_WY_PRICE_ALV_0200 - Royalty 2.0 - WY - Report Price Data Screen 0200 ALV Struct
ROIUY6_WY_REVTXN_KEY - Royalty 2.0 - WY - Royalty Reversal Key Fields
ROIUY6_WY_ROYHST - Change Document Structure; Generated by RSSCD000
ROIUY6_WY_ROYHST_TC_0300 - Roy 2.0 - Wyoming History Maint Table Control Structure
ROIUY6_WY_ROYTXN_ALV_0200 - Royalty 2.0 - WY User Tax Trans Screen 0200 ALV Structure
ROIUY6_WY_ROYTXN_KEY - Royalty 2.0 - WY - Royalty Transactions Key Fields
ROIUY6_WY_ROYTXN_NONKEY - Royalty 2.0 - WY - Royalty Transactions Non-Key Fields
ROIUY6_WY_RPDTD_KEY - Royalty 2.0 - Wyoming - Report Detail Key
ROIUY6_WY_RPDTD_NONKEY - Royalty 2.0 - Wyoming - Report Detail Non-Key
ROIUY6_WY_RPDTD_TC - Royalty 2.0 - WY - Report Detail Structure
ROIUY6_WY_RPDTL_KEY - Royalty 2.0 - Wyoming - Report Detail Lease Key
ROIUY6_WY_RPDTL_NONKEY - Royalty 2.0 - Wyoming - Report Detail Lease Non-Key
ROIUY6_WY_RPDTL_TC - Royalty 2.0 - WY - Report Detail Lease Structure
ROIUY6_WY_RPDTM_NONNKEY - Royalty 2.0 - WY - Report Detail (Lease/Unit) Non-Key Fields
ROIUY6_WY_RPDTU_KEY - Royalty 2.0 - Wyoming - Report Detail Unit Key
ROIUY6_WY_RPDTU_NONKEY - Royalty 2.0 - Wyoming - Report Detail Unit Non-Key
ROIUY6_WY_RPDTU_TC - Royalty 2.0 - WY - Report Detail Unit Structure
ROIUY6_WY_SOLE - Royalty 2.0 - WY - SOL Exception Structure
ROIUY6_WY_SOLEDT - Change Document Structure; Generated by RSSCD000
ROIUY6_WY_SOLE_ALV_0200 - Royalty 2.0 - Wyoming SOL Exception Header ALV Structure
ROIUY6_WY_SOLE_ALV_0400 - Royalty 2.0 - Wyoming SOL Exception ALV Structure
ROIUY6_WY_SOLE_TC_0300 - Royalty 2.0 - Wyoming SOL Except Detail Table Control Struct
ROIUY6_WY_SOL_ALV_0200 - Royalty 2.0 - Wyoming SOL ALV Structure
ROIUY6_WY_ZVOL_ALV_0200 - Royalty 2.0 - WY - Zero Vol Master Screen 0200 ALV Struct
ROIUY8_NM_CSV - Roy 2.0 NM CSV File Format
ROIUY8_NM_DISP_RP_VARIANCE - Roy 2.0 NM - Display Royalty Report Variance
ROIUY8_NM_ENTITY_NONKEY - Roy 2.0 NM Entity Non-Key
ROIUY8_NM_GR_PRDT - Roy 2.0 NM & GR PRA Details
ROIUY8_NM_GR_PRDT_PERCENT - Roy 2.0 NM/GR - PRA details Percentage
ROIUY8_NM_GR_ROYHSTA - Roy 2.0 NM & GR Royalty History (Allocated)
ROIUY8_NM_PROF_NONKEY - Roy 2.0 NM - Reporting Profile Non-Key
ROIUY8_NM_RPDT_ALV_0100 - Roy NM - Report Detail ALV Structure
ROIUY8_NM_RPDT_KEY - Roy 2.0 NM - Report Details Key
ROIUY8_NM_RPDT_NONKEY_NUMERIC - Roy 2.0 NM - Report Details Nonkey Numeric
ROIUY9_LA_CSV - Roy 2.0 LA CSV File Format
ROIUY9_LA_DISP_RP_VARIANCE - Roy 2.0 LA - Display Royalty Report Variance
ROIUY9_LA_ENTITY_NONKEY - Roy 2.0 LA Entity Non-Key
ROIUY9_LA_GR_PRDT - Roy 2.0 LA & GR PRA Details
ROIUY9_LA_GR_PRDT_PERCENT - Roy 2.0 LA/GR - PRA details Percentage
ROIUY9_LA_GR_ROYHSTA - Roy 2.0 NM & GR Royalty History (Allocated)
ROIUY9_LA_MASTER_NONKEY - Roy 2.0 LA Master Non-Key
ROIUY9_LA_MASTER_TC_0100 - Roy 2.0 -LA Master Data Screen 0100 Table Control Structure
ROIUY9_LA_PROF_NONKEY - Roy 2.0 LA - Reporting Profile Non-Key
ROIUY9_LA_RPDT_ALV_0100 - Roy LA - Report Detail ALV Structure
ROIUY9_LA_RPDT_KEY - Roy 2.0 LA - Report Details Key
ROIUY9_LA_RPDT_NONKEY - Roy 2.0 LA - Report Details Non-Key
ROIUY9_LA_RPDT_NONKEY_NUMERIC - Roy 2.0 LA - Report Details Non-Key Numeric
ROIUYA_CO_CSV - Roy 2.0 CO CSV File Format
ROIUYA_CO_DISP_RP_VARIANCE - Roy 2.0 CO ñ Display Royalty Report Variance
ROIUYA_CO_GR_PRDT - Roy 2.0 CO & GR PRA Details
ROIUYA_CO_GR_PRDT_PERCENT - Roy Generic CO/GR - PRA details Percentage
ROIUYA_CO_GR_ROYHSTA - Roy 2.0 CO & GR ñ Royalty History (Allocated)
ROIUYA_CO_GR_ROYTXNA - Roy 2.0 CO & GR Royalty Transaction (Allocated)
ROIUYA_CO_RPDT_ALV_0100 - Roy CO - Report Detail ALV Structure
ROIUYA_CO_RPDT_KEY - Roy 2.0 CO Report Details Key
ROIUYA_CO_RPDT_NONKEY_NUMERIC - Roy 2.0 CO Report Details Nonkey Numeric
ROIUYA_CO_RPDT_NON_KEY - Roy 2.0 CO RPDT Non Key
ROIUYA_CO_ZVOL_XL_TEMPL - Roy 2.0 CO - Zero Volume Reporting Master Excel Template
ROIUYC_BA_RPTID_ALV_0200 - Tax 2.0 - Wyoming SOL ALV Structure
Return Table index
