DFKKOPCOLL SAP table for – Collection: Log of Receivables Submitted

Here we would like to draw your attention to DFKKOPCOLL 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). DFKKOPCOLL is a SAP standard transp table used for storing Collection: Log of Receivables Submitted related data in SAP. It comes under the package FKKB.

SAP DFKKOPCOLL table

Table DFKKOPCOLL technical data

TableDFKKOPCOLL
Data storingCollection: Log of Receivables Submitted
ModuleFI
Sub ModuleFI-CA
SAP PackageFKKB
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • LAUFI : Additional Identification Characteristic
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • LAUFD : Date ID
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INKGP : Collection Agency
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • INKPS : Collection Item
    Its a key field. Its data type is NUMC (Character String with Digits Only) 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
  • OPUPW : Repetition Item in Contract Account Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • OPUPK : Item number in contract account document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • OPUPZ : Subitem for a Partial Clearing in Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • XSIMU : Mass act: Simulation run
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • GPART : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • VTREF : Reference Specifications from Contract
    Its data type is CHAR (Character String) with field length 20
  • VKONT : Contract Account Number
    Its data type is CHAR (Character String) with field length 12
  • HVORG : Main Transaction for Line Item
    Its data type is CHAR (Character String) with field length 4
  • TVORG : Subtransaction for Document Item
    Its data type is CHAR (Character String) with field length 4
  • STAKZ : Type of statistical item
    Its data type is CHAR (Character String) with field length 1
  • BLDAT : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • WAERS : Transaction Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • HWAER : Local Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • FAEDN : Due date for net payment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BETRH : Amount In Local Currency With +/- Signs
    Its data type is CURR (Currency Field) with field length 13
  • BETRW : Amount in Transaction Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • AUGRD : Clearing Reason
    Its data type is CHAR (Character String) with field length 2
  • AGDAT : Date For Submission of Receivable To Collection Agency
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • NRZAS : Payment Form Number
    Its data type is CHAR (Character String) with field length 12