LAW3_UI_USMM_USER_LIST_C

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 LAW3_UI_USMM_USER_LIST_C.
-- 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.
-- SQL view name: LAW3UIQUSERLIST
-- Parameters: p_datasetguid : guid, p_language : sylangu

CREATE VIEW LAW3_UI_USMM_USER_LIST_C AS
SELECT
  User.systemno AS systemno,
  User.instno AS instno,
  User.sysid AS sysid,
  User.cmandt AS cmandt,
  User.uname AS uname,
  User.lastlogin AS lastlogin,
  User.licensetype AS licensetype,
  UserType.utyptext AS utyptext,
  User.firstname AS firstname,
  User.lastname AS lastname,
  User.emailaddr AS emailaddr,
  User.accountid AS accountid,
  User.usertypecons AS usertypecons,
  User.objvalue AS objvalue,
  User.kostl AS kostl,
  User.creationdate AS creationdate,
  User.partid AS partid
FROM LAW3_UI_USMM_USER_I AS User
LEFT OUTER JOIN LAW3_UI_USER_TYPES_I ON /* join condition not captured in parsed metadata */
;