I_SWI_WIIinvUsers

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_SWI_WIIinvUsers.
-- 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_SWI_WIIinvUsers AS
SELECT
  swwuserwi.wi_id AS WorkItem,
  swwuserwi.user_id AS UserId,
  cast (case when usr02.gltgv > $session.system_date or usr02.gltgb < $session.system_date and usr02.gltgb > '00000000' then 1 when usracl.pname is null and usr02.uflag = 128 then 2 when usr02.uflag < 128 then 2 else 5 end as sww_user_invalidation_reason preserving type) as InvalidationReason AS wi_idasWorkItem,
  cast(3 as sww_user_invalidation_reason preserving type) AS InvalidationReason
FROM swwuserwi
INNER JOIN usr02 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usracl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usr02 ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): swwuserwi
;