SAP Table DFKKCOLLH

Management Data for Submission to Coll. Agency (History)

DFKKCOLLH (Management Data for Submission to Coll. Agency (History)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link DFKKCOLLH to other SAP tables.

DFKKCOLLH table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
OPBEL Number of Contract Accts Rec. & Payable Doc. OPBEL_KK DFKKKO CHAR 12 0
INKPS Collection Item INKPS_KK NUMC 3 0
LFDNR Sequence Number (Internal Use Only) LFDNR_KK NUMC 3 0
INKGP Collection Agency INKGP_KK TFK050B CHAR 10 0
BUKRS Company Code BUKRS CHAR 4 0
GPART Business Partner Number GPART_KK CHAR 10 0
VKONT Contract Account Number VKONT_KK CHAR 12 0
AGDAT Date For Submission of Receivable To Collection Agency AGDAT_KK DATS 8 0
AGGRD Reason For Submitting An Item To Collection Agency AGGRD_KK CHAR 2 0
01 Failed dunning procedure
02 Write-Off
03 Mass run: Write-off
04 Dunning activity
05 Mass run: Release receivables for submission to coll. agency
06 Release receivables for submission to collection agencies
WAERS Currency Key WAERS_KK TCURC CUKY 5 0
BETRW Amount in Transaction Currency with +/- Sign BETRW_KK CURR 13 2
BETRZ Payment amount in transaction currency BETRZ_KK CURR 13 2
NINKB Uncollectable Amount NINKB_KK CURR 13 2
INTBT Interest Receivable from Collection Agency INTST_KK CURR 13 2
CHARB Charge Receivable from External Collections Agency CHGST_KK CURR 13 2
XBLNR Reference document number XBLNR_KK CHAR 16 0
AGSTA Status of Item Submitted to Collection Agency AGSTA_KK TFK050A CHAR 2 0
AGSTA_OR Original Status of Item Submitted to Collection Agency AGSTAR_KK CHAR 2 0
01 Receivable Released for Submission
02 Receivable Submitted
03 Receivable Paid by Collection Agency
04 Receivable Partially Paid by Collection Agency
05 Submission of Receivable Cancelled
06 Submission of Receivable Failed
07 Recvbl Partially Paid and Subm. of Outstandg Recvbl Reversed
08 Receivable Partially Paid and Partially Uncollectable
09 Receivable Recalled
10 Receivable Paid Directly by Customer
11 Receivable Partially Paid Directly by Customer
12 Receivable Cleared
13 Receivable Partially Cleared
XSOLD Item Sold to Collection Agency XSOLD_KK CHAR 1 0
X Yes
NULL No
NRZAS Payment Form Number NRZAS_KK CHAR 12 0
RUDAT Reporting Date of Receivable from External Collection Agency RGDAT_KK DATS 8 0
RUGRD Callback Reason for Submitted Items DEAGR_KK TFK050D CHAR 2 0
AUGBL Clearing Document or Printed Document AUGBL_KK CHAR 12 0
STORB Number of Reversal Document STORB_KK CHAR 12 0
AENAM Last changed by AENAM_KK CHAR 12 0
ACPDT Date the object was last changed ACPDT_KK DATS 8 0
ACPTM Time the object was last changed ACPTM_KK TIMS 6 0

DFKKCOLLH foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
DFKKCOLLH AGSTA DFKKCOLLH AGSTA TFK050A Status of Receivables for Submission to Collection Agency AGSTA
DFKKCOLLH AGSTA DFKKCOLLH MANDT TFK050A Status of Receivables for Submission to Collection Agency MANDT
DFKKCOLLH INKGP DFKKCOLLH MANDT TFK050B Collection Agencies MANDT
DFKKCOLLH INKGP DFKKCOLLH INKGP TFK050B Collection Agencies INKGP
DFKKCOLLH MANDT DFKKCOLLH MANDT T000 Clients MANDT
DFKKCOLLH OPBEL DFKKCOLLH OPBEL DFKKKO Header Data in Open Item Accounting Document OPBEL
DFKKCOLLH OPBEL DFKKCOLLH MANDT DFKKKO Header Data in Open Item Accounting Document MANDT
DFKKCOLLH RUGRD DFKKCOLLH MANDT TFK050D Callback Reason for Items Submitted to Collection Agency MANDT
DFKKCOLLH RUGRD DFKKCOLLH RUGRD TFK050D Callback Reason for Items Submitted to Collection Agency DEAGR
DFKKCOLLH WAERS DFKKCOLLH MANDT TCURC Currency Codes MANDT
DFKKCOLLH WAERS DFKKCOLLH WAERS TCURC Currency Codes WAERS