P_EmpProjects

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_EmpProjects.
-- 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: PEMPPROJECTS

CREATE VIEW P_EmpProjects AS
SELECT
  EE.PersonnelNumber AS PersonnelNumber,
  ET.EmploymentInternalID AS EmploymentInternalID,
  plan.CustomerProject AS CustomerProject,
  _proj.CustomerProjectName AS ProjectName,
  plan.CustomerProjectResource AS Role,
  LPAD('',20,'x') AS RoleName,
  _proj._PersonWorkAgreement._WorkforcePerson.PersonExternalID AS ManagerEmployeeExtID,
  _proj._PersonWorkAgreement._WorkforcePerson.PersonFullName AS Manager,
  _proj._Customer.CustomerName AS Customer,
  _proj._Customer.Customer AS CustomerID,
  '' AS AddressID,
  plan._CustProjResourceText AS _CustProjResourceText,
  EE.AuthorizationGroup AS AuthorizationGroup,
  EE.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM I_Employee AS EE
LEFT OUTER JOIN I_EmployOrgDet AS ET ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CustomerProjectPlanData AS plan ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CustomerProject AS _proj ON plan.CustomerProject = _proj.CustomerProject  -- association [0..1]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _ActivityTypeText ON Role = _ActivityTypeText.CostCtrActivityType  -- association [0..*]
;