I_FHC_FCAL_RUNTIME

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_FHC_FCAL_RUNTIME.
-- 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: VFHCFCALRUN

CREATE VIEW I_FHC_FCAL_RUNTIME AS
SELECT
  exceptions.date_from AS date_from,
  exceptions.date_to AS date_to,
  factorycalendar.work_monday AS work_monday,
  factorycalendar.work_tuesday AS work_tuesday,
  factorycalendar.work_friday AS work_friday,
  factorycalendar.work_sunday AS work_sunday,
  factorycalendar.work_holiday AS work_holiday,
  factorycalendar.valid_from AS valid_from,
  factorycalendar.valid_to AS valid_to,
  factorycalendar.changer AS changer,
  factorycalendar.changed AS changed
FROM fhc_c_fcal AS factorycalendar
LEFT OUTER JOIN fhc_c_fcal_exc AS exceptions ON /* join condition not captured in parsed metadata */
;