OICINT_CAL SAP table for – Interest calculation

Here we would like to draw your attention to OICINT_CAL table in SAP. As we know it is being mainly used with the SAP IS-OIL-DS (Downstream in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OICINT_CAL is a SAP standard transp table used for storing Interest calculation related data in SAP. It comes under the package OIC_SDP.

SAP OICINT_CAL table

Table OICINT_CAL technical data

TableOICINT_CAL
Data storingInterest calculation
ModuleIS-OIL
Sub ModuleIS-OIL-DS-MAP
SAP PackageOIC_SDP
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OICINT_CAL 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 OICINT_CAL table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • VBELN : Billing document
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • INTTYPE : Interest type for interest calculation
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • FROM_DATE : From date for interest calculation
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TO_DATE : To date for interest calculation
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DIFFDAYS : Difference between from and to date
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • DAILY_RATE : Daily rate for interest calculation
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • AMT_BAL : Balance amount
    Its data type is CURR (Currency Field) with field length 15
  • INT_AMT : Interest amount for interest calculation
    Its data type is CURR (Currency Field) with field length 15
  • REFERENZ : Reference Interest Rate
    Its data type is CHAR (Character String) with field length 10
  • MARGIN : Margin rate for interest calculation
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • DATE_CALC : Date calculation exit
    Its data type is NUMC (Character String with Digits Only) with field length 3