P_BPUsrAssignment

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 P_BPUsrAssignment.
-- 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 P_BPUsrAssignment AS
SELECT
  cast( _Root.bname as vdm_userid preserving type ) AS UserID,
  adrp.name_first AS Firstname,
  adrp.name_last AS Lastname,
  cast( usr21.techdesc as vdm_userdescription preserving type ) AS UserDescription,
  usr21.addrnumber AS AddressNumber,
  usr21.persnumber AS PersonNumber,
  _Email[1: flgdefault = 'X'].smtp_addr AS DefaultEmailAddress,
  _Root.class AS UserGroup,
  adcp,
  adrp
FROM usr02 AS _Root
INNER JOIN usr21 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adr6 AS _Email ON AddressNumber = _Email.addrnumber AND PersonNumber = _Email.persnumber AND _Email.date_from = '00010101'  -- association [0..1]
;