1. SAP Tutorial
  2. Oil & Gas

OIUH_RV_DO SAP table for – DOI Owner

Here we would like to draw your attention to OIUH_RV_DO table in SAP. As we know it is being mainly used with the SAP IS-OIL-PRA (Production and Revenue Accounting in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIUH_RV_DO is a SAP standard transp table used for storing DOI Owner related data in SAP. It comes under the package OIU_H.

SAP OIUH_RV_DO table

Table OIUH_RV_DO technical data

TableOIUH_RV_DO
Data storingDOI Owner
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REV
SAP PackageOIU_H
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUH_RV_DO Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in OIUH_RV_DO table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • DO_SYS_NO : SYSTEM NUMBER
    Its a key field. Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 18
  • DO_PR_NO : PROPERTY NUMBER
    Its data type is CHAR (Character String) with field length 8
  • DO_DOI_NO : DIVISION OF INTEREST NO
    Its data type is CHAR (Character String) with field length 5
  • DO_OWN_NO : OWNER NUMBER
    Its data type is CHAR (Character String) with field length 6
  • DO_OWN_SEQ_NO : OWNER SEQUENCE NUMBER
    Its data type is CHAR (Character String) with field length 2
  • DO_INT_TYPE_CD : INTEREST TYPE CODE
    Its data type is CHAR (Character String) with field length 2
  • OWN_INT_SEQ_NO : OWNER INTEREST SEQUENCE NUMBER
    Its data type is CHAR (Character String) with field length 2
  • DO_EFF_FROM_DT : EXPIRATION DATE
    Its data type is CHAR (Character String) with field length 14
  • DO_EFF_TO_DT : EXPIRATION DATE
    Its data type is CHAR (Character String) with field length 14
  • DO_EFF_TO_DT_CD : EFFECTIVE TO DATE CODE
    Its data type is CHAR (Character String) with field length 1
  • DO_JIB_OFFS_FL : JOB INTEREST BILLING OFFSET FLAG
    Its data type is CHAR (Character String) with field length 1
  • DO_NET_INT_PC : NET INTEREST PERCENTAGE
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • DO_SUS_CD : SUSPENSE CODE
    Its data type is CHAR (Character String) with field length 2
  • DO_TAX_FREE_CD : TAX FREE CODE
    Its data type is CHAR (Character String) with field length 2
  • DO_BG_NO : BEARER GROUP NUMBER
    Its data type is CHAR (Character String) with field length 2
  • DO_PYOUT_CD : PAYOUT CODE
    Its data type is CHAR (Character String) with field length 1
  • DO_PAY_CD : PROPERTY STATE CODE
    Its data type is CHAR (Character String) with field length 2
  • DO_ENTL_CD : ENTITLED CODE
    Its data type is CHAR (Character String) with field length 1
  • DO_SSC_FL : SLIDING SCALE FLAG
    Its data type is CHAR (Character String) with field length 1
  • MMS_POP_COMP_CD : MMS ‘POP’ COMPARISON CODE
    Its data type is CHAR (Character String) with field length 1
  • DO_DUAL_ACCT_CD : DUAL ACCOUNTING FLAG
    Its data type is CHAR (Character String) with field length 1
  • DO_ENTY_CD : ENTITY CODE
    Its data type is CHAR (Character String) with field length 2
  • DO_CMT_FL : COMMENT FLAG
    Its data type is CHAR (Character String) with field length 1
  • DO_ACCT_ENT_FL : ACCOUNT ENTRY FLAG
    Its data type is CHAR (Character String) with field length 1
  • DO_INT_CAT_CD : INTEREST CATEGORY CODE
    Its data type is CHAR (Character String) with field length 1
  • O_CTL_MK_INT_FL : CONTRACT LONG TERM MARKETING
    Its data type is CHAR (Character String) with field length 1
  • DO_MNM_ROY_DT : MINIMUM ROYALTY DATE
    Its data type is CHAR (Character String) with field length 14
  • DO_MNM_ROY_AM : MINIMUM ROYALTY AMOUNT
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 8
  • DO_ADV_ARRS_CD : ADVANCE/ARREARS CODE
    Its data type is CHAR (Character String) with field length 1
  • DO_CARR_BG_CD : CARRYING BEARER GROUP CODE
    Its data type is CHAR (Character String) with field length 2
  • LSE_USE_PMT_FL : LEASE USE PAYMENT FLAG
    Its data type is CHAR (Character String) with field length 1
  • DO_JIB_BA_NO9 : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • DO_JIB_BA_NO : MARKETING REP’S BA NO
    Its data type is CHAR (Character String) with field length 6
  • O_JIB_BA_SEQ_NO9 : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • O_JIB_BA_SEQ_NO : THE MARKETING REP’S BA SEQUENCE NO
    Its data type is CHAR (Character String) with field length 2
  • OVRD_NET_INT_PC : OIUH_DEC9_8
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • DO_UPDT_OWN_FL : INVOICE FLAG
    Its data type is CHAR (Character String) with field length 1
  • DO_RND_FCTR_NO : ROUND FACTOR NUMBER
    Its data type is CHAR (Character String) with field length 2
  • DO_PP_BA_NO9 : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • DO_PP_BA_NO : MARKETING REP’S BA NO
    Its data type is CHAR (Character String) with field length 6
  • DO_PP_BA_SEQ_NO9 : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • DO_PP_BA_SEQ_NO : THE MARKETING REP’S BA SEQUENCE NO
    Its data type is CHAR (Character String) with field length 2
  • DO_HIST_OVRD_FL : HISTORICAL OVERRIDE FLAG
    Its data type is CHAR (Character String) with field length 1
  • DO_MMS_RECON_CD : MMS TIK CONTRACT RECONCILIATION CODE
    Its data type is CHAR (Character String) with field length 1
  • DO_VER_NO : Version number
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • DO_USER_ID : User ID
    Its data type is CHAR (Character String) with field length 8
  • DO_TIMESTAMP : TIMESTAMP
    Its data type is CHAR (Character String) with field length 14

    • OIUH_RV_DO related tables

    • OIUH_RV_MSSL_H : Oil and Gas appl table
    • OIUH_RV_STSL_H : Oil and Gas appl table
    • OIUH_RV_WOJE : Write Off JE Table
    • OIUH_RV_INSL : Journal Entry Income Subledger Table
    • OIUH_RV_OSTA : Owners State Tax Adjustments
    • OIUH_RV_AC : Account Control
    • OIUH_RV_GTAX_H : Oil and Gas appl table
    • OIUH_CM_OR4 : Organizational Level 4 Table
    • OIUH_RV_TEP : Tax Extract Profile
    • OIUH_RV_SS : Contract Spot Sale
    • OIUH_PR_RRWY : Oil and Gas appl table
    • OIUH_RV_GL : Journal Entry General Ledger Table
    • OIUH_RV_PLX : Purchaser Layout Cross Reference
    • OIUH_RV_RPTDT : Report Date
    • OIUH_RV_TR : Tract Information
    • OIUH_CM_CTTYP : Oil and Gas appl table
    • OIUH_RV_CLT : Contract — Long Term
    • OIUH_RV_ACR : Account Category Requirements
    • OIUH_X_EP2RZ : Razorfish To PRA Cross Reference
    • OIUH_RV_PDX : Obsolete (4.72)-keep for 1 minor release-Purchaser DOI Xref

    OIUH_RV_DO related transaction codes under SAP package OIU_H

    • OIUH_RD02 : A/R Reconciliation
    • OIUH_CI04 : Remitter/Layout Cross Reference
    • O3UH_OUT_CDEX : Outbound CDEX
    • O3UH_NP_SU : Negative Payment Suspense Report
    • OIUH_SRDA : Responsibility Id
    • O3UH_TC : Treasury Check
    • OIUH_CI05 : Check Input – Process Rules – CI05
    • OIUH_VL10 : Purchaser/Remitter Cross Reference
    • OIUH_JE18 : Accounts Payable Subledger Query
    • S_SOG_81000030 : IMG activity: OIUH_PREMAS_NR
    • OIUH_JE07 : General Ledger Query
    • S_SOG_81000119 : IMG activity: SIMG_SB_REV_AR
    • OIUH_JE01 : Account Maintenance
    • O3UH_ES : Escheat Processing
    • S_SOG_81000024 : IMG activity: SIMG_OIUH_CM_STATE
    • OIUH_JE16 : Expense Subledger Query
    • OIUH_TR02 : Severance Tax Master File
    • OIUH_TR01 : Tax and Royalty Profile
    • O3UH_JEPOST : JE Posting
    • O3UH_CR_NA : Create Negative Amounts

    Related References

    Related Tutorials

    OIUH_RV_DOH SAP table for – DOI Owner History

    OIUH_RV_DOH table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUH_RV_MGDH SAP table for – Marketing Group/DOI Owner Xref Header

    OIUH_RV_MGDH table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUH_RV_DOACC SAP table for – DOI Owner Override Acct Codes

    OIUH_RV_DOACC table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUH_RV_MGDD SAP table for – Marketing Group / DOI Owner Xref Detail

    OIUH_RV_MGDD table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUOW_DOACC_WK SAP table for – DOI Owner Override Account Codes Worktable

    OIUOW_DOACC_WK table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUOW_DOACC SAP table for – DOI Owner Override Account Codes

    OIUOW_DOACC table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUH_DO08 SAP tcode for – DOI Owner Accounting Entry code

    OIUH_DO08 tcode in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This transaction code is used for DOI Owner...

    «
    »