SEPMRA_I_Employee

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 SEPMRA_I_Employee.
-- 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 SEPMRA_I_Employee AS
SELECT
  cast( Employee.Employee as sepmra_employee preserving type ) AS Employee,
  Employee.EmployeeUUID AS EmployeeUUID,
  Employee.EmployeePictureURL AS EmployeePictureURL,
  Employee.FirstName AS FirstName,
  Employee.MiddleName AS MiddleName,
  Employee.LastName AS LastName,
  Employee.FullName AS FullName,
  Employee.Initials AS Initials,
  Employee.GenderCode AS GenderCode,
  Employee._GenderCode AS _GenderCode,
  Employee.PhoneNumber AS PhoneNumber,
  Employee.MobilePhoneNumber AS MobilePhoneNumber,
  Employee.EmailAddress AS EmailAddress,
  Employee.SystemUser AS SystemUser,
  Employee.CompanyUUID AS CompanyUUID,
  Employee._Company AS _Company
FROM SEPM_I_Employee AS Employee
LEFT OUTER JOIN SEPMRA_I_EmployeeOrgAssigment AS _EmployeeOrgAssignment ON Employee = _EmployeeOrgAssignment.Employee  -- association [0..*]
LEFT OUTER JOIN SEPMRA_I_OrgAsgmntForCurrDate AS _EmployeeOrgAssignmentToday ON EmployeeUUID = _EmployeeOrgAssignmentToday.EmployeeUUID  -- association [0..1]
LEFT OUTER JOIN I_User AS _SystemUser ON SystemUser = _SystemUser.UserID  -- association [0..1]
;