DFKKIA SAP table for – FI-CA: Database table for FKKIA – intrst supp

Here we would like to draw your attention to DFKKIA 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). DFKKIA is a SAP standard transp table used for storing FI-CA: Database table for FKKIA – intrst supp related data in SAP. It comes under the package FKKB.

SAP DFKKIA table

Table DFKKIA technical data

TableDFKKIA
Data storingFI-CA: Database table for FKKIA – intrst supp
ModuleFI
Sub ModuleFI-CA
SAP PackageFKKB
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • 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
  • 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
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes