The DFKKCOLLITEM table in SAP ERP or S/4HANA stores Collection Units data. There are total 34 fields in DFKKCOLLITEM table. The Collection Units 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 DFKKCOLLITEM table. It is in FI-CA: Collection Agencies (FKK_COLL_AGENCY) ABAP package and is part of the Contract Accounts Receivable and Payable (FI-CA) module.
SAP DFKKCOLLITEM Table Fields
Following is the list of fields that are available in SAP DFKKCOLLITEM table. The primary key fields of Collection Units table in SAP are MANDT (Client), INKGP (Collection Agency), COLLITEM_ID (Collection Unit ID), COLLITEM_LV (Grouping Level of Collection Unit).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| INKGP | Collection Agency | INKGP_KK | TFK050B | CHAR (10) |
| COLLITEM_ID | Collection Unit ID | COLLITEM_ID_KK | CHAR (35) | |
| COLLITEM_LV | Grouping Level of Collection Unit | COLLITEM_LV_KK | CHAR (2) | |
| GPART | Business Partner Number | GPART_KK | BUT000 | CHAR (10) |
| COLLITEM_LV_PAR | Grouping Level of Parent Collection Unit | COLLITEM_LV_PAR_KK | CHAR (2) | |
| WAERS | Currency Key | WAERS_KK | TCURC | CUKY (5) |
| AINKB | Submitted Amount | AINKB_KK | CURR (13) | |
| AGDAT | Date For Submission of Receivable To Collection Agency | AGDAT_KK | DATS (8) | |
| RINKB | Called Back Amount | RINKB_KK | CURR (13) | |
| RCDAT | Date of Callback of a Submitted Receivable | RCDAT_KK | DATS (8) | |
| COLLITEM_TP | Category of Collection Unit | COLLITEM_TP_KK | TFK050T | CHAR (2) |
| COLLITEM_ST | Status of Collection Unit | COLLITEM_ST_KK | TFK050S | CHAR (2) |
| VALUT | Value Date | VALUT_KK | DATS (8) | |
| NINKB | Uncollectable Amount | NINKB_KK | CURR (13) | |
| INTBT | Interest Receivable from Collection Agency | INTST_KK | CURR (13) | |
| CHARB | Charge Receivable from External Collections Agency | CHGST_KK | CURR (13) | |
| TXTKM | Comment | TXTKM_KK | CHAR (50) | |
| PRCST | Processing Status for Outbound or Inbound | PRCST_KK | CHAR (2) | |
| LAUFD | Date ID | LAUFD_KK | DATS (8) | |
| LAUFI | Run ID | LAUFI_KK | CHAR (6) | |
| SDDAT | Send Date | SDDAT_KK | DATS (8) | |
| RVDAT | Date Received | RVDAT_KK | DATS (8) | |
| XIGUID | GUID for XI Message ID | GUIDXI_KK | RAW (16) | |
| MSGTY | Message Type | SYMSGTY | CHAR (1) | |
| MSGID | Message Class | SYMSGID | CHAR (20) | |
| MSGNO | Message Number | SYMSGNO | NUMC (3) | |
| MSGV1 | Message Variable | SYMSGV | CHAR (50) | |
| MSGV2 | Message Variable | SYMSGV | CHAR (50) | |
| MSGV3 | Message Variable | SYMSGV | CHAR (50) | |
| MSGV4 | Message Variable | SYMSGV | CHAR (50) | |
| AENAM | Last Changed By | AENAM_KK | CHAR (12) | |
| ACPDT | Date the object was last changed | ACPDT_KK | DATS (8) | |
| ACPTM | Time the object was last changed | ACPTM_KK | TIMS (6) |
