I_FiscalYearPeriod

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_FiscalYearPeriod.
-- 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_FiscalYearPeriod AS
SELECT
  P_FiscalYearPeriod.fiscal_year_variant AS FiscalYearVariant,
  P_FiscalYearPeriod.fiscal_year AS FiscalYear,
  P_FiscalYearPeriod.fiscal_period AS FiscalPeriod,
  P_FiscalYearPeriod.fiscal_period_start_date AS FiscalPeriodStartDate,
  P_FiscalYearPeriod.fiscal_period_end_date AS FiscalPeriodEndDate,
  P_FiscalYearPeriod.is_special_period AS IsSpecialPeriod,
  P_FiscalYearPeriod.fiscal_year_start_date AS FiscalYearStartDate,
  P_FiscalYearPeriod.fiscal_year_end_date AS FiscalYearEndDate,
  P_FiscalYearPeriod.fiscal_year_period AS FiscalYearPeriod,
  _FiscalCalendarDate.FiscalPeriodConsecutiveNumber AS FiscalPeriodConsecutiveNumber,
  P_FiscalYearPeriod.next_fiscal_period AS NextFiscalPeriod,
  P_FiscalYearPeriod.next_fiscal_period_fiscal_year AS NextFiscalPeriodFiscalYear,
  _FiscalCalendarDate.FiscalPeriodConsecutiveNumber + 1 AS NextFsclPeriodConsecutiveNmbr
FROM P_FiscalYearPeriod
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _FiscalPeriodStartDate ON FiscalPeriodStartDate = _FiscalPeriodStartDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_FiscalYear AS _FiscalYear ON FiscalYearVariant = _FiscalYear.FiscalYearVariant AND FiscalYear = _FiscalYear.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodText AS _Text ON FiscalYearVariant = _Text.FiscalYearVariant AND FiscalYear = _Text.FiscalYear AND FiscalPeriod = _Text.FiscalPeriod  -- association [0..*]
LEFT OUTER JOIN I_FiscalCalendarDate AS _FiscalCalendarDate ON FiscalYearVariant = _FiscalCalendarDate.FiscalYearVariant AND FiscalYear = _FiscalCalendarDate.FiscalYear AND FiscalPeriod = _FiscalCalendarDate.FiscalPeriod AND FiscalYearPeriod = _FiscalCalendarDate.FiscalYearPeriod AND FiscalPeriodStartDate = _FiscalCalendarDate.CalendarDate  -- association [0..1]
;