I_FiscalCalendarDateForLedger

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_FiscalCalendarDateForLedger.
-- 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: IFIFISCCAL4L

CREATE VIEW I_FiscalCalendarDateForLedger AS
SELECT
  CalendarDate,
  cast( CompanyCode as fis_bukrs preserving type ) AS CompanyCode,
  cast( Ledger as fis_rldnr preserving type ) AS Ledger,
  I_FiscalCalendarDate.FiscalYearVariant AS FiscalYearVariant,
  _CompanyCode.ControllingArea AS ControllingArea,
  FiscalYear,
  FiscalYearStartDate,
  FiscalYearEndDate,
  FiscalPeriod,
  FiscalPeriodStartDate,
  FiscalPeriodEndDate,
  FiscalQuarter,
  FiscalQuarterStartDate,
  FiscalQuarterEndDate,
  FiscalWeek,
  FiscalWeekStartDate,
  FiscalWeekEndDate,
  FiscalYearPeriod,
  FiscalYearQuarter,
  FiscalYearWeek,
  FiscalYearConsecutiveNumber,
  FiscalPeriodConsecutiveNumber,
  FiscalQuarterConsecutiveNumber,
  FiscalWeekConsecutiveNumber,
  I_FiscalCalendarDate._FiscalYearVariant AS _FiscalYearVariant
FROM I_FiscalCalendarDate
INNER JOIN I_LedgerCompanyCodeCrcyRoles ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- 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_FiscalYear AS _FiscalYear ON FiscalYearVariant = _FiscalYear.FiscalYearVariant AND FiscalYear = _FiscalYear.FiscalYear  -- association [0..1]
;