P_O_EmploymentManager

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_O_EmploymentManager.
-- 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: POEMPLOYMENTMGR

CREATE VIEW P_O_EmploymentManager AS
SELECT
  Employment.EmploymentInternalID AS EmploymentInternalID,
  Employment.PersonnelNumber AS PersonnelNumber,
  Employment._Employee.Employee AS Employee,
  Employment._Employee.EmployeeFullName AS EmployeeFullName,
  Employment.PersonWorkAgrmtAuthznGrpg AS PersonWorkAgrmtAuthznGrpg,
  case when ManagerRelation.ManagerPersonWorkAgreement is not null then ManagerRelationCP.ObjectID else LineManagerCP.ObjectID end as ManagerPersonnelNumber AS ObjectIDendasManagerPersonnelNumber,
  case when ManagerRelation.ManagerPersonWorkAgreement is not null then Manager.Employee else Employee.Employee end as ManagerEmployee AS EmployeeendasManagerEmployee,
  case when ManagerRelation.ManagerPersonWorkAgreement is not null then Manager.FullName else Employee.EmployeeFullName end as ManagerFullName AS EmployeeFullNameendasManagerFullName,
  case when ManagerRelation.ManagerPersonWorkAgreement is not null then ManagerRelation.ValidityStartDate else EmployeeLineManager.ValidityStartDate end as ValidityStartDate AS ValidityStartDateendasValidityStartDate,
  case when ManagerRelation.ManagerPersonWorkAgreement is not null then ManagerRelation.ValidityEndDate else EmployeeLineManager.ValidityEndDate end as ValidityEndDate AS ValidityEndDateendasValidityEndDate
FROM I_Employment AS Employment
LEFT OUTER JOIN P_EmploymentManager AS ManagerRelation ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EmployeeLineManager AS EmployeeLineManager ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_PDRELATION AS ManagerRelationCP ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_PDRELATION AS LineManagerCP ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Employee AS _Manager ON ManagerPersonnelNumber = _Manager.PersonnelNumber  -- association [0..1]
LEFT OUTER JOIN I_Employment AS _Employment ON EmploymentInternalID = _Employment.EmploymentInternalID  -- association [0..1]
;