SAP Revenue Tables
Are you looking for the right table related to SAP Revenue Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Revenue (IS-OIL-PRA-REV) module.
Top 10 tables in Revenue
| Table | Description |
|---|---|
| OIUH_RV_AC | Account Control |
| OIUH_RV_MGDD | Marketing Group / DOI Owner Xref Detail |
| OIUH_RV_GTAX | Journal Entry Gross Tax Amounts Table |
| OIUH_RV_ZBR | Zero Balance Receivables Table |
| OIUH_RV_CPRH | Check Process Rule Header |
| OIUH_RV_JEINTF | PRA Journal Entries |
| OIUH_RV_INSL_H | Oil and Gas appl table |
| OIUH_RV_CW_BATCH | Checkwrite Parms for the batch execution process |
| OIUH_RV_DAVT | DOI Ad Valorem Tax |
| OIUH_RV_DPACC | DOI Override Acct Codes |
List of tables in Revenue
| Table | Description |
|---|---|
| OIUH_RV_AC | Account Control |
| OIUH_RV_MGDD | Marketing Group / DOI Owner Xref Detail |
| OIUH_RV_GTAX | Journal Entry Gross Tax Amounts Table |
| OIUH_RV_ZBR | Zero Balance Receivables Table |
| OIUH_RV_CPRH | Check Process Rule Header |
| OIUH_RV_JEINTF | PRA Journal Entries |
| OIUH_RV_INSL_H | Oil and Gas appl table |
| OIUH_RV_CW_BATCH | Checkwrite Parms for the batch execution process |
| OIUH_RV_DAVT | DOI Ad Valorem Tax |
| OIUH_RV_DPACC | DOI Override Acct Codes |
| OIUE2_RUN_JE | Proc 2.0 - Process Run JE Batch Info |
| OIUH_CM_OR4 | Organizational Level 4 Table |
| OIUH_RV_CR | Check Register |
| OIUH_RV_MTAD | Producers Mkting Tax Exemption Allowance Detail |
| OIUH_RV_RVH | Rpoyalty Reporting Value History |
| OIUH_RV_ROYH | New Mexico Royalty History |
| OIUH_RV_ONAB | Owners Negative Account Balance |
| OIUH_RV_PUC | Property Unit Use Control |
| OIUH_CM_SRBD | Oil and Gas appl table |
| OIUH_RV_CYC | Accounting Cycle Control Table |
| OIUH_RV_CT | Contract |
| OIUH_CM_BA | Oil and Gas appl table |
| OIUH_RV_RJE | Journal Entry |
| OIUH_RV_ATDHQ | Obsolete (4.72) -keep for 1 minor release-WY Ad Valorem Tax |
| OIUH_RV_PLX | Purchaser Layout Cross Reference |
| OIUH_RV_COADV | Colorado Ad Valorem |
| OIUH_RV_TPSL | Journal Entry Taxes Payable Subledger Table |
| OIUH_RV_STXR | State Tax Rates |
| OIUH_CM_CY | Counties Per State |
| OIUH_RV_RB | Receivable Balances Table |
| OIUH_PR_SAND | Oil and Gas appl table |
| OIUH_RV_NDPRD | North Dakota Tax History Oil Detail For Producers |
| OIUH_CM_OR1_CC | Mapping of Organization level to Company Code |
| OIUH_RV_RPAH | Royalty Processing Allowance Header |
| OIUH_RV_TPSL_H | Oil and Gas appl table |
| OIUH_CDEX_INTYP | Mapping Owner Interest type with CDEX Interest type |
| OIUHS_GRP | Group table |
| OIUE2_ESCH_DTL | Proc 2.0 - Escheat - Owner Details |
| OIUH_PR_MP | Measurement Point |
| OIUAR_BAL_CAT | Accounts Receivable Balance Categorization |
| OIUH_RV_MTAH | Producers Mkting Tax Exemption Allowance Header |
| OIUH_RV_SCD | Obsolete (4.72)-keep for 1 minor release - Suspended Check |
| OIUH_RV_RDTSW | Texas Royalty Detail Sweet And Sour Table |
| OIUE2_RUN_HDR | Proc 2.0 - Run Header |
| OIUH_RV_MDOI | MP/DOI Cross Reference |
| OIUH_RV_GTAX_H | Oil and Gas appl table |
| OIUH_RV_RPOH | Royalty Production Oil History |
| OIUE2_ARESCR_PDT | Proc 2.0 - AR Escrow - Report Property Details |
| OIUE2_ESCROWADDR | Proc 2.0 - WY Escrow - Addresses |
| OIUH_RV_OTAX_H | Oil and Gas OTAX History Table |
| OIUH_RV_TPPD | Tax PPA Company Master Detail Table |
| OIUH_RV_NPSH | Negative Payable/Suspense Header Table |
| OIUH_RV_TPPM | Tax PPA Company Master Table |
| OIUH_PR_MMSBA | Oil and Gas appl table |
| OIUH_RV_STSL | Journal Entry Statistical Subledger Table |
| OIUE1_BATCH_TYPE | LSSL Summary - Batch Types Which Require Higher Level Lock |
| OIUH_RV_DOIWC | DOI / WC Cross Reference |
| OIUH_AR_BAL | AR Balance categories (TBLRD044) |
| OIUE2_ESCH_RPDTH | Proc 2.0 - Escheat - Report Detail - Holder |
| OIUH_RV_ICSL | Journal Entry Intercompany Subledger Table |
| OIUE2_ARESCR_SUS | Proc 2.0 - AR Escrow - Included Suspense Reason Codes |
| OIUH_LOADED_JE | Records loaded to JE by transation o3uh_loadje |
| OIUHS_JE_DBI | PRA: Destination Code for Posting Rules |
| OIUH_RV_WYTD | Wyoming Tax Detail Table |
| OIUE2_PROC_GRP | Proc 2.0 - Process Groups |
| OIUH_CM_TT | Oil and Gas appl table |
| OIUE2_ARESCR_CKR | Proc 2.0 - AR Escrow - Check Run Info |
| OIUH_RV_FOT | Foreign Owner Tax Rates |
| OIURV03_FRMTAX | Valuation Transactions Level 3 - Formula Tax Detail |
| OIUAR_BAL_TRFR | Accounts Receivable Balance Transfer |
| OIUH_RV_COA | Chart of Accounts |
| OIUH_RV_OSTA | Owners State Tax Adjustments |
| OIUH_RV_WYTH | Wyoming Tax Header Table |
| OIUH_CHK_FLD_TX | Check Layout field code -TBLCI014 - text |
| OIUH_RV_CHDD | Check Deduction Detail |
| OIUH_RV_LWDED | Louisiana Marketing Deduction |
| OIUH_RV_MRC | Manual Royalty Check |
| OIUE2_ESCH_MDD | Proc 2.0 - Escheat - Mass Due Diligence Print Info |
| OIUH_RV_RPTDT | Report Date |
| OIUH_RV_EXTD | RDI - Check Detail Subset |
| OIUH_RV_PR | Property Table |
| OIURV03_VOLDTL | Valuation Transaction Level 2 -Volume |
| OIUH_RV_GVLST | Gross Volume State Table |
| OIUH_ACT_TAKEN_T | Action Taken Code (TBLRD023) |
| OIUH_RV_ARSL | Journal Entry Accounts Receivable Subledger Table |
| OIUH_RV_OTAX | Journal Entry Owner Tax Amounts Table |
| OIUH_RV_TAXHN | New Mexico Tax History For Non-Affiliated Txns |
| OIUH_RV_CC | Obsolete (4.72) - keep for 1 minor release - Check Control |
| OIUH_CM_QBE | Oil and Gas appl table |
| OIU_RV_CHD_PPA | Payment Processing - Check Detail PPA Reason Code |
| OIUH_REP_HIST | Reporting History old Razorfish |
| OIUH_RV_ARCMT | Account Receivable Comments Table |
| OIUH_PR_TXBBA | Oil and Gas appl table |
| OIUH_RV_BC | Batch Control |
| OIUH_RV_SVTD | Severence Tax State Reporting Number |
| OIUE2_RV_CR | Proc 2.0 - Check Register |
| OIUAR_RESPID | Accounts Receivable Responsibility ID |
| OIUH_RV_MSSL | Journal Entry Miscellaneous Subledger Table |
| OIUE2_ESCH_GRPSX | Proc 2.0 - Escheat - Process Group / State XRef |
| OIUH_PR_TX2BA | Oil and Gas appl table |
| OIUH_RV_ODED_H | Oil and Gas ODED History Table |
| OIUE2_ARESCR_SUM | Proc 2.0 - AR Escrow - Report Summary |
| OIUH_CM_OR3 | Organizational Level 3 Table |
| OIUH_RV_TR | Tract Information |
| OIUH_PTR_REP_LOG | Production, Tax and Royalty Reporting Execution Log |
| OIUE2_ESCH_DTLH | Proc 2.0 - Escheat - Owner Detail History |
| OIUH_RV_BR | Bearer |
| OIUE2_ESCROW_CR | Proc 2.0 - WY Escrow - Check Run Info |
| OIUH_RV_EXSL_H | Oil and Gas appl table |
| OIUH_RV_WOJE | Write Off JE Table |
| OIUH_RV_OIC | Owner Interest Calculations |
| OIUHS_TAB | Table group control |
| OIUH_RV_AWO | Approved Write Offs Table |
| OIUH_RV_TRGRI | Division Order Calculated GRI Units Table |
| OIUH_RV_GCTA | Gross Check Tax Amounts |
| OIUH_RV_MVT | Manual Void Check Transactions |
| OIUCW_PPA_SD | Payment Processing - State with Sales Date |
| OIUH_CM_BATYP | Business Associate Type Table |
| OIUH_RV_NDH | North Dakota Oil Tax History Header |
| OIUH_PR_RRWY | Oil and Gas appl table |
| OIUH_RV_RDTL | Royalty Details |
| OIUH_RV_ESCBA | Escheated Business Associates |
| OIUE2_CFGT | Proc 2.0 - Process Config Texts |
| OIUE2_ESCH_RPDTS | Proc 2.0 - Escheat - Report Detail - Summary |
| OIUH_RV_SEVCI | Severance Tax Transactions Miscellaneous (Check Input) |
| OIUH_RV_GLCC | Cross Reference GL to Cost Center |
| OIUAR_REC_BAL_H | Accounts Receivable Balance History |
| OIUHS_TAB_NAMES | Table names for PRA to RF |
| OIUE2_ARESCR_GCX | Proc 2.0 - AR Escrow - Process Group / Company XRef |
| OIUH_NM_PDCD_XRF | New Mexico Product Code Cross Reference (TBLTR091) |
| OIUH_RV_GL | Journal Entry General Ledger Table |
| OIUE2_PROC | Proc 2.0 - Processes |
| OIUH_RV_RBC | Receivable Balance Categories Table |
| OIUH_RV_PRX | Purchaser Remitter Cross Reference |
| OIUH_RV_PDX | Obsolete (4.72)-keep for 1 minor release-Purchaser DOI Xref |
| OIUE2_JEINTF | Proc 2.0 - JE Interface Table |
| OIUH_RV_ARSL_H | Oil and Gas appl table |
| OIUE2_ARESCRADDR | Proc 2.0 - AR Escrow - Addresses |
| OIUH_CHK_FLD | Check Layout field code -TBLCI014 |
| OIUH_RV_DOH | DOI Owner History |
| OIUH_RV_RBRE | Arbar Reject Table |
| OIUH_CM_OR2 | Organization Level 2 Table |
| OIUH_RV_INSL | Journal Entry Income Subledger Table |
| OIUE2_PROCT | Proc 2.0 - Process Texts |
| OIUH_RV_RPGH | Royalty Production Gas History |
| OIUH_RV_DPPN | Division Order Prior Period Notification |
| OIUE2_COUNC_XREF | State and Comptroller County code cross refrence |
| OIUE2_ESCH_ADDR | Proc 2.0 - Escheat - Addresses |
| OIUH_RV_DOEX | Owner State Tax Exemption |
| OIUH_RV_STIKO | Severance Take In Kind Owner |
| OIUH_RV_APSL | Journal Entry Accounts Payable Subledger Table |
| OIUH_RV_STS | Severence Tax Subsidiary |
| OIUH_PR_MPVD | Oil and Gas appl table |
| OIU_CM_BATCH_TX | Batch Job Name |
| OIUH_RV_THDR | Tax Header |
| OIUH_RV_CPR | Check Process Rule |
| OIUH_RV_OPSL_H | Oil and Gas OPSL History Table |
| OIUE2_ESCH_CFG | Proc 2.0 - Escheat - Minimum Age and Amount Configuration |
| OIUCW_PPA_ST | Payment Processing - PPA Reason Code Config |
| OIURV03_TAXDTL | Valuation Tax Master Detail |
| OIUH_RV_RTDE | Receivable Transactions Detail Table |
| OIUE2_PROC_TYPE | Proc 2.0 - Process Types |
| OIUE2_ESCH_RPDTP | Proc 2.0 - Escheat - Report Detail - Property |
| OIUH_RV_DO | DOI Owner |
| OIUE2_PROC_ENAB | Proc 2.0 - Process Enabled? |
| OIUH_RV_DPPC | DOI Product Processed Control |
| OIU_RV_MKTG_H | Journal Entry Marketing Detail |
| OIUH_RV_CHD | Check Detail |
| OIUH_RV_ACR | Account Category Requirements |
| OIUH_X_EP2RZ | Razorfish To PRA Cross Reference |
| OIU_RV_CMKT | Check Detail Marketing Deductions |
| OIURV03_TAXHDR | Valuation Tax Header |
| OIUE2_ESCH_STATE | Proc 2.0 - Escheat - State Configuration |
| OIUH_RV_TCD | Tax Calc Data |
| OIURV03_DTL_ZE | Valuation Transactions Level 1 - Zero Volume |
| OIUH_PR_PF | Oil and Gas appl table |
| OIUH_RV_ATDH | Obsolete (4.72) -keep for 1 minor release-WY Ad Valorem Tax |
| OIUH_RV_BCMT | Balance Comment Table |
| OIUE2_STEPX_ST | Proc 2.0 - Step Prerequisite Status |
| OIUH_RV_CLF | Check Layout Format |
| OIUH_RV_RTCH | RD DOI Transfer Change Header |
| OIUH_CM_SRDO | Oil and Gas appl table |
| OIURV03_DOCMPXRF | VL Doc to MP XRef |
| OIUH_RV_TEP | Tax Extract Profile |
| OIUH_RV_BT | Balance Transfer Table |
| OIURV01_RD_REP | RD Generic Report |
| OIUAR_WO_CONFIG | Accounts Receivable Writeoff Configuration |
| OIUH_LEGEND | Legend Code - TBLRV064 |
| OIUH_RV_WHHD | Table for withholding report |
| OIUH_RV_VCR | Caluation Cross Reference Header |
| OIUH_PR_WC | Oil and Gas appl table |
| OIUH_RV_MSSL_H | Oil and Gas appl table |
| OIUH_CM_PDCD | Oil and Gas appl table |
| OIUH_RV_OCTA | Owner Check Tax Amounts |
| OIUH_CDEX_PROD | Mapping Product code with CDEX Product Code |
| OIUH_RV_ARINTF | PRA Journal Entries to A/R interface table |
| OIUH_RV_CMCC | Contract Marketing Cost Control |
| OIUE2_ESCH_HOLD | Proc 2.0 - Escheat - ASCII - Holder Record |
| OIUH_REP_PAR_SET | Reporting - Parameter Set per Report |
| OIUH_RV_TPPN | Tr PPN |
| OIURV02_ADA_HD | Alternative Dual Accounting Multipliers Header |
| OIUH_RV_STSL_H | Oil and Gas appl table |
| OIUH_PR_WCAP | Oil and Gas appl table |
| OIUE2_ESCROW_DTL | Proc 2.0 - WY Escrow - Owner Details |
| OIUH_RV_MKEX | Marketing Cost Exemption Table |
| OIUH_RV_DOGRI | Division Order Calculated GRI Percentage Table |
| OIUH_RV_SVTDH | Obsolete (4.72)-keep for 1 minor release-Sev Tax State Rep# |
| OIUAR_REC_BAL | Accounts Receivable Balance |
| OIUH_CM_SRBT | Oil and Gas appl table |
| OIURV03_MPWC_XRF | MP to Well Completion Split Out XRef |
| OIUH_RV_LMDED | Louisiana Marketing Deduction |
| OIUH_RV_SS | Contract Spot Sale |
| OIUE2_CFG | Proc 2.0 - Process Config |
| OIUH_RV_GRP | Group Number And Description |
| OIUAR_COMMENT | Accounts Receivable Comments |
| OIUH_PR_WL | Oil and Gas appl table |
| OIUH_RV_RPAD | Royalty Processing Allowance Detail |
| OIUH_PR_RWC | Oil and Gas appl table |
| OIURV02_ADA_DT | Alternative Dual Accounting Multipliers Header |
| OIUH_RV_OPSL | Journal Entry Owner Payable Subledger Table |
| OIUH_CM_CTTYP | Oil and Gas appl table |
| OIUHS_JE_ACR | PRA: Journal Entry Account Categories |
| OIUH_RV_TAXHA | New Mexico Tax History For Affiliated Txns |
| OIUH_RV_BGUC | Bearer Group Use Control |
| OIUH_RV_EXSL | Journal Entry Expense Subledger Table |
| OIUH_RV_CD | Obsolete (4.72) - keep for 1 minor release-Check Detail Line |
| OIUH_CM_EM | Oil and Gas appl table |
| OIUH_RV_NDPUR | North Dakota Tax History Oil Detail For Purchasers |
| OIUH_RV_LSSL_H | Oil and Gas appl table |
| OIUH_RV_CLT | Contract -- Long Term |
| OIUH_RV_ODED | Journal Entry Other Deductions Table |
| OIUH_RV_PAC | Property Affiliated Company |
| OIUH_RV_SEVWC | Severance Tax Transactions By Well, WC |
| OIUH_RV_RDT | Royalty Detail For Texas |
| OIUH_SORT_PARAM | Oil & Gaz - Program Parameters by Jil Steps |
| OIUHS_TAB_TXT | Text table for OIUHS_TAB |
| OIUH_RV_CNL | Cdex New Lease |
| OIURV03_TAXEMP | Valuation Tax Exempt Detail |
| OIUE2_ESCH_SF | Proc 2.0 - Escheat - State Smart Form Config |
| OIUE2_ESCH_PGCCX | Proc 2.0 - Escheat Process Group Company Code XREF |
| OIUH_RV_SEVMP | Severance Tax Transactions By Measurement Point |
| OIUE2_ESCROW_SUS | Proc 2.0 - WY Escrow - Excluded Suspense Reason Codes |
| OIUH_AR_BAL_TX | AR Balance categories - TBLRD044 - text |
| OIUH_RV_CMCD | Contract Marketing Cost Detail |
| OIUH_RV_TCLD | Tax Class Data |
| OIUH_RV_LSSL | Journal Entry Legal Suspense Subledger Table |
| OIUH_RV_CL | Check Layout |
| OIUH_PR_DNND | Oil and Gas appl table |
| OIUH_RV_TRP | Tax And Royalty Profile |
| OIUE2_ESCH_BA | Proc 2.0 - Escheat - BA |
| OIUH_RV_CDTRAN | Transaction Code Cross Reference With Deduction Type Code |
| OIUHS_JE_DPK | JE Rules - Destination Code/Posting-key |
| OIURV03_CONFIG | MP to Well Completion Split Out Config |
| OIURV03_TAXMKT | Valuation Tax Marketing Detail |
| OIUH_RV_APSL_H | Oil and Gas appl table |
| OIUH_DD_CONFIG | DD names per program with Open Mode (I/O) for QSAM files |
| OIUH_CM_SRDA | Oil and Gas appl table |
| OIUH_RV_DI | Division Of Interest Base |
| OIUH_RV_CCH | Obsolete (4.72)-keep for 1 minor release- Cdex Check History |
| OIUH_RV_CCR | Obsolete (4.72)-keep for 1 minor release- Check Copy Reverse |
| OIUH_RV_DTWK | Deduction/Tax Work Table |
| OIUH_PR_DN | Oil and Gas appl table |
| OIURV03_DTL_BK | Valuation Transactions Level 1 - Vltxns |
| OIUE1_LSSL_SUM | Legal Suspense Summary |
| OIUH_CM_INSTL | Revenue Installation Parameters |
| OIUH_CM_BAB | Oil and Gas appl table |
| OIUE2_ESCH_SUMH | Proc 2.0 - Escheat - Owner Summary History |
| OIUH_CM_STATE | State Codes Table |
| OIUH_PR_LAPAR | OIUH_PR_LAPAR |
| OIUH_RV_DOACC | DOI Owner Override Acct Codes |
| OIUH_LEGEND_TX | Legend Code Description - TBLRV064 |
| OIUH_RV_DPUC | DOI Product Use Control |
| OIURV03_FRMHDR | Valuation Transaction Level 3 - Formula |
| OIUH_RV_PT | Purchaser Translation |
| OIUE2_ESCH_SUM | Proc 2.0 - Escheat - Owner Summary |
| OIUH_JEPOST_CTL | JE Posting Process Control table |
| OIUH_RV_VCHDD | Void Check Deductions Detail |
| OIUH_CM_OR1 | Organization Level 1 Table |
| OIUH_CM_EC | Oil and Gas appl table |
| OIUE2_ESCH_SUS | Proc 2.0 - Escheat - Excluded Suspense Reason Codes |
| OIUH_PR_RRTX | Oil and Gas appl table |
| OIUH_RV_JE | Journal Entry |
| OIUE2_ARESCR_DTL | Proc 2.0 - AR Escrow - Owner Details |
| OIU_RV_MKTG | Journal Entry Marketing Detail |
| OIUH_RV_RP | MMS Royalty Pending |
| OIUH_ACT_TAKEN | Action Taken Code (TBLRD023) |
| OIUHS_GRP_TXT | Text table for OIUHS_GRP |
| OIUH_PR_RRST | Oil and Gas appl table |
| OIUE2_TYPE_TABT | Proc 2.0 - Process Type Tab Texts |
| OIUE2_PROC_TYPET | Proc 2.0 - Process Type Texts |
| OIUH_RV_STR | Severence Tax Rates |
| OIUE2_RV_CHD | Proc 2.0 - Check Details |
| OIUHS_SAP_SORT | PRA: Control Table for SAP Sort |
| OIUE2_PROC_STEP | Proc 2.0 - Process Steps |
| OIUH_RV_SID | State Interest Defaults |
| OIUH_RV_RTD | RD DOI Transferee Detail |
| OIUH_RV_ICSL_H | Oil and Gas appl table |
| OIUH_RV_GL_H | Oil and Gas GL History Table |
| OIUHS_JE_ACC_TYP | PRA: Journal Entry Posting Rules per Account Type |
| OIUE2_ESCR_GRPCX | Proc 2.0 - WY Escrow - Process Group / Company XRef |
| OIUHS_JE_ACC_ID | PRA: Journal Entry Posting Rules per Account Type |
| OIUH_RV_SEV | Severance Tax Transaction |
| OIUE2_PROC_GRPT | Proc 2.0 - Process Group Texts |
| OIUH_RV_TD | Tax Detail |
| OIUH_RV_MGDH | Marketing Group/DOI Owner Xref Header |
| OIUH_RV_VCHD | Void Check Detail |
| OIUE2_TYPE_TAB | Proc 2.0 - Process Type Tabs |
| OIUE2_RUN_DTL | Proc 2.0 - Run Detail |
| OIUE2_PROC_STEPT | Proc 2.0 - Process Step Texts |
| OIUH_RV_IVS | Invoice Selection |
| OIUH_RV_DP | DOI Product |
| OIUE2_CW_REJECTS | Proc 2.0 - Check Write Rejects |
| OIUH_RV_PWO | Pending Write Offs Table |