P_EngmntProjStfngSrchBySkill

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_EngmntProjStfngSrchBySkill.
-- 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: PENGPRJSRCHSKILL
-- Parameters: P_StartDate : dats, P_EndDate : dats

CREATE VIEW P_EngmntProjStfngSrchBySkill 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,
  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,
  EmployeeskillTags.WorkforcePersonSkillTagType AS WorkforcePersonSkillTagType,
  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 I_WorkforcePersonSkillTags AS EmployeeskillTags
INNER JOIN I_WorkforcePerson AS WorkforcePerson ON /* join condition not captured in parsed metadata */
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_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 EngagementProjectServiceOrg ON /* join condition not captured in parsed metadata */
;