I_ShiftDefinition

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_ShiftDefinition.
-- 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: IPPSHIFTDEFTN

CREATE VIEW I_ShiftDefinition AS
SELECT
  def.kaptprog AS ShiftDefinition,
  def.schgrup AS ShiftGrouping,
  def.endda AS ShiftEndDate,
  def.endzt AS ShiftEndTime,
  def.begda AS ShiftStartDate,
  def.begzt AS ShiftStartTime,
  def.einzt AS OperatingDurationInSeconds,
  def.paplan AS WorkBreakSchedule,
  def.tprog AS DailyWorkSchedule,
  def.motpr AS DailyWorkScheduleGroup,
  def.varia AS DailyWorkScheduleVariant,
  cast(def.endda as vdm_validityend preserving type) AS ValidityEndDate
FROM tc37a AS def
LEFT OUTER JOIN I_ShiftDefinitionText AS _Text ON ShiftDefinition = _Text.ShiftDefinition  -- association [0..*]
LEFT OUTER JOIN I_ShiftDefinitionText AS _Text2 ON ShiftDefinition = _Text2.ShiftDefinition AND ShiftGrouping = _Text2.ShiftGrouping  -- association [0..*]
LEFT OUTER JOIN I_ShiftGrouping AS _ShiftGrouping ON ShiftGrouping = _ShiftGrouping.ShiftGrouping  -- association [1..1]
LEFT OUTER JOIN I_CalendarDate AS _EndDate ON ShiftEndDate = _EndDate.CalendarDate  -- association [1..1]
LEFT OUTER JOIN I_CalendarDate AS _StartDate ON ShiftStartDate = _StartDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_WorkBreakSchedule AS _WorkBreakSchedule ON ShiftGrouping = _WorkBreakSchedule.ShiftGrouping AND WorkBreakSchedule = _WorkBreakSchedule.WorkBreakSchedule  -- association [1..1]
;