DFKKCFKWL

Transparent Table Application Table
30 Fields 2 CDS Views

KWL: KPI Cockpit Worklist

DFKKCFKWL is an SAP database table in S/4HANA. KWL: KPI Cockpit Worklist. It contains 30 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CAWorklistItem view from BASIC Arbeitsliste - Positionsdaten
view_o2c_fica_wl_data view from CDS View Worklist Data for Business Partner

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY iguid IGUID_KK CGUID
higuid HIGUID_KK HIGUID
wlhid WLHID_KK Worklist ID
gpart GPART_KK Bus. Partner
vkont VKONT_KK Contract Acct
vtref VTREF_KK Contract
subap SUBAP_KK Subapplication
opbel OPBEL_KK Document Number
opupw OPUPW_KK Repetition Item
opupk OPUPK_KK Item
opupz OPUPZ_KK Subitem
waers BLWAE_KK Currency
betrw BETRW_AGGR_KK Amount
prioy PRIOY_KK Priority
duedt PDDAT_KK Due By
acton ACTIONID_KK Action
xref1 REFER_KK Reference
xref2 REFE2_KK 2nd Reference
xref3 REFE3_KK Third Reference
state CFC_STATE Status
lock_user CFC_UNAME Last Processor
lock_limit CFC_LOCK_LIMIT Valid To
workstate CFC_WORKSTATE Proc. Status
resubmit_date CFC_RESUBMIT_DATE Resubmission On
wf_count CFC_WORKFLOW_COUNTER Active workflows
ernam ERNAM Created By
erdat ERDAT Created On
ertim ERTIM_KK Time
tile_id TILEID_KK App ID

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- KWL: KPI Cockpit Worklist
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKCFKWL (
    MANDT,          -- Client [MANDT]
    IGUID,          -- CGUID [IGUID_KK]
    HIGUID,         -- HIGUID [HIGUID_KK]
    WLHID,          -- Worklist ID [WLHID_KK]
    GPART,          -- Bus. Partner [GPART_KK]
    VKONT,          -- Contract Acct [VKONT_KK]
    VTREF,          -- Contract [VTREF_KK]
    SUBAP,          -- Subapplication [SUBAP_KK]
    OPBEL,          -- Document Number [OPBEL_KK]
    OPUPW,          -- Repetition Item [OPUPW_KK]
    OPUPK,          -- Item [OPUPK_KK]
    OPUPZ,          -- Subitem [OPUPZ_KK]
    WAERS,          -- Currency [BLWAE_KK]
    BETRW,          -- Amount [BETRW_AGGR_KK]
    PRIOY,          -- Priority [PRIOY_KK]
    DUEDT,          -- Due By [PDDAT_KK]
    ACTON,          -- Action [ACTIONID_KK]
    XREF1,          -- Reference [REFER_KK]
    XREF2,          -- 2nd Reference [REFE2_KK]
    XREF3,          -- Third Reference [REFE3_KK]
    STATE,          -- Status [CFC_STATE]
    LOCK_USER,      -- Last Processor [CFC_UNAME]
    LOCK_LIMIT,     -- Valid To [CFC_LOCK_LIMIT]
    WORKSTATE,      -- Proc. Status [CFC_WORKSTATE]
    RESUBMIT_DATE,  -- Resubmission On [CFC_RESUBMIT_DATE]
    WF_COUNT,       -- Active workflows [CFC_WORKFLOW_COUNTER]
    ERNAM,          -- Created By [ERNAM]
    ERDAT,          -- Created On [ERDAT]
    ERTIM,          -- Time [ERTIM_KK]
    TILE_ID,        -- App ID [TILEID_KK]
    PRIMARY KEY (MANDT, IGUID)
);

Learn More