/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