I_RSHProjectAssignmentTP

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_RSHProjectAssignmentTP.
-- 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: IRSHPROJASGTP

CREATE VIEW I_RSHProjectAssignmentTP AS
SELECT
  ProjAssignmentUUID,
  EmploymentInternalID,
  ResourceDemandUUID,
  SourceOfSupply,
  SourceOfDraftCreationInRSH,
  ProjAssignmentDistributionRule,
  ProjAssignmentStartDate,
  ProjAssignmentEndDate,
  ProjAssignmentTotalHours,
  ProjAssignmentHoursPerDay,
  ProjAssignmentUtilization,
  dats_add_days(cast( concat( left(ProjAssignmentStartDate, 6 ), '01') as dats), -36, 'FAIL') AS ProjAssignDayCapacityStartDate,
  dats_add_days(cast( concat( left(ProjAssignmentStartDate, 6 ), '01') as dats), 67, 'FAIL') AS ProjAssignDayCapacityEndDate,
  ProjAssignIsDistrToSpecifDays,
  ProjAssignIsDistrToMonday,
  ProjAssignIsDistrToTuesday,
  ProjAssignIsDistrToWednesday,
  ProjAssignIsDistrToThursday,
  ProjAssignIsDistrToFriday,
  ProjAssignIsDistrToSaturday,
  ProjAssignIsDistrToSunday,
  ProjAssignmentCreatedBy,
  ProjAssignmentCreatedAt,
  ProjAssignmentLastChangedBy,
  ProjAssignmentLastChangedAt,
  ProjAssignmentLifeCycle,
  EmployeeRequestOpenDuration,
  ProjectLastChangedDateTime,
  cast( EmployeeUtilLvlOverbooked as rsh_ps_overbooked_threshold ) AS EmployeeUtilLvlOverbooked,
  cast( EmployeeUtilLvlFreeCapacity as rsh_ps_free_capacity_threshold ) AS EmployeeUtilLvlFreeCapacity
FROM I_RSHProjectAssignment
LEFT OUTER JOIN I_RSHProjectAssignmentPerDayTP AS _ProjectAssignmentPerDay ON _ProjectAssignmentPerDay.ProjAssignmentUUID = ProjAssignmentUUID  -- association [0..*]
LEFT OUTER JOIN I_RSHProjectAssignmentKPITP AS _ProjectAssignmentKPI ON _ProjectAssignmentKPI.ProjAssignmentUUID = ProjAssignmentUUID  -- association [0..*]
LEFT OUTER JOIN I_RSHProjectAssignmentCapKPITP AS _ProjectAssignmentCapKPI ON _ProjectAssignmentCapKPI.ProjAssignmentUUID = ProjAssignmentUUID  -- association [0..*]
LEFT OUTER JOIN I_RSHProjectAssgmtPerWeekTP AS _ProjectAssignmentPerWeek ON _ProjectAssignmentPerWeek.ProjAssignmentUUID = ProjAssignmentUUID  -- association [0..*]
LEFT OUTER JOIN I_RSHProjectAssgmtPerMonthTP AS _ProjectAssignmentPerMonth ON _ProjectAssignmentPerMonth.ProjAssignmentUUID = ProjAssignmentUUID  -- association [0..*]
;