LXE_WRKOBS

Transparent Table Temporary Data
27 Fields 3 CDS Views

Objects in Worklists

LXE_WRKOBS is an SAP database table in S/4HANA. Objects in Worklists. It contains 27 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
LXE_WRK_ALL view union all work lists (D,O,S,X,Y,Z)
LXE_WRK_SUM view union all work lists (D,X,Y,Z ....)
LXE_WRK_SUM_WD view union all work lists - using word count

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY targ_lang LXEISOLANG Language
KEY custmnr LXECUSTMNR Translatn Area
KEY objtype LXEOBJTYPE Translation OType
KEY objname LXEOBJNAME Object Name
domatyp LXEDOMATYP Domain Type
domanam LXEDOMANAM Domain Name
colltyp LXECOLLTYP Collection Type
collnam LXECOLLNAM Collection
orig_lang LXEISOLANG Language
sour_lang LXEISOLANG Language
wlistid LXEWLISTID Worklist Number
statwkl LXESTATWKL WL Status
statdrv LXESTATDRV Secon. TStatus
stattrn LXESTATTRN Object Status
cnttot LXECNTTOT Total Units
cntnew LXECNTNEW New Units
cntmod LXECNTMOD Modified Units
cntavl LXECNTAVL Available Units
uname AS4USER Last Changed By
udate AS4DATE Date
utime AS4TIME Time
resrvid LXERESRVID Reservation No.
statrsv LXESTATRSV Reservation status
wcnttot LXECNTTOT Total Units
wcntnew LXECNTNEW New Units
wcntmod LXECNTMOD Modified Units
wcntavl LXECNTAVL Available Units

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.

-- Objects in Worklists
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LXE_WRKOBS (
    TARG_LANG,  -- Language [LXEISOLANG]
    CUSTMNR,    -- Translatn Area [LXECUSTMNR]
    OBJTYPE,    -- Translation OType [LXEOBJTYPE]
    OBJNAME,    -- Object Name [LXEOBJNAME]
    DOMATYP,    -- Domain Type [LXEDOMATYP]
    DOMANAM,    -- Domain Name [LXEDOMANAM]
    COLLTYP,    -- Collection Type [LXECOLLTYP]
    COLLNAM,    -- Collection [LXECOLLNAM]
    ORIG_LANG,  -- Language [LXEISOLANG]
    SOUR_LANG,  -- Language [LXEISOLANG]
    WLISTID,    -- Worklist Number [LXEWLISTID]
    STATWKL,    -- WL Status [LXESTATWKL]
    STATDRV,    -- Secon. TStatus [LXESTATDRV]
    STATTRN,    -- Object Status [LXESTATTRN]
    CNTTOT,     -- Total Units [LXECNTTOT]
    CNTNEW,     -- New Units [LXECNTNEW]
    CNTMOD,     -- Modified Units [LXECNTMOD]
    CNTAVL,     -- Available Units [LXECNTAVL]
    UNAME,      -- Last Changed By [AS4USER]
    UDATE,      -- Date [AS4DATE]
    UTIME,      -- Time [AS4TIME]
    RESRVID,    -- Reservation No. [LXERESRVID]
    STATRSV,    -- Reservation status [LXESTATRSV]
    WCNTTOT,    -- Total Units [LXECNTTOT]
    WCNTNEW,    -- New Units [LXECNTNEW]
    WCNTMOD,    -- Modified Units [LXECNTMOD]
    WCNTAVL,    -- Available Units [LXECNTAVL]
    PRIMARY KEY (TARG_LANG, CUSTMNR, OBJTYPE, OBJNAME)
);

Learn More