I_ProcmtEmployeeUserDetails

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_ProcmtEmployeeUserDetails.
-- 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: IPROCMTUSRDTL

CREATE VIEW I_ProcmtEmployeeUserDetails AS
SELECT
  cast( usr21.UserID as vdm_userid ) AS UserID,
  usr21.BusinessPartnerUUID AS BusinessPartnerUUID,
  _Employee.FirstName AS FirstName,
  _Employee.LastName AS LastName,
  _Employee.PersonFullName AS FullName,
  _Employee.PersonExternalID AS Employee,
  _Employee.AuthorizationGroup AS AuthorizationGroup,
  _Employee.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _Employee.ValidityEndDate AS ValidityEndDate,
  _Employee.PersonWorkAgreement AS PersonWorkAgreement,
  _Employee.CompanyCode AS CompanyCode,
  _Employee.Person AS Person,
  _Employee.PersonWorkAgrmtAuthznGrpg AS PersonWorkAgrmtAuthznGrpg,
  _Employee._BusinessPartner AS _BusinessPartner
FROM I_User AS usr21
INNER JOIN P_SSPWorkPersonDetails AS _Employee ON /* join condition not captured in parsed metadata */
;