The DFKKCFKWL table in SAP ERP or S/4HANA stores KWL: KPI Cockpit Worklist data. There are total 30 fields in DFKKCFKWL table. The KWL: KPI Cockpit Worklist table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DFKKCFKWL table. It is in FI-CA: KPI Cockpit – Worklists (FKK_KWL) ABAP package and is part of the Contract Accounts Receivable and Payable (FI-CA) module.
SAP DFKKCFKWL Table Fields
Following is the list of fields that are available in SAP DFKKCFKWL table. The primary key fields of KWL: KPI Cockpit Worklist table in SAP are MANDT (Client), IGUID (Unique Identification).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| IGUID | Unique Identification | IGUID_KK | CHAR (32) | |
| HIGUID | Unique ID (Header) | HIGUID_KK | CHAR (32) | |
| WLHID | Worklist ID | WLHID_KK | CHAR (12) | |
| GPART | Business Partner Number | GPART_KK | BUT000 | CHAR (10) |
| VKONT | Contract Account Number | VKONT_KK | CHAR (12) | |
| VTREF | Reference Specifications from Contract | VTREF_KK | CHAR (20) | |
| SUBAP | Subapplication in Contract Accounts Receivable and Payable | SUBAP_KK | CHAR (1) | |
| OPBEL | Number of a FI-CA Document | OPBEL_KK | * | CHAR (12) |
| OPUPW | Repetition Item in FI-CA Document | OPUPW_KK | NUMC (3) | |
| OPUPK | Item Number in FI-CA Document | OPUPK_KK | NUMC (4) | |
| OPUPZ | Subitem for a Partial Clearing in Document | OPUPZ_KK | NUMC (3) | |
| WAERS | Transaction Currency | BLWAE_KK | TCURC | CUKY (5) |
| BETRW | Aggregated Amount | BETRW_AGGR_KK | CURR (23) | |
| PRIOY | Processing Priority | PRIOY_KK | NUMC (2) | |
| DUEDT | Due By | PDDAT_KK | DATS (8) | |
| ACTON | Action During Clarification | ACTIONID_KK | TFKKWL_ACT | CHAR (2) |
| XREF1 | Reference | REFER_KK | CHAR (32) | |
| XREF2 | Second Reference | REFE2_KK | CHAR (32) | |
| XREF3 | Third Reference | REFE3_KK | CHAR (32) | |
| STATE | CFC: Status of an Application Table Entry | CFC_STATE | CFC_ITEM_STATE | CHAR (2) |
| LOCK_USER | Name of the person to last change the status of the object | CFC_UNAME | * | CHAR (12) |
| LOCK_LIMIT | CFC: Lock period of a lock entry | CFC_LOCK_LIMIT | DATS (8) | |
| WORKSTATE | Processing Status of Clarification Case | CFC_WORKSTATE | CFC_IT_WORKSTATE | CHAR (2) |
| RESUBMIT_DATE | Date on which Resubmission Occurs | CFC_RESUBMIT_DATE | DATS (8) | |
| WF_COUNT | Number of Active Workflows for This Clarification Case | CFC_WORKFLOW_COUNTER | INT1 (3) | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR (12) | |
| ERDAT | Date on which the record was created | ERDAT | DATS (8) | |
| ERTIM | Time at which the object was created | ERTIM_KK | TIMS (6) | |
| TILE_ID | ID of the Fiori App Responsible for Creation | TILEID_KK | CHAR (6) |
