R_WorkAssignmentProject

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 R_WorkAssignmentProject.
-- 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 R_WorkAssignmentProject AS
SELECT
  _WorkAssignmentBP.BusinessPartnerUUID AS WorkAssignmentUUID,
  _EngagementProject.EngagementProject AS CustomerProject,
  _ProjectSupply.EngagementProjectResource AS ResourceID,
  _AssignmentKeyMap.WorkforceAssignment AS WorkforceAssignmentID,
  _EngagementProject.EngagementProjectName AS ProjectName,
  concat( '#Customer-displayFactSheet?Customer=', _EngagementProject._Customer.Customer ) AS CustomerURLTxt,
  _EngagementProject._Customer.CustomerName AS CustomerName,
  _ActivityTypeText.CostCtrActivityTypeName AS CostCtrActivityTypeName,
  _EngagementProject.EngagementProjectType AS CustomerProjectType,
  _EngagementProject.EngagementProjectServiceOrg AS CustomerProjectServiceOrg,
  concat( '#Worker-displayFactSheet?PersonExternalID=', _EngagementProject._PersonWorkAgreement_1._WorkforcePerson.PersonExternalID ) AS CustomerProjectManagerName,
  cast ( _EngagementProject._PersonWorkAgreement_1._WorkforcePerson.PersonFullName as wfd_manager_name ) AS Manager
INNER JOIN R_WorkAssignmentBP AS _BuPaIdentification ON /* join condition not captured in parsed metadata */
INNER JOIN I_EngmntProjectSupplyData AS _ProjectSupply ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartner AS _WorkAssignmentBP ON _WorkAssignmentBP.BusinessPartner = _BuPaIdentification.WorkAssignmentBusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _ActivityTypeText ON ResourceID = _ActivityTypeText.CostCtrActivityType AND _ActivityTypeText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_EngagementProject AS _EngagementProject ON _ProjectSupply.EngagementProjectUUID = _EngagementProject.EngagementProjectUUID  -- association [0..1]
;