SAP DFKKCOLLH Management Data for Submission to Coll. Agency (History) Table data and field list

DFKKCOLLH is a standard SAP Table which is used to store Management Data for Submission to Coll. Agency (History) data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The DFKKCOLLH table consists of various fields, each holding specific information or linking keys about Management Data for Submission to Coll. Agency (History) data available in SAP. These include OPBEL (Number of Contract Accts Rec. & Payable Doc.), INKPS (Collection Item), LFDNR (Sequence Number (Internal Use Only)), INKGP (Collection Agency)... 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. .

DFKKCOLLH table Technical Details:

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 DFKKCOLLH table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the DFKKCOLLH table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
OPBELNumber of Contract Accts Rec. & Payable Doc. OPBEL_KKCHAR12DFKKKOALPHAOPBEL_KK80B
INKPSCollection Item INKPS_KKNUMC3NUM03
LFDNRSequence Number (Internal Use Only) LFDNR_KKNUMC3NUMC3
INKGPCollection Agency INKGP_KKCHAR10TFK050BALPHABU_PARTNER
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
GPARTBusiness Partner Number GPART_KKCHAR10Assigned to domainALPHABU_PARTNERBPA
VKONTContract Account Number VKONT_KKCHAR12Assigned to domainALPHAVKONT_KKKTOFKKVKP_F4
AGDATDate For Submission of Receivable To Collection Agency AGDAT_KKDATS8DATUM
AGGRDReason For Submitting An Item To Collection Agency AGGRD_KKCHAR2AGGRD_KKAGG
WAERSCurrency Key WAERS_KKCUKY5TCURCWAERSFWS
BETRWAmount in Transaction Currency with +/- Sign BETRW_KKCURR13(2) WRTV7
BETRZPayment amount in transaction currency BETRZ_KKCURR13(2) WRTV7
NINKBUncollectable Amount NINKB_KKCURR13(2) WRTV7
INTBTInterest Receivable from Collection Agency INTST_KKCURR13(2) WRTV7
CHARBCharge Receivable from External Collections Agency CHGST_KKCURR13(2) WRTV7
XBLNRReference document number XBLNR_KKCHAR16ALPHAXBLNR_KK
AGSTAStatus of Item Submitted to Collection Agency AGSTA_KKCHAR2TFK050AAGSTA_KKAGS
AGSTA_OROriginal Status of Item Submitted to Collection Agency AGSTAR_KKCHAR2AGSTAR_KKAGS
XSOLDItem Sold to Collection Agency XSOLD_KKCHAR1XFELD
NRZASPayment Form Number NRZAS_KKCHAR12ALPHANRZAS_KK
RUDATReporting Date of Receivable from External Collection Agency RGDAT_KKDATS8DATUM
RUGRDCallback Reason for Submitted Items DEAGR_KKCHAR2TFK050DDEAGR_KK
AUGBLClearing Document or Printed Document AUGBL_KKCHAR12ALPHAAUGBL_KK
STORBNumber of Reversal Document STORB_KKCHAR12Assigned to domainALPHAOPBEL_KK
AENAMLast changed by AENAM_KKCHAR12USNAM
ACPDTDate the object was last changed ACPDT_KKDATS8DATUM
ACPTMTime the object was last changed ACPTM_KKTIMS6UZEIT

Key field Non-key field



How do I retrieve data from SAP table DFKKCOLLH using ABAP code

The following ABAP code Example will allow you to do a basic selection on DFKKCOLLH to SELECT all data from the table
DATA: WA_DFKKCOLLH TYPE DFKKCOLLH.

SELECT SINGLE *
FROM DFKKCOLLH
INTO CORRESPONDING FIELDS OF WA_DFKKCOLLH
WHERE...

How to access SAP table DFKKCOLLH

Within an ECC or HANA version of SAP you can also view further information about DFKKCOLLH and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).