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