The DFKKWLIA table in SAP ERP or S/4HANA stores Work Items (Work Item Type) data. There are total 52 fields in DFKKWLIA table. The Work Items (Work Item Type) table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DFKKWLIA table. It is in FI-CA: Collections Management (FKK_CM) ABAP package and is part of the Contract Accounts Receivable and Payable (FI-CA) module.
SAP DFKKWLIA Table Fields
Following is the list of fields that are available in SAP DFKKWLIA table. The primary key fields of the table are MANDT (Client), WLITYPE (Work Item Type), WLIGUID (Work Item: Identification).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| WLITYPE | Work Item Type | WLITYPE_CM_KK | CHAR (1) | |
| WLIGUID | Work Item: Identification | WLIGUID_CM_KK | CHAR (32) | |
| WLICAT | Work Item: Category | WLICAT_CM_KK | TFK052B | CHAR (2) |
| STAT | Work Item: Status | WLISTAT_CM_KK | TFK052F | CHAR (1) |
| SUCCDES | Work Item: Collection Result | WLISUCCDES_CM_KK | TFK052G | CHAR (2) |
| RSRES | Work Item: Resubmission Reason | WLIRSR_CM_KK | TFK052C | CHAR (2) |
| ASSIGNRES | Work Item: Assignment Reason | WLIASSIGNRES_CM_KK | TFK052E | CHAR (2) |
| GPART | Business Partner Number | GPART_KK | BUT000 | CHAR (10) |
| VKGRP | Collection Management: Contract Account Group | VKGRP_CM_KK | CHAR (12) | |
| VTGRP | Collection Management: Contract Group | VTGRP_CM_KK | CHAR (20) | |
| GRPFIELD | Grouping Field for Dunning | GRPFIELD_CM_KK | CHAR (12) | |
| ITEMGRP | Closed Item Group for Dunning | ITEMGRP_CM_KK | DEC (15) | |
| SUBAP | Subapplication in Contract Accounts Receivable and Payable | SUBAP_KK | CHAR (1) | |
| ORIG | Work Item: Origin | WLIORIG_CM_KK | CHAR (1) | |
| ORIGKEY | Work Item: Key of Origin | WLIORIGK_CM_KK | CHAR (50) | |
| BUKRS | Company Code | BUKRS | CHAR (4) | |
| STRAT | Collection Strategy | STRAT_CM_KK | TFK047X | CHAR (2) |
| STEP | Collection Step | STEP_CM_KK | TFK047U | CHAR (4) |
| MAHNV | Dunning Procedure | MAHNV_KK | CHAR (2) | |
| MAHNS | Dunning Level | MAHNS_KK | * | NUMC (2) |
| ACKEY | Activity | ACKEY_KK | * | CHAR (4) |
| BETRW | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR (13) | |
| WAERS | Currency Key | WAERS_KK | * | CUKY (5) |
| ERNAM | Created by | ERNAM_KK | CHAR (12) | |
| ERDAT | Created On | ERDAT_I_KK | DATS (8) | |
| ERTIM | Time at which the object was created | ERTIM_KK | TIMS (6) | |
| AEDAT | Date of Last Change | AEDAT | DATS (8) | |
| AETIM | Time at Which the Object Was Last Changed | AETIM_KK | TIMS (6) | |
| AENAM | Last Changed By | AENAM_KK | CHAR (12) | |
| XCOLLCASE | Enforcement Work Item | XCOLLCASE_CM_KK | CHAR (1) | |
| SCORE | Ranking | RANK_CM_KK | NUMC (4) | |
| SCORE_NEW | New Ranking of Work Item | RANK_NEW_CM_KK | NUMC (4) | |
| PERCENTAGE | Precentage Rate of Valuation | SCORE_PERCENTAGE_CM_KK | NUMC (4) | |
| XMAND | Work Item: Mandatory | WLIXMAND_CM_KK | CHAR (1) | |
| SUBSTAT | Work Item: Substatus | WLISUBSTAT_CM_KK | TFK052K | CHAR (1) |
| RSTIMESTAMP | Work Item: Time Stamp of Resubmission | WLIRSDAT_CM_KK | DEC (15) | |
| ASSIGNTYP | Work Item: Assignment Category | WLIASSIGNTYP_CM_KK | CHAR (1) | |
| WLINEXT | Work Item: Identification | WLIGUID_CM_KK | CHAR (32) | |
| WLIDENT | Worklist: Identification | WLIDENT_CM_KK | CHAR (15) | |
| CONTACTPERS | Collections Contact Person | CPERS_CM_KK | * | CHAR (10) |
| CENTER | Department Assigned | CENTER_CM_KK | CHAR (12) | |
| UNIT | Assigned Unit | UNIT_CM_KK | CHAR (12) | |
| AGENT | Assigned Specialist | AGENT_CM_KK | CHAR (12) | |
| ACPROF | Action Profile for Work Items | ACPROF_CM_KK | CHAR (3) | |
| STAKZ | Type of statistical item | STAKZ_KK | CHAR (1) | |
| STARTDATE | Work Item: Earliest Start Date | WLISTARTDATE_CM_KK | DATS (8) | |
| ENDDATE | Work Item: Latest End Date | WLIENDDATE_CM_KK | DATS (8) | |
| STARTTIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) | |
| ENDTIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) | |
| ON_HOLD | Work Item on Hold | WLIHOLD_CM_KK | CHAR (1) | |
| CLOSECHECKDT | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) |
