I_WorkforceAvailability

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_WorkforceAvailability.
-- 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.

CREATE VIEW I_WorkforceAvailability AS
SELECT
  AvailyHdr.work_assignment_id AS WorkAssignment,
  AvailyHdr.availability_date AS WorkforceAvailabilityDate,
  AvailyHdr.work_assignment_ext_id AS ExternalWorkAssignmentID,
  AvailyHdr.workforce_availability_id AS WorkforceAvailabilityID,
  AvailyHdr.workforce_person_id AS WorkforcePersonID,
  AvailyHdr.data_source AS WrkfrcAvailyRecordDataSource,
  AvailyHdr.normal_working_time AS NormalWorkingTimeVal,
  AvailyHdr.normal_working_time_numeric AS NormalWorkingTimeInHours,
  AvailyHdr.scheduled_time AS ScheduledWorkingTimeVal,
  AvailyHdr.shift_code AS WorkingShiftCode,
  AvailyHdr.holiday_code AS WrkfrcAvailyHolidayCode,
  AvailyHdr.block_ind AS BlockingIndicator,
  AvailyHdr.last_changed_at AS LastChangeDateTime,
  AvailyHdr.last_changed_by AS LastChangedByUser
FROM wfd_d_avail_hdr AS AvailyHdr
LEFT OUTER JOIN I_WorkforceAvailabilitySuplmnt AS _AvailabilitySupplement ON WorkAssignment = _AvailabilitySupplement.WorkAssignment AND WorkforceAvailabilityDate = _AvailabilitySupplement.WorkforceAvailabilityDate AND ExternalWorkAssignmentID = _AvailabilitySupplement.ExternalWorkAssignmentID  -- association [0..*]
LEFT OUTER JOIN I_WorkforceAvailabilityIntvl AS _AvailabilityTimeInterval ON WorkAssignment = _AvailabilityTimeInterval.WorkAssignment AND WorkforceAvailabilityDate = _AvailabilityTimeInterval.WorkforceAvailabilityDate AND ExternalWorkAssignmentID = _AvailabilityTimeInterval.ExternalWorkAssignmentID  -- association [0..*]
LEFT OUTER JOIN I_WorkAssignmentDetsJobCodeFam AS _WorkAssgmtDetsJobCodeFamily ON WorkAssignment = _WorkAssgmtDetsJobCodeFamily.WorkAssignment  -- association [0..*]
;