I_FiscalCalDateForFinMgmtArea

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_FiscalCalDateForFinMgmtArea.
-- 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: IFCALDATE4FMA

CREATE VIEW I_FiscalCalDateForFinMgmtArea AS
SELECT
  I_FinancialManagementArea.FinancialManagementArea AS FinancialManagementArea,
  I_FiscalCalendarDate.CalendarDate AS CalendarDate,
  cast( I_FiscalCalendarDate.FiscalYear as fmis_fma_fiscal_year preserving type ) AS FinMgmtAreaFiscalYear,
  cast( I_FiscalCalendarDate.FiscalYearVariant as fmis_fma_fiscal_year_variant preserving type ) AS FinMgmtAreaFiscalYearVariant,
  cast (I_FiscalCalendarDate.FiscalYearStartDate as fins_fyear_startdate preserving type ) AS FinMgmtAreaFiscalYearStartDate,
  cast (I_FiscalCalendarDate.FiscalYearEndDate as fins_fyear_enddate preserving type ) AS FinMgmtAreaFiscalYearEndDate,
  cast ( I_FiscalCalendarDate.FiscalPeriod as fins_fiscalperiod preserving type) AS FinMgmtAreaPeriod
FROM I_FiscalCalendarDate
INNER JOIN I_FinancialManagementArea ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearPeriodText AS _PeriodText ON FinMgmtAreaFiscalYearVariant = _PeriodText.FiscalYearVariant AND FinMgmtAreaFiscalYear = _PeriodText.FiscalYear AND FinMgmtAreaPeriod = _PeriodText.FiscalPeriod  -- association [0..*]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FinMgmtAreaFiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalYear AS _FiscalYear ON FinMgmtAreaFiscalYear = _FiscalYear.FiscalYear AND FinMgmtAreaFiscalYearVariant = _FiscalYear.FiscalYearVariant  -- association [0..1]
;