I_FactoryCalendar

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_FactoryCalendar.
-- 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: IPPFACTORYCAL

CREATE VIEW I_FactoryCalendar AS
SELECT
  cast(fcal.ident as cr_wfcid preserving type) AS FactoryCalendar,
  cast(fcal.hocid as hident preserving type) AS PublicHolidayCalendar,
  cast(fcal.vjahr as pph_vjahr preserving type) AS ValidityStartYear,
  cast(fcal.bjahr as pph_bjahr preserving type) AS ValidityEndYear,
  cast(fcal.crdat as erdat preserving type) AS CreationDate,
  cast(fcal.crtime as erzet preserving type) AS CreationTime,
  cast(fcal.motag as tamotag preserving type) AS MondayIsWorkingDay,
  cast(fcal.ditag as taditag preserving type) AS TuesdayIsWorkingDay,
  cast(fcal.miwch as tamiwch preserving type) AS WednesdayIsWorkingDay,
  cast(fcal.dotag as tadotag preserving type) AS ThursdayIsWorkingDay,
  cast(fcal.frtag as tafrtag preserving type) AS FridayIsWorkingDay,
  cast(fcal.satag as tasatag preserving type) AS SaturdayIsWorkingDay,
  cast(fcal.sotag as tasotag preserving type) AS SundayIsWorkingDay,
  cast(fcal.fetag as tafetag preserving type) AS HolidayIsWorkingDay,
  basis AS FactoryCalendarStartDayValue,
  cast(fcal.crdat as laeda preserving type) AS LastChangeDate,
  crtime AS LastChangeTime,
  cast(fcal.interv as tainterv preserving type) AS FactoryCalSpclRulesAreExisting
FROM tfacd AS fcal
LEFT OUTER JOIN I_FactoryCalendarText AS _Text ON FactoryCalendar = _Text.FactoryCalendar  -- association [0..*]
LEFT OUTER JOIN I_CalendarYear AS _ValidityStartYear ON ValidityStartYear = _ValidityStartYear.CalendarYear  -- association [0..1]
LEFT OUTER JOIN I_CalendarYear AS _ValidityEndYear ON ValidityEndYear = _ValidityEndYear.CalendarYear  -- association [0..1]
;