DFKKCOL_LOG SAP table for – Collections Agency File: Settlement Log (Payments)

Here we would like to draw your attention to DFKKCOL_LOG 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). DFKKCOL_LOG is a SAP standard transp table used for storing Collections Agency File: Settlement Log (Payments) related data in SAP. It comes under the package FKKB.

SAP DFKKCOL_LOG table

Table DFKKCOL_LOG technical data

TableDFKKCOL_LOG
Data storingCollections Agency File: Settlement Log (Payments)
ModuleFI
Sub ModuleFI-CA
SAP PackageFKKB
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • OPBEL : Number of Contract Accts Rec. & Payable Doc.
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • INKPS : Collection Item
    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
  • NRZAS : Payment Form Number
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • GPART : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • VKONT : Contract Account Number
    Its data type is CHAR (Character String) with field length 12
  • TRATYP : Transaction Category for External Collections Agency File
    Its data type is CHAR (Character String) with field length 1
  • VALUT : Value date (batch input)
    Its data type is CHAR (Character String) with field length 8
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BETRZ : Payment amount in transaction currency (batch input)
    Its data type is CHAR (Character String) with field length 16
  • NINKB : Uncollectable Amount
    Its data type is CHAR (Character String) with field length 16
  • BETRI : Interest Amount in Transaction Currency (Batch Input)
    Its data type is CHAR (Character String) with field length 16
  • BETRC : Charge Amount in Transaction Currency (Batch Input)
    Its data type is CHAR (Character String) with field length 16
  • IOPBEL : Number of an interest document
    Its data type is CHAR (Character String) with field length 12
  • GOPBEL : Number of Charge Document
    Its data type is CHAR (Character String) with field length 12
  • AOPBEL : Document Number of Write-Off Documents
    Its data type is CHAR (Character String) with field length 12
  • TXTVW : Note to Payee in Payment
    Its data type is CHAR (Character String) with field length 80
  • ERNAM : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • ERDAT : Date on which the record was created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ERZEIT : Time, at Which Record Was Added
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6