P_RSHStaffingRequestData

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_RSHStaffingRequestData.
-- 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: PRSHSTAFFREQDATA

CREATE VIEW P_RSHStaffingRequestData AS
SELECT
  I_EngmntProjectPlnDataVersion.ResourceDemandUUID AS ResourceDemandUUID,
  I_EngmntProjectPlnDataVersion.FiscalPeriod AS FiscalPeriod,
  I_EngmntProjectPlnDataVersion.FiscalYear AS FiscalYear,
  I_EngmntProjectPlnDataVersion.EngagementProject AS EngagementProject,
  I_EngmntProjectPlnDataVersion.WorkPackageUUID AS WorkPackageUUID,
  I_EngmntProjectPlnDataVersion.WorkPackage AS WorkPackage,
  I_EngmntProjectPlnDataVersion.WorkItem AS WorkItem,
  I_EngmntProjectPlnDataVersion.EngagementProjectResource AS EngagementProjectResource,
  I_EngmntProjectPlnDataVersion.EngagementProjectResourceType AS EngagementProjectResourceType,
  I_EngmntProjectPlnDataVersion.EmploymentInternalID AS EmploymentInternalID,
  I_EngmntProjectPlnDataVersion.UnitOfMeasure AS UnitOfMeasure,
  I_EngmntProjectPlnDataVersion.PlndEffortQty AS EmployeeRequestDuration,
  I_EngmntProjectPlnDataVersion.Currency AS Currency,
  cast(I_EngmntProjectPlnDataVersion.PlndRevnAmt as rsh_ps_project_planned_revenue) AS PlndRevAmt,
  I_EngmntProjectPlnDataVersion.EngagementProjectServiceOrg AS EmployeeRequestDelivOrg,
  coalesce( _EmployeeRequestDelivOrg.EngagementProjectServiceOrg, EngagementProject.EngagementProjectServiceOrg ) AS ServiceOrganization,
  EngagementProject.EngagementProjectUUID AS EngagementProjectUUID,
  EngagementProject.EngagementProjectStage AS EngagementProjectStage,
  EngagementProject.EngagementProjectName AS EngagementProjectName,
  EngagementProject.Customer AS Customer,
  EngagementProject.EngagementProjectType AS EngagementProjectType,
  EngagementProject.ControllingArea AS ControllingArea,
  EngagementProject.CostCenter AS EmployeeRequestHdrCostCenter,
  EngagementProject.ProjectManager AS ProjectManager,
  EngagementProject.EngagementProjectServiceOrg AS EmployeeRequestHdrSrvOrg,
  EngagementProject.ProfitCenter AS ProfitCenter,
  EngagementProject.CompanyCode AS CompanyCode,
  EngagementProject.ProjectProfileCode AS ProjectProfileCode,
  cast(EngagementProject.EngagementProjectCategory as rsh_ps_staff_request_categ preserving type ) AS EngagementProjectCategory,
  _WorkPackage.WorkPackageStartDate AS StartDate,
  _WorkPackage.WorkPackageEndDate AS EndDate,
  _WorkPackage.WorkPackageName AS WorkPackageName,
  BillingControlCategory,
  cast(_Visibility.ProjectVisibility as rsh_ps_staff_request_publicvis ) AS ProjectVisibility,
  cast('' as rsh_project_authorization) AS EmployeeRequestAuthorized,
  cast(EngagementProject.LastChangeDateTime as tzntstmps) AS LastChangeDateTime,
  cast(EngagementProject.CreationDateTime as tzntstmps) AS CreationDateTime,
  concat(FiscalYear, cast(substring(FiscalPeriod,2,2 ) as calendarmonth) ) AS YearMonth,
  EngagementProject._Customer AS _Customer
FROM I_EngmntProjectPlnDataVersion
LEFT OUTER JOIN I_RSHStaffingRequestVisibility AS _Visibility ON _Visibility.ProjectVisibilityOrigin = EngagementProject.ProjectVisibility  -- association [1..1]
LEFT OUTER JOIN I_WorkPackage AS _WorkPackage ON WorkPackage = _WorkPackage.WorkPackage  -- association [1..1]
LEFT OUTER JOIN I_WorkPackageWorkItem AS _WorkItem ON WorkItem = _WorkItem.WorkItem AND WorkPackage = _WorkItem.WorkPackage  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectResource AS _Role ON EngagementProjectResource = _Role.EngagementProjectResource AND EngagementProjectResourceType = _Role.EngagementProjectResourceType  -- association [0..1]
LEFT OUTER JOIN P_RSHStaffingRequestSkilltags AS _Skilltags ON ResourceDemandUUID = _Skilltags.ResourceDemandUUID  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PreferredEmployee ON _PreferredEmployee.PersonWorkAgreement = I_EngmntProjectPlnDataVersion.EmploymentInternalID  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _ProjectManagerEmployee ON _ProjectManagerEmployee.PersonWorkAgreement = ProjectManager  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectSrvcOrg AS _EmployeeRequestDelivOrg ON _EmployeeRequestDelivOrg.EngagementProjectServiceOrg = I_EngmntProjectPlnDataVersion.EngagementProjectServiceOrg  -- association [0..1]
;