1. Home
  2. Resources
  3. SAP Tables
  4. DFKKWLI - Work Items

SAP Table DFKKWLI

Work Items

DFKKWLI (Work 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 DFKKWLI to other SAP tables.

DFKKWLI table fields

Field Data element Checktable Datatype Length Decimals
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

DFKKWLI foreign key relationships

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