C_FinStmntComparison

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 C_FinStmntComparison.
-- 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: CFIFINSTMTCMP
-- Parameters: P_KeyDate : sydatum, P_Language : sylangu, P_BusinessUser : syuname, P_Ledger : fins_ledger, P_FinancialStatementVersion : hryid, P_FromFiscalPeriod : fis_period_from, P_ToFiscalPeriod : fis_period_to, P_FiscalYear : fis_gjahr_no_conv, P_ComparisonLedger : fis_ledger_cmp, P_FromComparisonFiscalPeriod : fis_period_from_cmp, P_ToComparisonFiscalPeriod : fis_period_to_cmp, P_ComparisonFiscalYear : fis_gjahr_cmp_no_conv, P_CurrencyRole : fins_curtp, P_PlanningCategory : fcom_category, P_Interval1FromFiscalPeriod : fis_period_from, P_Interval1ToFiscalPeriod : fis_period_to, P_Interval2FromFiscalPeriod : fis_period_from, P_Interval2ToFiscalPeriod : fis_period_to

CREATE VIEW C_FinStmntComparison AS
SELECT
  lookupEntity: 'I_Ledger' AS lookupEntityI_Ledger,
  resultElement: 'Ledger' AS resultElementLedger,
  resultElement: 'CalendarMonth' AS resultElementCalendarMonth,
  resultElement: 'CalendarYear' AS resultElementCalendarYear,
  resultElement: 'FiscalPeriod' AS resultElementFiscalPeriod,
  GLAccount,
  ProfitCenter,
  Segment,
  ChartOfAccounts,
  FunctionalArea,
  ControllingArea,
  AlternativeGLAccount,
  CountryChartOfAccounts,
  CorporateGroupAccount,
  CorporateGroupChartOfAccounts,
  Currency,
  AlternativeGLAccountIsUsed,
  ComparisonPeriodBalanceAmount,
  cast (1 as fis_abs_diff) AS AbsoluteDifferenceAmount,
  cast (1 as fis_rel_diff) AS RelativeDifferenceAmount,
  GLAccountHierarchyKeyDate,
  ZeroBalanceAccountIsDisplayed,
  YrEndClsgPostingIsDisplayed,
  BusinessTransactionCategory,
  cast ( 1 as fis_fsv_sa_repo_amount ) AS PeriodBalanceSignAdjdAmount,
  cast ( 1 as fis_fsv_sa_comp_amount ) AS ComprnPeriodBalSignAdjdAmount,
  cast ( 1 as fis_fsv_sa_abs_diff ) AS AbsltDifferenceSignAdjdAmount,
  cast ( 1 as fis_fsv_sa_rel_diff ) AS RelativeDifferenceSignAdjdAmt
FROM I_FinancialStatementCube
LEFT OUTER JOIN I_FinancialStatementHier AS _FinancialStatementHier ON _FinancialStatementHier.FinancialStatementHierarchy = :P_FinancialStatementVersion  -- association [0..1]
LEFT OUTER JOIN I_CurrencyRole AS _CurrencyRole ON _CurrencyRole.CurrencyRole = :P_CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_PlanningCategory AS _PlanningCategory ON _PlanningCategory.PlanningCategory = :P_PlanningCategory  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON _Ledger.Ledger = :P_Ledger  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _ComparisonLedger ON _ComparisonLedger.Ledger = :P_ComparisonLedger  -- association [0..1]
;