1. SAP Tutorial
  2. FI Module

DFKKCOLL SAP table for – Admin. Data for Sumbission of Receivables for Coll. Agency

Here we would like to draw your attention to DFKKCOLL 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). DFKKCOLL is a SAP standard transp table used for storing Admin. Data for Sumbission of Receivables for Coll. Agency related data in SAP. It comes under the package FKKB.

SAP DFKKCOLL table

Table DFKKCOLL technical data

TableDFKKCOLL
Data storingAdmin. Data for Sumbission of Receivables for Coll. Agency
ModuleFI
Sub ModuleFI-CA
SAP PackageFKKB
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

SAP DFKKCOLL 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 DFKKCOLL 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
  • INKGP : Collection Agency
    Its data type is CHAR (Character String) with field length 10
  • BUKRS : Company Code
    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
  • VKONT : Contract Account Number
    Its data type is CHAR (Character String) with field length 12
  • AGDAT : Date For Submission of Receivable To Collection Agency
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AGGRD : Reason For Submitting An Item To Collection Agency
    Its data type is CHAR (Character String) with field length 2
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BETRW : Amount in Transaction Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • BETRZ : Payment amount in transaction currency
    Its data type is CURR (Currency Field) with field length 13
  • NINKB : Uncollectable Amount
    Its data type is CURR (Currency Field) with field length 13
  • INTBT : Interest Receivable from Collection Agency
    Its data type is CURR (Currency Field) with field length 13
  • CHARB : Charge Receivable from External Collections Agency
    Its data type is CURR (Currency Field) with field length 13
  • XBLNR : Reference document number
    Its data type is CHAR (Character String) with field length 16
  • AGSTA : Status of Item Submitted to Collection Agency
    Its data type is CHAR (Character String) with field length 2
  • XSOLD : Item Sold to Collection Agency
    Its data type is CHAR (Character String) with field length 1
  • NRZAS : Payment Form Number
    Its data type is CHAR (Character String) with field length 12
  • RUDAT : Recall Date of Receivable from External Collection Agency
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RUGRD : Callback Reason for Submitted Items
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes

    • DFKKCOLL related tables

    • TFKZVAR : Value Adjustment Variants – Definition of Age Grid
    • TFK044C : FI-CA Valuation Variant
    • TFK_PAYMENTREL : FI-CA: Customizing Payment Release Disbursements
    • TFK045E : Returns Activities (Returns Lot)
    • TFK058A : Rules for Additional Receivables (Attributes)
    • TFKZVARIT : Value Adjustment Variants
    • TFK005 : Term for Archiving Objects
    • TFK020U : Regrouping Accounts
    • TFK042FG : Level of Detail When Creating Payment Medium (Refinement)
    • TFK047ET : Texts for Charges Schema
    • TFKIVV : Assignment of Internal Transactions to External Transactions
    • TFKK_SELP_OP : Selection Types for OI Reports
    • ARCH_FKKOP : FI-CA doc: Header-oriented doc index for archive
    • DFKKCFNR : Clarification Cases from NOC Returns Lot
    • TFK044F : Valuation Plan Variants
    • TFKITVORT : Internal Sub-Transactions
    • DFKKOPKX : Items for Contract Accounting Document (Enhancement)
    • DFKKCFDUNTEL : Telephone List for Dunning
    • DFKKMOPK : Items in contract account document
    • DFKKZAX : Repayment Request (Address Data for Check)

    DFKKCOLL related transaction codes under SAP package FKKB

    • FPB4 : Payment Lot Transfer Error Process.
    • S_KK4_74002424 : IMG Activity: _ISUFICAEURO_000001
    • EK79 : Default values for cash deposit int.
    • FPCHV : Voiding of Checks from Payment Run
    • S_KK4_74002401 : IMG Activity: _FICABFOI_FQZP
    • FQZE : FI-CA: Acct Det. – G/L Transfer
    • FPAR04 : FI-CA: Gen. Tax Reporting Archiving
    • FPC1 : FI-CA Dunning – Cust.Dunn. Procedure
    • FPN3 : Number Range Maintenance: FKK_ZAUFT
    • FQCF : User ID for Bank Transactions
    • FPN6_10Y : Number Range Maintenance: FKK_ED10Y
    • S_KK4_74002130 : IMG Activity: _FICABTDU_VC_TFK047E
    • S_KK4_74002265 : IMG Activity: _ISISFICA_IBR23
    • FPARCJ0 : FI-CA: Cash Journal Runtime
    • FQZC : FI-CA: Account Det. – Cash Discount
    • FPL9 : Display Account Balance
    • S_KK4_74002270 : IMG Activity: _FICABTWO_FQZ04
    • FPTCRPO : Credit Processing
    • FPACTEN : Create Customer Notifications
    • FPPCTS : PCARD: Items to be invoiced

    Related References

    Related Tutorials

    DFKKCOLLH SAP table for – Management Data for Submission to Coll. Agency (History)

    DFKKCOLLH table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    DFKKCOLLP_IM_W SAP table for – Buffer: Coll. Agency Info File (Item Master Data Change)

    DFKKCOLLP_IM_W table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    FP03D SAP tcode for – Submit Receivables to Coll. Agency

    FP03D tcode in SAP FI (Contract Accounts Receivable and Payable in FI) module. This transaction code is used for Submit...

    FP03U SAP tcode for – Call Back Receivables fm Coll.Agency

    FP03U tcode in SAP FI (Contract Accounts Receivable and Payable in FI) module. This transaction code is used for Call...

    TFK050A SAP table for – Status of Receivables for Submission to Collection Agency

    TFK050A table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    TFK050DT SAP table for – Callback Reasons for Items Submitted to Coll. Agency (Texts)

    TFK050DT table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    DFKKCOLLH_I_W SAP table for – Buffer: Collection Agency Information File (Header Data)

    DFKKCOLLH_I_W table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    «
    »