I_FiscCalendarDateForCompCode

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_FiscCalendarDateForCompCode.
-- 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_FiscCalendarDateForCompCode AS
SELECT
  I_FiscalCalendarDate.CalendarDate AS CalendarDate,
  cast( I_CompanyCode.CompanyCode as fis_bukrs preserving type ) AS CompanyCode,
  I_FiscalCalendarDate.FiscalYearVariant AS FiscalYearVariant,
  I_FiscalCalendarDate.FiscalYear AS FiscalYear,
  I_FiscalCalendarDate.FiscalYearStartDate AS FiscalYearStartDate,
  I_FiscalCalendarDate.FiscalYearEndDate AS FiscalYearEndDate,
  I_FiscalCalendarDate.FiscalPeriod AS FiscalPeriod,
  I_FiscalCalendarDate.FiscalPeriodStartDate AS FiscalPeriodStartDate,
  I_FiscalCalendarDate.FiscalPeriodEndDate AS FiscalPeriodEndDate,
  I_FiscalCalendarDate.FiscalQuarter AS FiscalQuarter,
  I_FiscalCalendarDate.FiscalQuarterStartDate AS FiscalQuarterStartDate,
  I_FiscalCalendarDate.FiscalQuarterEndDate AS FiscalQuarterEndDate,
  I_FiscalCalendarDate.FiscalWeek AS FiscalWeek,
  I_FiscalCalendarDate.FiscalWeekStartDate AS FiscalWeekStartDate,
  I_FiscalCalendarDate.FiscalWeekEndDate AS FiscalWeekEndDate,
  I_FiscalCalendarDate.FiscalYearPeriod AS FiscalYearPeriod,
  I_FiscalCalendarDate.FiscalYearQuarter AS FiscalYearQuarter,
  I_FiscalCalendarDate.FiscalYearWeek AS FiscalYearWeek,
  I_FiscalCalendarDate.FiscalYearConsecutiveNumber AS FiscalYearConsecutiveNumber,
  I_FiscalCalendarDate.FiscalPeriodConsecutiveNumber AS FiscalPeriodConsecutiveNumber,
  I_FiscalCalendarDate.FiscalQuarterConsecutiveNumber AS FiscalQuarterConsecutiveNumber,
  I_FiscalCalendarDate.FiscalWeekConsecutiveNumber AS FiscalWeekConsecutiveNumber,
  I_FiscalCalendarDate._FiscalYearVariant AS _FiscalYearVariant,
  I_FiscalCalendarDate._CalendarDate AS _CalendarDate
FROM I_FiscalCalendarDate
INNER JOIN I_CompanyCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodText AS _Text ON FiscalYearVariant = _Text.FiscalYearVariant AND FiscalYear = _Text.FiscalYear AND FiscalPeriod = _Text.FiscalPeriod  -- association [0..*]
;