DFKKCOLLPAYM SAP (Collection Payments) Table details
Dictionary Type: Table
Description: Collection Payments
Description: Collection Payments
Table field list including key, data, relationships and ABAP select examples
DFKKCOLLPAYM is a standard SAP Table which is used to store Collection Payments data and is available within R/3 SAP systems depending on the version and release level.
The DFKKCOLLPAYM table consists of various fields, each holding specific information or linking keys about Collection Payments data available in SAP. These include INKGP (Collection Agency), COLLPAYM_ID (ID of Collection Payment), COLLPAYM_TP (Category of Collection Payment), TSPNR (Time Stamp with Sequential Number (Internal Use Only)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP DFKKCOLLPAYM table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| INKGP | Collection Agency | INKGP_KK | CHAR | 10 | TFK050B | ALPHA | BU_PARTNER | ||
| COLLPAYM_ID | ID of Collection Payment | COLLPAYM_ID_KK | CHAR | 35 | |||||
| COLLPAYM_TP | Category of Collection Payment | COLLPAYM_TP_KK | CHAR | 1 | COLLPAYM_TP_KK | ||||
| TSPNR | Time Stamp with Sequential Number (Internal Use Only) | TSPNR_KK | CHAR | 16 | |||||
| COLLPAYM_KY | Grouping Key for Collection Payments | COLLPAYM_KY_KK | CHAR | 16 | COLLPAYM_KY_KK | ||||
| GPART | Business Partner Number | GPART_KK | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | |
| BETRW | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR | 13(2) | WRTV7 | ||||
| WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
| VALUT | Value Date | VALUT_KK | DATS | 8 | DATUM | ||||
| REVDT | Reversal Date | REVDT_KK | DATS | 8 | DATUM | ||||
| CHCKN | Check number | CHCKN_KK | CHAR | 13 | CHCKN | ||||
| TXTKM | Comment | TXTKM_KK | CHAR | 50 | TXT50 | ||||
| OPBEL | Number of Contract Accts Rec. & Payable Doc. | OPBEL_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | 80B | |
| PRCST | Processing Status for Outbound or Inbound | PRCST_KK | CHAR | 2 | PRCST_KK | ||||
| LAUFD | Date ID | LAUFD_KK | DATS | 8 | DATUM | ||||
| LAUFI | Additional Identification Characteristic | LAUFI_KK | CHAR | 6 | LAUFI_KK | ||||
| SDDAT | Send Date | SDDAT_KK | DATS | 8 | DATUM | ||||
| RVDAT | Date Received | RVDAT_KK | DATS | 8 | DATUM | ||||
| XIGUID | GUID for XI Message ID | GUIDXI_KK | RAW | 16 | SYSUUID | ||||
| MSGTY | Message Type | SYMSGTY | CHAR | 1 | SYCHAR01 | ||||
| MSGID | Message Class | SYMSGID | CHAR | 20 | Assigned to domain | ARBGB | |||
| MSGNO | Message Number | SYMSGNO | NUMC | 3 | SYMSGNO | ||||
| MSGV1 | Message Variable | SYMSGV | CHAR | 50 | SYCHAR50 | ||||
| MSGV2 | Message Variable | SYMSGV | CHAR | 50 | SYCHAR50 | ||||
| MSGV3 | Message Variable | SYMSGV | CHAR | 50 | SYCHAR50 | ||||
| MSGV4 | Message Variable | SYMSGV | CHAR | 50 | SYCHAR50 | ||||
| AENAM | Last changed by | AENAM_KK | CHAR | 12 | USNAM | ||||
| ACPDT | Date the object was last changed | ACPDT_KK | DATS | 8 | DATUM | ||||
| ACPTM | Time the object was last changed | ACPTM_KK | TIMS | 6 | UZEIT |
| Key field | Non-key field |
How do I retrieve data from SAP table DFKKCOLLPAYM using ABAP code
The following ABAP code Example will allow you to do a basic selection on DFKKCOLLPAYM to SELECT all data from the tableDATA: WA_DFKKCOLLPAYM TYPE DFKKCOLLPAYM.
SELECT SINGLE *
FROM DFKKCOLLPAYM
INTO CORRESPONDING FIELDS OF WA_DFKKCOLLPAYM
WHERE...
How to access SAP table DFKKCOLLPAYM
Within an ECC or HANA version of SAP you can also view further information about DFKKCOLLPAYM and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects