/SCWM/USR_ST_LOG

Transparent Table Application Table
7 Fields 2 CDS Views

Resource Status Log Per User

/SCWM/USR_ST_LOG is an SAP database table in S/4HANA. Resource Status Log Per User. It contains 7 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_EWM_ResourceUserLogonStatus view from BASIC Resource Status Log Per User
I_EWM_RsceUserLogonStatus_2 view_entity from BASIC Resource Status Log Per User

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY lgnum /scwm/lgnum Warehouse No.
KEY uname xubname User
KEY tstmp /scwm/de_usr_sts_tstmp Status Changed
rsrc /scwm/de_rsrc Resource
status /scwm/de_rsrc_sts Resource Status
reason /scwm/de_reason Movement Reason

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.

-- Resource Status Log Per User
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SCWM/USR_ST_LOG (
    MANDT,   -- Client [mandt]
    LGNUM,   -- Warehouse No. [/scwm/lgnum]
    UNAME,   -- User [xubname]
    TSTMP,   -- Status Changed [/scwm/de_usr_sts_tstmp]
    RSRC,    -- Resource [/scwm/de_rsrc]
    STATUS,  -- Resource Status [/scwm/de_rsrc_sts]
    REASON,  -- Movement Reason [/scwm/de_reason]
    PRIMARY KEY (MANDT, LGNUM, UNAME, TSTMP)
);

Learn More