SAP Table FKK_COLLHIST_CNTXT_WLI_S

Collection History: Context for Worklist Items

FKK_COLLHIST_CNTXT_WLI_S (Collection History: Context for Worklist Items) 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 FKK_COLLHIST_CNTXT_WLI_S to other SAP tables.

FKK_COLLHIST_CNTXT_WLI_S table fields

Field Data element Checktable Datatype Length Decimals
GRPINDEX Group Index within Collection History COLLHIST_GRPIDX_KK CHAR 4 0
MANDT Client MANDT CLNT 3 0
WLIGUID Work Item: Identification WLIGUID_CM_KK CHAR 32 0
WLITYPE Work Item Type WLITYPE_CM_KK CHAR 1 0
NULL Collection Work Item
N Disconnection Notification
WLICAT Work Item: Category WLICAT_CM_KK TFK052B CHAR 2 0
STAT Work Item: Status WLISTAT_CM_KK TFK052F CHAR 1 0
SUCCDES Work Item: Collection Result WLISUCCDES_CM_KK TFK052G CHAR 2 0
RSRES Work Item: Resubmission Reason WLIRSR_CM_KK TFK052C CHAR 2 0
ASSIGNRES Work Item: Assignment Reason WLIASSIGNRES_CM_KK TFK052E CHAR 2 0
GPART Business Partner Number GPART_KK BUT000 CHAR 10 0
VKGRP Collection Management: Contract Account Group VKGRP_CM_KK CHAR 12 0
VTGRP Collection Management: Contract Group VTGRP_CM_KK CHAR 20 0
GRPFIELD Grouping Field for Dunning GRPFIELD_CM_KK CHAR 12 0
ITEMGRP Closed Item Group for Dunning ITEMGRP_CM_KK DEC 15 0
SUBAP Subapplication in Contract Accounts Receivable and Payable SUBAP_KK CHAR 1 0
9 Real Estate
ORIG Work Item: Origin WLIORIG_CM_KK CHAR 1 0
D Created from Dunning by Collection Strategy
P Created from Dunning by Dunning Procedure
I Created from Inbound Correspondence Dunning
F Follow-Up Work Item
M Created Manually
O Disconnection Order
R Reconnection Order
ORIGKEY Work Item: Key of Origin WLIORIGK_CM_KK CHAR 50 0
BUKRS Company Code BUKRS CHAR 4 0
STRAT Collection Strategy STRAT_CM_KK TFK047X CHAR 2 0
STEP Collection Step STEP_CM_KK TFK047U CHAR 4 0
MAHNV Dunning Procedure MAHNV_KK CHAR 2 0
MAHNS Dunning Level MAHNS_KK NUMC 2 0
ACKEY Activity ACKEY_KK CHAR 4 0
BETRW Amount in Transaction Currency with +/- Sign BETRW_KK CURR 13 2
WAERS Currency Key WAERS_KK CUKY 5 0
ERNAM Created by ERNAM_KK CHAR 12 0
ERDAT Created On ERDAT_I_KK DATS 8 0
ERTIM Time at which the object was created ERTIM_KK TIMS 6 0
AEDAT Changed On AEDAT DATS 8 0
AETIM Time at Which the Object Was Last Changed AETIM_KK TIMS 6 0
AENAM Last changed by AENAM_KK CHAR 12 0
XCOLLCASE Enforcement Work Item XCOLLCASE_CM_KK CHAR 1 0
X Yes
NULL No
SCORE Ranking RANK_CM_KK NUMC 4 0
SCORE_NEW New Ranking of Work Item RANK_NEW_CM_KK NUMC 4 0
PERCENTAGE Precentage Rate of Valuation SCORE_PERCENTAGE_CM_KK NUMC 4 0
XMAND Work Item: Mandatory WLIXMAND_CM_KK CHAR 1 0
X Yes
NULL No
SUBSTAT Work Item: Substatus WLISUBSTAT_CM_KK TFK052K CHAR 1 0
RSTIMESTAMP Work Item: Time Stamp of Resubmission WLIRSDAT_CM_KK DEC 15 0
ASSIGNTYP Work Item: Assignment Category WLIASSIGNTYP_CM_KK CHAR 1 0
A Assign
U Delete Assignment
R Change Assignment
WLINEXT Work Item: Identification WLIGUID_CM_KK CHAR 32 0
WLIDENT Worklist: Identification WLIDENT_CM_KK CHAR 15 0
CONTACTPERS Collections Contact Person CPERS_CM_KK CHAR 10 0
CENTER Department Assigned CENTER_CM_KK CHAR 12 0
UNIT Assigned Unit UNIT_CM_KK CHAR 12 0
AGENT Assigned Specialist AGENT_CM_KK CHAR 12 0
ACPROF Action Profile for Work Items ACPROF_CM_KK CHAR 3 0
STAKZ Type of statistical item STAKZ_KK CHAR 1 0
A Down Payment Request
B Quotation
G Other statistical receivable (charges,interest)
H Cash Security Deposit Request
I Down Payment Request from Invoicing
J Payment Request from Invoicing
K Correspondence Request
R Installment Plan Item
S Collective Bill Item
P Budget Billing Plan Item
Q Expected withholding tax deduction
T Statisitcal receivable for other taxes
Z Payment Request
STARTDATE Work Item: Earliest Start Date WLISTARTDATE_CM_KK DATS 8 0
ENDDATE Work Item: Latest End Date WLIENDDATE_CM_KK DATS 8 0
STARTTIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0
ENDTIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0
ON_HOLD Work Item on Hold WLIHOLD_CM_KK CHAR 1 0
X TRUE
NULL FALSE

