1. SAP Tutorial
  2. Oil & Gas

OIUH_RV_INSL SAP table for – Journal Entry Income Subledger Table

Here we would like to draw your attention to OIUH_RV_INSL 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_INSL is a SAP standard transp table used for storing Journal Entry Income Subledger Table related data in SAP. It comes under the package OIU_H.

SAP OIUH_RV_INSL table

Table OIUH_RV_INSL technical data

TableOIUH_RV_INSL
Data storingJournal Entry Income Subledger Table
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_INSL 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_INSL table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • INSL_GL_SYS_NO : OIUH_DEC18
    Its a key field. Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 18
  • NSL_ACCT_CAT_CD : OIUH_CHAR4
    Its data type is CHAR (Character String) with field length 4
  • INSL_BTU_QY : OIUH_DEC7_3
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • INSL_PS_BASE_QY : OIUH_DEC6_3
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • INSL_GRV_QY : OIUH_DEC3_1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • INSL_OWN_NO9 : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • INSL_OWN_NO : OIUH_CHAR6
    Its data type is CHAR (Character String) with field length 6
  • INSL_OWN_SEQ_NO9 : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • INSL_OWN_SEQ_NO : OIUH_CHAR2
    Its data type is CHAR (Character String) with field length 2
  • INSL_PRDR_NO9 : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • INSL_PRDR_NO : OIUH_CHAR6
    Its data type is CHAR (Character String) with field length 6
  • NSL_PRDR_SEQ_NO9 : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • NSL_PRDR_SEQ_NO : OIUH_CHAR2
    Its data type is CHAR (Character String) with field length 2
  • OWN_INT_DECM_QY : OIUH_DEC9_8
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • OWN_INT_TYPE_CD : OIUH_CHAR2
    Its data type is CHAR (Character String) with field length 2
  • OWN_INT_SEQ_NO : OIUH_CHAR2
    Its data type is CHAR (Character String) with field length 2
  • NSL_RVRS_RSN_CD : OIUH_CHAR2
    Its data type is CHAR (Character String) with field length 2
  • UNIT_OF_MEAS_CD : OIUH_CHAR3
    Its data type is CHAR (Character String) with field length 3
  • INSL_ORIG_MP_NO9 : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • INSL_ORIG_MP_NO : OIUH_CHAR6
    Its data type is CHAR (Character String) with field length 6
  • INSL_DED_RMB_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • L_DED_GR_RMB_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • INSL_ST_CD : OIUH_CHAR2
    Its data type is CHAR (Character String) with field length 2
  • OWN_BAL_DECM_QY : OIUH_DEC9_8
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • INSL_UNIT_PR_NO9 : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • INSL_UNIT_PR_NO : OIUH_CHAR8
    Its data type is CHAR (Character String) with field length 8
  • L_NET_TRANSP_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • L_NET_OTH_MK_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • SL_GR_TRANSP_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • SL_GR_OTH_MK_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • INSL_AES_FL : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • INSL_TXN_VAL_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • INSL_REMT_NO9 : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • INSL_REMT_NO : OIUH_CHAR6
    Its data type is CHAR (Character String) with field length 6
  • NSL_REMT_SEQ_NO9 : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • NSL_REMT_SEQ_NO : OIUH_CHAR2
    Its data type is CHAR (Character String) with field length 2
  • INSL_GR_PVR_AM : OIUH_DEC11_2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • INSL_OWN_PVR_AM : OIUH_DEC11_2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • MMBTU_OWN_VL_AM : OIUH_DEC11_2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • MMBTU_GR_VL_AM : OIUH_DEC11_2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • SL_RBUR_DECM_PC : OIUH_DEC9_8
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • INSL_GPLT_NO9 : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • INSL_GPLT_NO : OIUH_CHAR8
    Its data type is CHAR (Character String) with field length 8
  • NSL_GPLT_SEQ_NO9 : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • NSL_GPLT_SEQ_NO : OIUH_CHAR5
    Its data type is CHAR (Character String) with field length 5
  • INSL_TAX_RMB_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • L_TAX_GR_RMB_AM : Local amount
    Its data type is CURR (Currency Field) with field length 11
  • INSL_VER_NO : OIUH_DEC5
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • INSL_USER_ID : OIUH_CHAR8
    Its data type is CHAR (Character String) with field length 8
  • INSL_TIMESTAMP : OIUH_CHAR14
    Its data type is CHAR (Character String) with field length 14

    • OIUH_RV_INSL related tables

    • OIUH_RV_MSSL_H : Oil and Gas appl table
    • OIUH_RV_TD : Tax Detail
    • OIUH_RV_MDOI : MP/DOI Cross Reference
    • OIUH_RV_SS : Contract Spot Sale
    • OIUH_RV_MVT : Manual Void Check Transactions
    • OIUH_RV_GL : Journal Entry General Ledger Table
    • OIUH_RV_RDT : Royalty Detail For Texas
    • OIUH_CM_BAB : Oil and Gas appl table
    • OIUH_RV_RDTL : Royalty Details
    • OIUH_RV_PAC : Property Affiliated Company
    • OIUH_RV_ODED : Journal Entry Other Deductions Table
    • OIUH_RV_DTWK : Deduction/Tax Work Table
    • OIUH_RV_RBRE : Arbar Reject Table
    • OIUH_RV_SID : State Interest Defaults
    • OIUH_CM_OR2 : Organization Level 2 Table
    • OIUH_PR_TXBBA : Oil and Gas appl table
    • OIUH_RV_PR : Property Table
    • OIUH_RV_MGDH : Marketing Group/DOI Owner Xref Header
    • OIUH_RV_ARINTF : PRA Journal Entries to A/R interface table
    • OIUH_RV_RBC : Receivable Balance Categories Table

    OIUH_RV_INSL related transaction codes under SAP package OIU_H

    • O5UH_JE03 : Accounting Category
    • OIUH_SRDA : Responsibility Id
    • OIUH_JE02 : Account Entry Control
    • O3UH_VC_CP : Void/Cleared Check Purge
    • O3UH_1099 : 1099 Report
    • OIUH_RD02 : A/R Reconciliation
    • OIUH_RD03 : Owner Check
    • OIUH_CI03 : Check Layout
    • OIUH_JE07 : General Ledger Query
    • OIUH_VL10 : Purchaser/Remitter Cross Reference
    • OIUH_RD14 : Owner Interest Calculation
    • OIUH_RD04 : Owner 1099 Information
    • O3UH_CR_NA : Create Negative Amounts
    • OIUH_DO08 : DOI Owner Accounting Entry code
    • O3UH_ARWOC : A/R Write Off Cents Report
    • OIUH_JE13 : Legal Suspense Subledger Query
    • S_SOG_81000119 : IMG activity: SIMG_SB_REV_AR
    • S_SOG_81000024 : IMG activity: SIMG_OIUH_CM_STATE
    • O3UH_FLASH_UPLOAD : Upload Reporting Flashforms
    • O3UH_FT : Funds Transfer

    Related References

    Related Tutorials

    OIUH_RV_LSSL SAP table for – Journal Entry Legal Suspense Subledger Table

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

    OIUH_RV_STSL SAP table for – Journal Entry Statistical Subledger Table

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

    OIUH_RV_OPSL SAP table for – Journal Entry Owner Payable Subledger Table

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

    OIUH_TEMP_OPSL SAP table for – Journal Entry Owner Payable Subledger Table

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

    OIUH_RV_MSSL SAP table for – Journal Entry Miscellaneous Subledger Table

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

    OIUH_RV_EXSL SAP table for – Journal Entry Expense Subledger Table

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

    OIUH_RV_APSL SAP table for – Journal Entry Accounts Payable Subledger Table

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

    «
    »