I_RSHProjectAssignmentHrs

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 I_RSHProjectAssignmentHrs.
-- 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: IRSHPRJASGPHR

CREATE VIEW I_RSHProjectAssignmentHrs AS
SELECT
  ProjectAssignment.ProjAssignmentUUID AS ProjAssignmentUUID,
  ProjectAssignment.ResourceDemandUUID AS ResourceDemandUUID,
  ProjectAssignment.EmploymentInternalID AS EmploymentInternalID,
  ProjectAssignment.ProjAssignmentStartDate AS ProjAssignmentStartDate,
  ProjectAssignment.ProjAssignmentEndDate AS ProjAssignmentEndDate,
  ProjectAssignment.ProjAssignmentTotalHours AS ProjAssignmentTotalHours,
  ProjectAssignment.SourceOfSupply AS SourceOfSupply,
  _Resource.CompanyCode AS CompanyCode,
  _Resource.CostCenter AS CostCenter,
  _Resource.AuthorizationGroup AS AuthorizationGroup,
  _Resource.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _Request.ServiceOrganization AS ServiceOrganization,
  _Request.EmployeeRequestHdrSrvOrg AS EmployeeRequestHdrSrvOrg,
  _Request.EmployeeRequestDelivOrg AS EmployeeRequestDelivOrg,
  _Request.ProjectVisibility AS ProjectVisibility,
  _Request._Customer.IsBusinessPurposeCompleted AS IsBusPrpsCmpltdCustomer,
  _Request._Customer.AuthorizationGroup AS CustomerAuthznGrp,
  _Request._ProjectManager._WorkforcePerson.IsBusinessPurposeCompleted AS IsBusPrpsCmpltdProjectManager,
  _Request._ProjectManager._WorkforcePerson.AuthorizationGroup AS ProjectManagerAuthznGrp,
  _EngmtProjPlanConfig.ExternalStaffingIsActive AS ExternalStaffingIsActive
FROM I_RSHProjectAssignment AS ProjectAssignment
LEFT OUTER JOIN P_RSHResourceTimeSlice AS _Resource ON _Resource.EmploymentInternalID = EmploymentInternalID AND _Resource.StartDate <= ProjAssignmentStartDate AND _Resource.EndDate >= ProjAssignmentStartDate  -- association [0..*]
LEFT OUTER JOIN P_RSHStaffingRequestDetails AS _Request ON _Request.ResourceDemandUUID = ResourceDemandUUID  -- association [0..1]
LEFT OUTER JOIN I_RSHProjectAssignmentDailyHrs AS _ProjectAssignmentPerDay ON _ProjectAssignmentPerDay.ProjAssignmentUUID = ProjAssignmentUUID  -- association [0..*]
LEFT OUTER JOIN I_EngmntProjPlanConfig AS _EngmtProjPlanConfig ON _EngmtProjPlanConfig.ProjectProfileCode = 'P001'  -- association [0..1]
;