Select data from sap tables OIUR
Display SAP table details
OIUREPP_LEASE - MMS-2014 - Lease PPA
OIUREPP_OWNER - MMS-2014 - Owner PPA
OIUREPP_PRPAYXRF - MMS-2014 - Property / Payor XRef PPA
OIUREPP_SALETYPE - MMS-2014 - Sales Type PPA
OIUREPP_WCPAYXRF - MMS-2014 - Well Completion / Payor XRef PPA
OIUREP_2014_CONF - MMS-2014: Configurable Items
OIUREP_2014_INFO - MMS-2014 - Report Executions Start information
OIUREP_2014_REP - MMS-2014 - Supplemental Reports From Report Executions
OIUREP_2014_RUNS - MMS-2014 - Report Executions
OIUREP_ACTIVATE - Reg./Tax and Royalty Reporting - report activation
OIUREP_ADD_DATA - Regulatory Reporting Config for Additional Master Data
OIUREP_ADJCD_XRF - MMS-2014 - Reversal Rsn to Adjustment Reason Code XREF
OIUREP_ADJ_DTLA - MMS OGOR A Adjustment Detail Record
OIUREP_ADJ_DTLB - MMS OGOR B Adjustment Detail Record
OIUREP_ADJ_DTLC - MMS OGOR C Adjustment Detail Record
OIUREP_ADJ_HDR - Adjustment Header for MMS OGOR
OIUREP_ADJ_PASR - MMS PASR Adjustment Detail Record
OIUREP_ADJ_PASRH - MMS PASR Adjustment Header Record
OIUREP_AGENCIES - Regulatory Reporting Agencies
OIUREP_AGENCYTX - Regulatory Reporting Agencies
OIUREP_AGY_LSE - Agency assigned Leases
OIUREP_AGY_LSETX - Text Table for Agency assigned Leases
OIUREP_AGY_PCDTX - Agency defined Product Code Text
OIUREP_AGY_PDCD - Agency defined Product Code
OIUREP_AGY_VLTP - Agency defined Volume Types
OIUREP_AGY_VTPTX - Text table for Agency defined Volume Type
OIUREP_AMND_STAT - Report Execution statistics for amended months
OIUREP_ARCROYHIS - Archived Reported Royalty and Volume Data
OIUREP_ARCVOLHIS - Archived Reported Volume Data by Reporting Entities
OIUREP_BA_MASTER - Regulatory reporting: BA table to drive Partner reporting
OIUREP_CCO_DTEDT - Colorodo Form 7 Edit Effective Date Table
OIUREP_CD_EIAXRF - Reg Reporting Product/Volume Type to EIA Report Code Ref
OIUREP_CMNT_LOG - Reg Reporting: Status Log of comments mass upload
OIUREP_CM_JIL - Activate JIL control table
OIUREP_CODE_CMLB - Regulatory Reporting Common Table List Box Setup
OIUREP_CODE_COMA - Common table to convert SAP codes to Ag. codes Apl.Table
OIUREP_CODE_COMN - Common table for converting SAP codes to Agency codes
OIUREP_CODE_FLDS - Fields available for customizing
OIUREP_CODE_FLDT - Descriptions for Code Fields
OIUREP_CODE_RDNG - Reg Reporting Rounding Configuration
OIUREP_CODE_RPTC - Report Columns available for customizing
OIUREP_CODE_RULE - Reg Reporting Rules for Column Data
OIUREP_CODE_VALS - Code Values available for customizing Reg Reporting
OIUREP_CODE_VLTX - Code Value Texts
OIUREP_CODE_XREF - Reg Reporting Product/Volume Type to Report Code Cross Ref
OIUREP_COMN_KEYS - Reg.Reporting - Field description for COMN table keys
OIUREP_DD_STRUCT - Master DD file structures
OIUREP_DN_XREF - Regulatory Reporting X-ref for Delivery Networks
OIUREP_EIA914CMT - Regulatory Reporting - EIA-914 Form Comments
OIUREP_EIA_914AC - Regulatory Reporting - Group Affiliated Company
OIUREP_EIA_914HD - Regulatory Reporting - EIA914 : Group Dated Attributes
OIUREP_EIA_914NO - Regulatory Reporting - Group - New Operators
OIUREP_EIA_914OP - Regulatory Reporting - State-Comment XRef
OIUREP_EIA_914PO - Regulatory Reporting - Group - Previous Operators
OIUREP_EIA_HSTAO - Regulatory Reporting - EIA914 Report History Additional data
OIUREP_EIA_HSTDT - Regulatory Reporting - EIA914 Report History Details
OIUREP_EIA_HSTHD - Regulatory Reporting - EIA914 Report History Header
OIUREP_EMPBACKUP - Exemptions for skipped tax records
OIUREP_ENTTY_LOG - Log table for master data entity changes
OIUREP_EXEC_COMB - Possible Combinations of Royalty Executions
OIUREP_EXEC_STAT - Report Execution Statistics
OIUREP_EXT_COMP - External Company by State Agency
OIUREP_EXT_COMTX - Text Table for External Company Code
OIUREP_FEDINDIAN - MMS-2014 - Federal or Indian Leases
OIUREP_FIELDNAME - Reporting - Fieldname Structure
OIUREP_FIELDS - Regulatory Report Master Data set up
OIUREP_FIELDSTX - Regulatory Report Master Data set up
OIUREP_FIN_LEVEL - Regulatory Reporting Operator and Contact Xref
OIUREP_GEN_DATA - Reg. Reporting - Generic Transactional data
OIUREP_GROUP_HD - Regulatory Reporting - EIA 914 : Group Master
OIUREP_GR_EIA914 - Regulatory Reporting - EIA914: Group Master Data
OIUREP_GR_ORGLVL - Regulatory Reporting - Group - Org Level 1 Mapping
OIUREP_HISTCNTRL - Regulatory Reporting History Control table
OIUREP_INDIAN_TR - MMS-2014 - Indian Tribes
OIUREP_KEY_XREFD - Regulatory Reporting SAP Key Cross Reference Detail
OIUREP_KEY_XREFH - Regulatory Reporting SAP Key Cross Reference Header
OIUREP_LEASE - MMS-2014 - Lease
OIUREP_LGL_RPTS - Legal Reports for Tax and Royalty Reporting
OIUREP_LGL_RPTTX - Text Table for Legal Reports (Tax and Royalty)
OIUREP_MASTER - Regulatory Reporting Master Data
OIUREP_MASTER_CP - Commingled Well completion Permit number override
OIUREP_MASTER_MP - Re.Reporting - MP related Reg ID
OIUREP_MASTER_OV - RegID Split table (e.g. MMS Override Group split)
OIUREP_MASTER_PC - RegID Split table
OIUREP_MASTER_ST - Maintain Errors during Manual Upload in Master MP reg ID
OIUREP_MAST_E914 - Regulatory Reporting - EIA 914: State & Product Code Mapping
OIUREP_MKTBACKUP - Marketing cost for skipped tax records
OIUREP_MMS_ACTN - MMS Well Status Reason Code/Action Code Combos (OGOR-A)
OIUREP_MMS_DTEDT - MMS-2014 Edit Effective Date Table
OIUREP_MMS_REAS - MMS Well Status / Reason Code Combinations (OGOR-A)
OIUREP_MMS_REJS - MMS-2014 - Extraction Rejects
OIUREP_MP_XREF - Regulatory Reporting X-ref - MP to State Assigned ID
OIUREP_MRT_CRED - MMS-2014: Credits Against Monthly Report
OIUREP_MRT_HIST - MMS-2014 MMS Royalty Transaction Processed History
OIUREP_MRT_PEND - MMS-2014 MMS Royalty Transaction Processed - Pending
OIUREP_OWNER - MMS-2014 - Owner
OIUREP_OWNER_LOG - Log for master Data Owner Changes
OIUREP_PAYOR - MMS-2014 - Payor / Company Code XRef
OIUREP_PDCD_XREF - Cross Reference Between State Agency and PRA Material
OIUREP_PD_MPP - MMS Prod. Code/Entity Type enabling for Major Portion Price
OIUREP_PRDCDXREF - MMS: Possible Material No/MMS Prod Cd Combinations
OIUREP_PRFL_LOG - Log for master data profile changes
OIUREP_PROWNERS - MMS-2014 - Property w/ Multiple Owners?
OIUREP_PRPAYXREF - MMS-2014 - Property / Payor XRef
OIUREP_PR_REG - Master data for rounding setup
OIUREP_RECOUP - MMS-2014 - Recoupable Balance
OIUREP_REG_HIST - Reporting history (System table INDX)
OIUREP_REG_OPER - Regulatory Reporting Operator and Contact Xref EFF Dated
OIUREP_REG_OPERA - Regulatory Reporting Operator and Contact Xref
OIUREP_REG_OUT - Regulatory Reporting Output Control
OIUREP_REPORTS - Supported Regulatory reports
OIUREP_REPORTSTX - Supported Regulatory reports
OIUREP_REPORT_DATE_RANGE - PRA Regulatory Reporting Date Range - FROM and TO dates
OIUREP_ROYHIST - Reported Royalty and Volume Data by Reporting Entities
OIUREP_ROYHISTBK - Backup table for OIUREP_ROYHIST
OIUREP_ROY_AGY - Reporting Agencies for Tax and Royalty
OIUREP_ROY_AGYTX - Regulatory Reporting Agencies
OIUREP_ROY_DATA - Reported Royalty and Volume Data by Reporting Entities
OIUREP_ROY_FLDTX - Text Table for Report Fields
OIUREP_ROY_LOG - Changes to master data for reporting
OIUREP_ROY_PRFL - Royalty Reporting Profiles
OIUREP_ROY_PRFLD - Field Values in the Royalty Reporting Profiles
OIUREP_RPT_ENTTY - Entities for Royalty Reporting
OIUREP_RPT_OWNER - Owners for royalty reporting
OIUREP_RPT_PRFL - Report Profile
OIUREP_RRST - Regulatory Reporting Status Table
OIUREP_RRST_DET - Regulatory Reporting Status Table
OIUREP_RRST_NEW - NEW Regulatory Reporting Status Table (with Version Number)
OIUREP_RTPEND - MMS-2014 - Royalty Transaction Pending
OIUREP_RT_HIST - MMS-2014 - Royalty Transaction (Pending) History
OIUREP_RUNGRPKEY - Reg.Reporting - Report Submission groups
OIUREP_RUN_GROUP - Reg.Reporting - Report Submission grouping
OIUREP_RUN_REPNM - Reg.Reporting - Report run/submission names
OIUREP_RWC - WCs that have been changed since previous report run
OIUREP_SALESTY - MMS-2014: Sales Type Control Table
OIUREP_SALESTYPE - MMS-2014 - Sales Type
OIUREP_SALESTY_T - MMS-2014: Sales Type Control Table Description
OIUREP_STAT_SPLT - Regulatory Reporting: Well Status Split table
OIUREP_STRUC - Regulatory Reporting Structures
OIUREP_STRUCTX - Regulatory Reporting Structures
OIUREP_SUPL_REP - MMS-2014 - Supplemental Reports
OIUREP_SUPL_REPT - MMS-2014 - Supplemental Reports Description
OIUREP_TAB_IND - Agency related fields for master data maintainence
OIUREP_TAXBACKUP - Backup tax table for old tax reporting SOL
OIUREP_TAX_SOL - Old tax reporting SOL configuration table
OIUREP_TEXT_STDD - Regulatory Reporting Standard Texts Detail
OIUREP_TEXT_STDH - Regulatory Reporting Valid Standard Texts Header
OIUREP_TEXT_XREF - Regulatory Reporting Texts for Diff Reporting Levels
OIUREP_TIKBACKUP - Backup tik table for old tax reporting SOL
OIUREP_TRAN_ERR - Transaction code to error code xref for edits/vals
OIUREP_TRAN_FLDS - MMS-2014 - Transaction Code Field Requirement XREF
OIUREP_UOM - Regulatory Report Unit of Measures
OIUREP_VALTABC - Reporting general value table - Customizing
OIUREP_VALTABCTX - Reporting general value table - Customizing
OIUREP_VALTABM - Reporting general value table - Customizing
OIUREP_VLTP_XREF - Cross reference between Agency defined & PRA volume types
OIUREP_VL_VOL - Gross Volume and Value after VL/RD
OIUREP_VOLHIST - Reported Volume Data by Reporting Entities
OIUREP_VOLHISTBK - Backup table for OIUREP_VOLHIST
OIUREP_VOL_DATA - Reported Volume Data by Reporting Entities
OIUREP_WCOWNERS - MMS-2014 - Well Completion w/ Multiple Owners
OIUREP_WCPAYXREF - MMS-2014 - Well Completion / Payor XRef
OIUREP_XTRCT_ROY - Extract Royaty Data for the current reporting period
OIUREP_ZERO_REJS - Rejection Criteria for Zero volume records
OIURV01_RD_REP - RD Generic Report
OIURV02_ADA_DT - Alternative Dual Accounting Multipliers Header
OIURV02_ADA_HD - Alternative Dual Accounting Multipliers Header
OIURV03_CONFIG - MP to Well Completion Split Out Config
OIURV03_DOCMPXRF - VL Doc to MP XRef
OIURV03_DTL_BK - Valuation Transactions Level 1 - Vltxns
OIURV03_DTL_ZE - Valuation Transactions Level 1 - Zero Volume
OIURV03_FRMHDR - Valuation Transaction Level 3 - Formula
OIURV03_FRMTAX - Valuation Transactions Level 3 - Formula Tax Detail
OIURV03_MPWC_XRF - MP to Well Completion Split Out XRef
OIURV03_TAXDTL - Valuation Tax Master Detail
OIURV03_TAXEMP - Valuation Tax Exempt Detail
OIURV03_TAXHDR - Valuation Tax Header
OIURV03_TAXMKT - Valuation Tax Marketing Detail
OIURV03_VOLDTL - Valuation Transaction Level 2 -Volume
OIURV_CRH_HST - Combined Run Header History
OIURV_CRH_MKTG - Combined Run Header Marketing Cost
OIURV_CRH_TAX - Combined Run Header Tax
OIURV_DOC_BCN - Revenue Document Concept - Batch Control Number
OIURV_DOC_COT - VL Document Chain Of Title
OIURV_DOC_CRAD - Oil and Gas appl table
OIURV_DOC_CRH - Oil and Gas appl table
OIURV_DOC_CRMKT - Oil and Gas appl table
OIURV_DOC_CROD - Oil and Gas appl table
OIURV_DOC_CRTAX - Oil and Gas appl table
OIURV_DOC_CT_OD - ONRR MPP: Alternate Contract ID Owner XRef
OIURV_DOC_DTL_BK - Valuation Transactions Level 1 - Vltxns
OIURV_DOC_DTL_RV - Valuation Reversal Notificaton
OIURV_DOC_DTL_ZE - Valuation Transactions Level 1 - Zero Volume
OIURV_DOC_FRMHDR - Valuation Transaction Level 3 - Formula
OIURV_DOC_FRMLAU - Valuation Formula Alternate Use
OIURV_DOC_FRMMKT - Valuation Transactions Level 3 - Marketing Detail
OIURV_DOC_FRMTAX - Valuation Transactions Level 3 - Formula Tax Detail
OIURV_DOC_HDR - Valuation Document Header
OIURV_DOC_JEINTF - Revenue Document Concept - JEINTF temp table
OIURV_DOC_MMSPOP - Dual Accounting MMS/POP
OIURV_DOC_OOBJE - Out Of Balance JEs
OIURV_DOC_RDSUM - RD summary(VL interface records to RD)
OIURV_DOC_RUNTKT - Valuation Transaction - Run Ticket
OIURV_DOC_TAXDTL - Valuation Tax Master Detail
OIURV_DOC_TAXEMP - Valuation Tax Exempt Detail
OIURV_DOC_TAXHDR - Valuation Tax Header
OIURV_DOC_TAXMKT - Valuation Tax Marketing Detail
OIURV_DOC_VOLDTL - Valuation Transaction Level 2 -Volume
OIURV_DOC_VOLUNT - Valuation Document Concept - Volume Unit
OIURV_DO_DPSEVT - DOI Accounting Severance Tax Types Table
OIURV_DUAL_COMP - Dual Accounting Compare
OIURV_DUAL_JEBR - Dual Accounting JE Backout / Rebook
OIURV_GASSTMTH - Gas Statement Header
OIURV_PROC_LIMIT - Allowed concurrent and free dialog processes for VL/RD
OIURV_SSTD - Settlement statement detail
OIURV_SSTD_MKT - Settlement statement detail
OIURV_SSTD_TAX - Settlement statement detail
OIURV_STS - Severance tax statistics
OIURV_STS_EMP - Severance Tax Statistics - Exempt
OIURV_STS_MKT - Severance Tax Statistics - Marketing
OIURV_TAXCONFD - State tax configuration detail
OIURV_TAXCONFH - State tax configuration header
OIURV_TAXTYPES - State applicable Tax Types are maintained
OIURV_TCD - Tax calculation data
OIURV_TCD_EMP - Tax calculation data
OIURV_TCD_MKT - Tax calculation data
Return Table index