The DFKKCOLLPAYM table in SAP ERP or S/4HANA stores Collection Payments data. There are total 29 fields in DFKKCOLLPAYM table. The Collection Payments 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 DFKKCOLLPAYM 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 DFKKCOLLPAYM Table Fields
Following is the list of fields that are available in SAP DFKKCOLLPAYM table. The primary key fields of Collection Payments table in SAP are MANDT (Client), INKGP (Collection Agency), COLLPAYM_ID (ID of Collection Payment), COLLPAYM_TP (Category of Collection Payment).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| INKGP | Collection Agency | INKGP_KK | TFK050B | CHAR (10) |
| COLLPAYM_ID | ID of Collection Payment | COLLPAYM_ID_KK | CHAR (35) | |
| COLLPAYM_TP | Category of Collection Payment | COLLPAYM_TP_KK | CHAR (1) | |
| COLLPAYM_KY | Grouping Key for Collection Payments | COLLPAYM_KY_KK | CHAR (16) | |
| GPART | Business Partner Number | GPART_KK | CHAR (10) | |
| BETRW | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR (13) | |
| WAERS | Currency Key | WAERS | TCURC | CUKY (5) |
| VALUT | Value Date | VALUT_KK | DATS (8) | |
| REVDT | Reversal Date | REVDT_KK | DATS (8) | |
| CHCKN | Check number | CHCKN_KK | CHAR (13) | |
| TXTKM | Comment | TXTKM_KK | CHAR (50) | |
| OPBEL | Number of a FI-CA Document | OPBEL_KK | CHAR (12) | |
| 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) |