FKK_COLLHIST_CNTXT_WLI_S foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FKK_COLLHIST_CNTXT_WLI_S ASSIGNRES FKK_COLLHIST_CNTXT_WLI_S MANDT TFK052E Customizing Work Item: Assignment Reason MANDT
FKK_COLLHIST_CNTXT_WLI_S ASSIGNRES FKK_COLLHIST_CNTXT_WLI_S ASSIGNRES TFK052E Customizing Work Item: Assignment Reason WLIASSIGNRES
FKK_COLLHIST_CNTXT_WLI_S ASSIGNRES ' ' TFK052E Customizing Work Item: Assignment Reason WLITYPE
FKK_COLLHIST_CNTXT_WLI_S GPART SYST MANDT BUT000 BP: General data I CLIENT
FKK_COLLHIST_CNTXT_WLI_S GPART FKK_COLLHIST_CNTXT_WLI_S GPART BUT000 BP: General data I PARTNER
FKK_COLLHIST_CNTXT_WLI_S RSRES FKK_COLLHIST_CNTXT_WLI_S RSRES TFK052C Customizing Work Item: Resubmission Reason WLIRSR
FKK_COLLHIST_CNTXT_WLI_S RSRES ' ' TFK052C Customizing Work Item: Resubmission Reason WLITYPE
FKK_COLLHIST_CNTXT_WLI_S RSRES FKK_COLLHIST_CNTXT_WLI_S MANDT TFK052C Customizing Work Item: Resubmission Reason MANDT
FKK_COLLHIST_CNTXT_WLI_S STAT FKK_COLLHIST_CNTXT_WLI_S STAT TFK052F System Table Work Item: Status STAT
FKK_COLLHIST_CNTXT_WLI_S STAT ' ' TFK052F System Table Work Item: Status WLITYPE
FKK_COLLHIST_CNTXT_WLI_S STEP SYST MANDT TFK047U Collection Step MANDT
FKK_COLLHIST_CNTXT_WLI_S STEP FKK_COLLHIST_CNTXT_WLI_S STEP TFK047U Collection Step STEP
FKK_COLLHIST_CNTXT_WLI_S STRAT SYST MANDT TFK047X Collection Strategy MANDT
FKK_COLLHIST_CNTXT_WLI_S STRAT FKK_COLLHIST_CNTXT_WLI_S STRAT TFK047X Collection Strategy STRAT
FKK_COLLHIST_CNTXT_WLI_S SUBSTAT SYST MANDT TFK052K Customizing Work Item: Substatus MANDT
FKK_COLLHIST_CNTXT_WLI_S SUBSTAT FKK_COLLHIST_CNTXT_WLI_S SUBSTAT TFK052K Customizing Work Item: Substatus WLISUBSTAT
FKK_COLLHIST_CNTXT_WLI_S SUCCDES FKK_COLLHIST_CNTXT_WLI_S MANDT TFK052G Customizing Work Item: Success Description MANDT
FKK_COLLHIST_CNTXT_WLI_S SUCCDES FKK_COLLHIST_CNTXT_WLI_S SUCCDES TFK052G Customizing Work Item: Success Description WLISUCCDES
FKK_COLLHIST_CNTXT_WLI_S SUCCDES ' ' TFK052G Customizing Work Item: Success Description WLITYPE
FKK_COLLHIST_CNTXT_WLI_S WLICAT FKK_COLLHIST_CNTXT_WLI_S MANDT TFK052B Customizing Work Item: Category MANDT
FKK_COLLHIST_CNTXT_WLI_S WLICAT FKK_COLLHIST_CNTXT_WLI_S WLICAT TFK052B Customizing Work Item: Category WLICAT
FKK_COLLHIST_CNTXT_WLI_S WLICAT ' ' TFK052B Customizing Work Item: Category WLITYPE