DFKKIAPT SAP table for – Interest Calculation: Log for Interest Run

Here we would like to draw your attention to DFKKIAPT table in SAP. As we know it is being mainly used with the SAP FI-CA (Contract Accounts Receivable and Payable in FI) component which is coming under FI module (Financial Accounting). DFKKIAPT is a SAP standard transp table used for storing Interest Calculation: Log for Interest Run related data in SAP. It comes under the package FKKB.

SAP DFKKIAPT table

Table DFKKIAPT technical data

TableDFKKIAPT
Data storingInterest Calculation: Log for Interest Run
ModuleFI
Sub ModuleFI-CA
SAP PackageFKKB
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • LAUFI : Additional Identification Characteristic
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • LAUFD : Date ID
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • GPART : Business Partner Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • VKONT : Contract Account Number
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • IOPBEL : Number of an interest document
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • IOPUPK : Item number in contract account document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • OPBEL : Number of Contract Accts Rec. & Payable Doc.
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • OPUPW : Repetition Item in Contract Account Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • OPUPK : Item number in contract account document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • OPUPZ : Subitem for a Partial Clearing in Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • LFDNR : Sequence Number (Internal Use Only)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • XSIMU : Mass act: Simulation run
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • ABDAT : Base date for interest calculation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BISDAT : End date-interest calc.
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ABWBL : Number of the substitute FI-CA document
    Its data type is CHAR (Character String) with field length 12
  • ABWTP : Category of substitute document in FI-CA
    Its data type is CHAR (Character String) with field length 1
  • ITYP : Interest Category
    Its data type is CHAR (Character String) with field length 1
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BETRW : Amount in Transaction Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • IKEY : Interest Key
    Its data type is CHAR (Character String) with field length 2
  • IRATE : Interest rate for int.calc.
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • IBTRG : Interest amount for one period
    Its data type is CURR (Currency Field) with field length 13
  • ROUND : Interest Supplement Item Created by Rounding
    Its data type is CHAR (Character String) with field length 1
  • SECURITY : Security Deposit
    Its data type is CHAR (Character String) with field length 12
  • IKEYD : Key Date In Month (Monthly Interest Calculation)
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • INOLD : Interest Already Calculated on Interest Document
    Its data type is CHAR (Character String) with field length 1
  • ITAXN : Interest Supplement Has Arisen from Tax
    Its data type is CHAR (Character String) with field length 1