I_EWM_RsceUserLogonStatus_2

DDL: I_EWM_RSCEUSERLOGONSTATUS_2 Type: view_entity BASIC
6 Fields 1 Data Sources

Resource Status Log Per User

I_EWM_RsceUserLogonStatus_2 is a Basic CDS View that provides data about "Resource Status Log Per User" in SAP S/4HANA. It reads from 1 data source (/scwm/usr_st_log) and exposes 6 fields with key fields EWMWarehouse, UserName, ResourceLogonDateTime.

Data Sources (1)

SourceAliasJoin Type
/scwm/usr_st_log /scwm/usr_st_log from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Resource Status Log Per User view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY EWMWarehouse lgnum Whse Number
KEY UserName uname User Name
KEY ResourceLogonDateTime tstmp Time Stamp
WarehouseResource rsrc Resource
ResourceUserLogonStatus status Workflow Status
ResourceUserLogoffReason reason Sp.Tax Code Reason

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_EWM_RsceUserLogonStatus_2.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_EWM_RsceUserLogonStatus_2 AS
SELECT
  lgnum AS EWMWarehouse,
  uname AS UserName,
  tstmp AS ResourceLogonDateTime,
  rsrc AS WarehouseResource,
  status AS ResourceUserLogonStatus,
  reason AS ResourceUserLogoffReason
FROM /scwm/usr_st_log
;

Learn More