ATOV_USER_ASSIGNMENT

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 ATOV_USER_ASSIGNMENT.
-- 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: ATOV_USER_ASGN

CREATE VIEW ATOV_USER_ASSIGNMENT AS
SELECT
  parameters.bname AS user_id,
  useralias.useralias AS user_alias,
  parva AS namespace,
  _business_user.BusinessPartner AS person_id,
  _business_user.FirstName AS first_name,
  _business_user.LastName AS last_name
FROM usr05 AS parameters
INNER JOIN usrefus AS useralias ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ATOV_USER AS _user ON _user.name = parameters.bname  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserVH AS _business_user ON _business_user.UserID = parameters.bname  -- association [0..1]
;