R_SetlMgmtSchedgWlRecurrence

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 R_SetlMgmtSchedgWlRecurrence.
-- 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 R_SetlMgmtSchedgWlRecurrence AS
SELECT
  worklist_uuid AS SettlmtMgmtSchedgWlUUID,
  periodic_granularity AS SetlMgmtSchedgWlPeriodicGrnlty,
  periodic_value AS SetlMgmtSchedgWlPeriodicValue,
  job_timezone AS SetlMgmtSchedgWlJobTimezone,
  calendar_id AS SetlMgmtSchedgWlCalendarID,
  start_restriction_code AS SetlMgmtSchedgWlStrtRstrcnCode,
  on_monday AS SetlMgmtSchedgWlRunsOnMon,
  on_tuesday AS SetlMgmtSchedgWlRunsOnTue,
  on_wednesday AS SetlMgmtSchedgWlRunsOnWed,
  on_thursday AS SetlMgmtSchedgWlRunsOnThu,
  on_friday AS SetlMgmtSchedgWlRunsOnFri,
  on_saturday AS SetlMgmtSchedgWlRunsOnSat,
  on_sunday AS SetlMgmtSchedgWlRunsOnSun,
  month_day AS SetlMgmtSchedgWlMonthDay,
  use_working_days AS SetlMgmtSchedgWlIsUsingWrkDays,
  shift_direction AS SetlMgmtSchedgWlShiftDirection,
  month_week AS SetlMgmtSchedgWlMonthWeek,
  end_type AS SetlMgmtSchedgWlEndType,
  end_timestamp AS SetlMgmtSchedgWlEndDateTime,
  max_iterations AS SetlMgmtSchedgWlNmbrOfMaxRuns
FROM wlf_d_swl_recu
LEFT OUTER JOIN R_SetlMgmtSchedgWl AS _Worklist ON SettlmtMgmtSchedgWlUUID = _Worklist.SettlmtMgmtSchedgWlUUID  -- association [1..1]
LEFT OUTER JOIN I_SetlMgmtSchedgWlPerdcGrnlty AS _PeriodicGranularity ON SetlMgmtSchedgWlPeriodicGrnlty = _PeriodicGranularity.SetlMgmtSchedgWlPeriodicGrnlty  -- association [0..1]
LEFT OUTER JOIN I_StlMnScdWlStrtRstrcnCode AS _StartRestrictionCode ON SetlMgmtSchedgWlStrtRstrcnCode = _StartRestrictionCode.SetlMgmtSchedgWlStrtRstrcnCode  -- association [0..1]
LEFT OUTER JOIN I_SetlMgmtSchedgWlShftDrctn AS _ShiftDirection ON SetlMgmtSchedgWlShiftDirection = _ShiftDirection.SetlMgmtSchedgWlShiftDirection  -- association [0..1]
LEFT OUTER JOIN I_SetlMgmtSchedgWlEndType AS _EndType ON SetlMgmtSchedgWlEndType = _EndType.SetlMgmtSchedgWlEndType  -- association [0..1]
LEFT OUTER JOIN I_SetlMgmtSchedgWlMonthWeek AS _MonthWeek ON SetlMgmtSchedgWlMonthWeek = _MonthWeek.SetlMgmtSchedgWlMonthWeek  -- association [0..1]
LEFT OUTER JOIN I_SetlMgmtSchedgWlCalendarIDVH AS _CalendarID ON SetlMgmtSchedgWlCalendarID = _CalendarID.SetlMgmtSchedgWlCalendarID  -- association [0..1]
;