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