The DFKKWLIH table in SAP ERP or S/4HANA stores Work Items (History) data. There are total 23 fields in DFKKWLIH table. The Work Items (History) 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 DFKKWLIH 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 DFKKWLIH Table Fields
Following is the list of fields that are available in SAP DFKKWLIH table. The primary key fields of the table are MANDT (Client), WLIGUID (Work Item: Identification), AEDAT (Date of Last Change), AETIM (Time at Which the Object Was Last Changed).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| WLIGUID | Work Item: Identification | WLIGUID_CM_KK | CHAR (32) | |
| AEDAT | Date of Last Change | AEDAT | DATS (8) | |
| AETIM | Time at Which the Object Was Last Changed | AETIM_KK | TIMS (6) | |
| WLITYPE | Work Item Type | WLITYPE_CM_KK | CHAR (1) | |
| AENAM | Last Changed By | AENAM_KK | CHAR (12) | |
| SCORE | Ranking | RANK_CM_KK | NUMC (4) | |
| XMAND | Work Item: Mandatory | WLIXMAND_CM_KK | CHAR (1) | |
| STAT | Work Item: Status | WLISTAT_CM_KK | * | CHAR (1) |
| SUBSTAT | Work Item: Substatus | WLISUBSTAT_CM_KK | * | CHAR (1) |
| SUCCDES | Work Item: Collection Result | WLISUCCDES_CM_KK | * | CHAR (2) |
| RSTIMESTAMP | Work Item: Time Stamp of Resubmission | WLIRSDAT_CM_KK | DEC (15) | |
| RSREAS | Work Item: Resubmission Reason | WLIRSR_CM_KK | * | CHAR (2) |
| ASSIGNTYP | Work Item: Assignment Category | WLIASSIGNTYP_CM_KK | CHAR (1) | |
| ASSIGNRES | Work Item: Assignment Reason | WLIASSIGNRES_CM_KK | * | CHAR (2) |
| WLINEXT | Work Item: Identification | WLIGUID_CM_KK | CHAR (32) | |
| ILSTAT | Status of Item List | ILSTAT_CM_KK | CHAR (1) | |
| CONTACTPERS | Business Partner Number | GPART_KK | * | CHAR (10) |
| CENTER | Assigned Collections Department | WLICENTER_CM_KK | CHAR (12) | |
| UNIT | Assigned Collections Unit | WLIUNIT_CM_KK | CHAR (12) | |
| AGENT | Collection Specialist Assigned | WLIAGENT_CM_KK | CHAR (12) | |
| STARTTIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) | |
| ENDTIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) |
