I_SCAL_TFACD_COMBINED

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_SCAL_TFACD_COMBINED.
-- 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_SCAL_TFACD_COMBINED AS
SELECT
  fhc_fcal.FactoryCalendarLegacyID AS Ident,
  cast( (substring (fhc_fcal.FctryCalendarValidityStartDate,1,4) ) as vjahr) AS VJahr,
  cast( (substring (fhc_fcal.FactoryCalendarValidityEndDate,1,4) ) as bjahr) AS BJahr,
  fhc_fcal.FctryCalMondayIsWorkingDay AS Motag,
  fhc_fcal.FctryCalTuesdayIsWorkingDay AS Ditag,
  fhc_fcal.FctryCalWednesdayIsWorkingDay AS Miwch,
  fhc_fcal.FctryCalThursdayIsWorkingDay AS Dotag,
  fhc_fcal.FctryCalFridayIsWorkingDay AS Frtag,
  fhc_fcal.FctryCalSaturdayIsWorkingDay AS Satag,
  fhc_fcal.FctryCalSundayIsWorkingDay AS Sotag,
  fhc_fcal.FctryCalHolidayIsWorkingDay AS Fetag,
  cast(fhc_fcal.PublicHolidayCalendarID as hident) AS Hocid,
  cast( (cast(fhc_fcal.FactoryCalendarStartDateValue as sstring ) ) as kftag ) AS Basis,
  cast( '0' as kabbr ) AS Abbr,
  cast( '0' as kuser ) AS Crusr,
  cast( '00000000' as fabdat ) AS Crdat,
  cast( '000000' as crtime ) AS Crtime,
  cast( '0' as kabbr ) AS Interv,
  cast( '0000' as aktvjahr preserving type ) AS Aktvjahr,
  cast( '0000' as aktbjahr preserving type ) AS Aktbjahr
FROM R_FHC_FCAL_COMBINED AS fhc_fcal
;