The DFKKIAPT table in SAP ERP or S/4HANA stores Interest Calculation: Log for Interest Run data. There are total 28 fields in DFKKIAPT table. The Interest Calculation: Log for Interest Run table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DFKKIAPT table. It is in FI-CA: Interest (FKK_INTEREST) ABAP package and is part of the Contract Accounts Receivable and Payable (FI-CA) module.
SAP DFKKIAPT Table Fields
Following is the list of fields that are available in SAP DFKKIAPT table. The primary key fields of Interest Calculation: Log for Interest Run table in SAP are MANDT (Client), LAUFI (Run ID), LAUFD (Date ID), GPART (Business Partner Number), VKONT (Contract Account Number), IOPBEL (Number of an interest document), IOPUPK (Item Number in FI-CA Document), OPBEL (Number of a FI-CA Document), OPUPW (Repetition Item in FI-CA Document), OPUPK (Item Number in FI-CA Document), OPUPZ (Subitem for a Partial Clearing in Document), LFDNR (Sequence Number (Internal Use Only)), XSIMU (Mass act: Simulation run).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| LAUFI | Run ID | LAUFI_KK | CHAR (6) | |
| LAUFD | Date ID | LAUFD_KK | DATS (8) | |
| GPART | Business Partner Number | GPART_KK | * | CHAR (10) |
| VKONT | Contract Account Number | VKONT_KK | * | CHAR (12) |
| IOPBEL | Number of an interest document | IOPBEL_KK | * | CHAR (12) |
| IOPUPK | Item Number in FI-CA Document | OPUPK_KK | NUMC (4) | |
| OPBEL | Number of a FI-CA Document | OPBEL_KK | * | CHAR (12) |
| OPUPW | Repetition Item in FI-CA Document | OPUPW_KK | NUMC (3) | |
| OPUPK | Item Number in FI-CA Document | OPUPK_KK | NUMC (4) | |
| OPUPZ | Subitem for a Partial Clearing in Document | OPUPZ_KK | NUMC (3) | |
| LFDNR | Sequence Number (Internal Use Only) | LFDNR_KK | NUMC (3) | |
| XSIMU | Mass act: Simulation run | FKK_XSIMU_KK | CHAR (1) | |
| ABDAT | Base Date for Interest Calculation | ABDAT_KK | DATS (8) | |
| BISDAT | End Date for Interest Calculation | BISDT_KK | DATS (8) | |
| ABWBL | Number of the Substitute FI-CA Document | ABWBL_KK | CHAR (12) | |
| ABWTP | Category of Substitute Document in FI-CA | ABWTP_KK | CHAR (1) | |
| ITYP | Interest Category | ITYP_KK | CHAR (1) | |
| WAERS | Currency Key | WAERS | * | CUKY (5) |
| BETRW | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR (13) | |
| IKEY | Interest Key | IKEY_KK | * | CHAR (2) |
| IRATE | Interest rate for int.calc. | ERATE | DEC (10) | |
| IBTRG | Interest Amount for One Period | IBTRG_KK | CURR (13) | |
| ROUND | Interest Supplement Item Created by Rounding | ROUND_KK | CHAR (1) | |
| SECURITY | Security Deposit | SECURITY_KK | * | CHAR (12) |
| IKEYD | Key Date In Month (Monthly Interest Calculation) | IKEYD_KK | NUMC (2) | |
| INOLD | Interest Already Calculated on Interest Document | INOLD_KK | CHAR (1) | |
| ITAXN | Interest Supplement Has Arisen from Tax | ITAXN_KK | CHAR (1) |
