LAW3_UI_USMM_USER_I

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_I.
-- 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: LAW3UIQUSER

CREATE VIEW LAW3_UI_USMM_USER_I AS
SELECT
  Parts.datasetguid AS datasetguid,
  Parts.systemguid AS systemguid,
  Parts.sysid AS sysid,
  Parts.partid AS partid,
  Users.uname AS uname,
  Parts.datasetid AS datasetid,
  Parts.systemno AS systemno,
  Parts.instno AS instno,
  Users.cmandt AS cmandt,
  Users.creationdate AS creationdate,
  Users.lastlogin AS lastlogin,
  Users.firstname AS firstname,
  Users.lastname AS lastname,
  Users.phonenumber AS phonenumber,
  Users.emailaddr AS emailaddr,
  Users.accountid AS accountid,
  Users.classtype AS classtype,
  Users.licensetype AS licensetype,
  Users.versurcharge AS versurcharge,
  Users.surcharge AS surcharge,
  Users.externalid AS externalid,
  Users.usertypecons AS usertypecons,
  Users.charginguser AS charginguser,
  Users.kostl AS kostl,
  Objects.objname AS objname,
  Objects.objvalue AS objvalue
FROM LAW3_UI_USMM_PARTS_I AS Parts
INNER JOIN LAW3_UI_USMM_PERS_I AS Users ON /* join condition not captured in parsed metadata */
INNER JOIN law2d_usmm_pobj AS Objects ON /* join condition not captured in parsed metadata */
;