I_FiscalYearQuarterForVariant

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_FiscalYearQuarterForVariant.
-- 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_FiscalYearQuarterForVariant AS
SELECT
  P_FiscalYearQuarter.FiscalYearVariant AS FiscalYearVariant,
  P_FiscalYearQuarter.FiscalYear AS FiscalYear,
  P_FiscalYearQuarter.FiscalYearQuarter AS FiscalYearQuarter,
  P_FiscalYearQuarter.FiscalYearStartDate AS FiscalYearStartDate,
  P_FiscalYearQuarter.FiscalYearEndDate AS FiscalYearEndDate,
  P_FiscalYearQuarter.FiscalQuarter AS FiscalQuarter,
  P_FiscalYearQuarter.FiscalQuarterStartDate AS FiscalQuarterStartDate,
  P_FiscalYearQuarter.FiscalQuarterEndDate AS FiscalQuarterEndDate,
  P_FiscalYearQuarter.FiscalQuarterConsecutiveNumber AS FiscalQuarterConsecutiveNumber,
  cast( P_FiscalYearQuarter.NextFiscalQuarter as fins_next_fiscalquarter preserving type ) AS NextFiscalQuarter,
  cast( cast( substring(P_FiscalYearQuarter.NextFiscalYearQuarter,1,4) as abap.numc(4) ) as fins_next_fiscalyear_no_conv preserving type ) AS NextFiscalYear,
  cast( P_FiscalYearQuarter.NextFiscalYearQuarter as fins_next_fyearquarter preserving type ) AS NextFiscalYearQuarter,
  cast( P_FiscalYearQuarter.NextFiscalQuarterStartDate as fins_next_fquarter_startdate preserving type ) AS NextFiscalQuarterStartDate,
  cast( P_FiscalYearQuarter.NextFiscalQuarterEndDate as fins_next_fquarter_enddate preserving type ) AS NextFiscalQuarterEndDate,
  cast( P_FiscalYearQuarter.NextFsclQuarterConsecutiveNmbr as fins_next_fyearquarter_i preserving type ) AS NextFsclQuarterConsecutiveNmbr,
  P_FiscalYearQuarter._FiscalYearVariant AS _FiscalYearVariant
FROM P_FiscalYearQuarter
LEFT OUTER JOIN I_FiscalYear AS _FiscalYear ON FiscalYearVariant = _FiscalYear.FiscalYearVariant AND FiscalYear = _FiscalYear.FiscalYear  -- association [0..1]
;