P_EngmntProjStfngSrchByRole

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_EngmntProjStfngSrchByRole.
-- 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: PENGPRJSRCHROLE
-- Parameters: P_StartDate : dats, P_EndDate : dats

CREATE VIEW P_EngmntProjStfngSrchByRole AS
SELECT
  PersonWorkAgreement_1.Person AS Person,
  PersonWorkAgreement_1.PersonWorkAgreement AS PersonWorkAgreement,
  PersonWorkAgrmtStatus.StartDate AS WorkforceAssgmtStartDate,
  PersonWorkAgrmtStatus.EndDate AS WorkforceAssgmtEndDate,
  EngProjectSrvcOrgDets.EngagementProjectServiceOrg AS EngmntProjectDeliveryOrg,
  PersonWorkAgrmtOrglDetails.CostCenter AS CostCenter,
  PersonWorkAgrmtSrvcCostLevel.ServiceCostLevel AS ServiceCostLevel,
  PersonWorkAgrmtSrvcCostLevel.StartDate AS StartDate,
  EngPlandataRes.EngagementProjectResource AS EngagementProjectResource,
  EngPlandataRes.EngagementProjResourceText AS EngagementProjResourceText,
  PersonWorkAgreementRole.BusinessPartnerRole AS BusinessPartnerRole,
  PersonWorkAgrmtOrglDetails.CompanyCode AS CompanyCode,
  PersonWorkAgreement_1.PersonFullName AS EmployeeFullName,
  cast( WorkforcePerson.PersonExternalID as comm_id_long ) AS PersonWorkAgreementExternalID,
  WorkforcePersonImageURL.WorkforcePersonImageURL AS WorkforcePersonImageURL,
  EmployeeskillTags.WorkforcePersonSkillTagName AS WorkforcePersonSkillTagsTxt,
  PersonWorkAgreement_1.AuthorizationGroup AS AuthorizationGroup,
  WorkforcePerson.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  PersonWorkAgreement_1._BusinessPartner.DataControllerSet AS DataControllerSet,
  PersonWorkAgreement_1._BusinessPartner.DataController1 AS DataController1,
  PersonWorkAgreement_1._BusinessPartner.DataController2 AS DataController2,
  PersonWorkAgreement_1._BusinessPartner.DataController3 AS DataController3,
  PersonWorkAgreement_1._BusinessPartner.DataController4 AS DataController4,
  PersonWorkAgreement_1._BusinessPartner.DataController5 AS DataController5,
  PersonWorkAgreement_1._BusinessPartner.DataController6 AS DataController6,
  PersonWorkAgreement_1._BusinessPartner.DataController7 AS DataController7,
  PersonWorkAgreement_1._BusinessPartner.DataController8 AS DataController8,
  PersonWorkAgreement_1._BusinessPartner.DataController9 AS DataController9,
  PersonWorkAgreement_1._BusinessPartner.DataController10 AS DataController10
FROM P_EngmntPlandataResource AS EngPlandataRes
INNER JOIN I_PersonWorkAgreement_1 AS PersonWorkAgreement_1 ON /* join condition not captured in parsed metadata */
INNER JOIN I_PersonWorkAgrmtStatus AS PersonWorkAgrmtStatus ON /* join condition not captured in parsed metadata */
INNER JOIN I_WorkforcePerson AS WorkforcePerson ON /* join condition not captured in parsed metadata */
INNER JOIN I_PersnWrkAgrmtRoleForOPg AS PersonWorkAgreementRole ON /* join condition not captured in parsed metadata */
INNER JOIN I_PersonWorkAgrmtOrglDetails AS PersonWorkAgrmtOrglDetails ON /* join condition not captured in parsed metadata */
INNER JOIN I_EngagementProjectSrvcOrgDets AS EngProjectSrvcOrgDets ON /* join condition not captured in parsed metadata */
INNER JOIN I_EngagementProjectSrvcOrg AS EngagementProjectSrvOrg ON /* join condition not captured in parsed metadata */
;