I_FsclDateFuncRangeFiscalValue

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_FsclDateFuncRangeFiscalValue.
-- 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: IFIFSCLDATEFUNCR
-- Parameters: P_DateFunction : datefunctionid

CREATE VIEW I_FsclDateFuncRangeFiscalValue AS
SELECT
  I_LedgerCompanyCodeCrcyRoles.Ledger AS Ledger,
  I_LedgerCompanyCodeCrcyRoles.CompanyCode AS CompanyCode,
  I_Datefunction.DateFunction AS DateFunction,
  I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant AS FiscalYearVariant,
  cast( Date1.FiscalYear as fis_ryear_from_no_conv ) AS FromFiscalYear,
  cast( Date2.FiscalYear as fis_ryear_to_no_conv ) AS ToFiscalYear,
  case when P_MaxSpecialFiscalYearPeriod.FiscalYearPeriod is not null then P_MaxSpecialFiscalYearPeriod.FiscalYearPeriod else Date2.FiscalYearPeriod end as ToFiscalYearPeriod AS FiscalYearPeriodendasToFiscalYearPeriod,
  cast( I_FiscalDateFunctionValue.DateFunctionEndDate as fis_budat_to ) AS ToPostingDate
FROM I_FiscalDateFunctionValue
INNER JOIN I_Datefunction ON /* join condition not captured in parsed metadata */
INNER JOIN I_FiscalCalendarDate AS Date1 ON /* join condition not captured in parsed metadata */
INNER JOIN I_FiscalCalendarDate AS Date2 ON /* join condition not captured in parsed metadata */
INNER JOIN I_LedgerCompanyCodeCrcyRoles ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON I_LedgerCompanyCodeCrcyRoles.CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON I_LedgerCompanyCodeCrcyRoles.Ledger = _Ledger.Ledger  -- association [1..1]
;