I_FinStmntComparisonCube

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_FinStmntComparisonCube.
-- 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.
-- Parameters: P_FinancialStatementVersion : hryid, P_FromFiscalPeriod : fis_period_from, P_ToFiscalPeriod : fis_period_to, P_LedgerFiscalYear : fis_gjahr_no_conv, P_FromComparisonFiscalPeriod : fis_period_from_cmp, P_ToComparisonFiscalPeriod : fis_period_to_cmp, P_ComparisonLedgerFiscalYear : fis_gjahr_cmp_no_conv, P_Ledger : fins_ledger, P_ComparisonLedger : fis_ledger_cmp, P_CurrencyRole : fis_curtp, P_PlanningCategory : fcom_category, P_FinancialStatementSection : fis_financialstatementsection

CREATE VIEW I_FinStmntComparisonCube AS
SELECT
  Ledger,
  SourceLedger,
  CompanyCode,
  cast( FiscalYear as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  LedgerFiscalYear,
  ControllingArea,
  ChartOfAccounts,
  GLAccount,
  cast(concat(ChartOfAccounts,concat(lpad(GLAccount,12,'0'),'A')) as fins_fsleafit) AS FinancialStatementLeafItem,
  ProfitCenter,
  FunctionalArea,
  FiscalPeriod,
  FiscalYearVariant,
  AlternativeGLAccount,
  CountryChartOfAccounts,
  Segment,
  _GLAccountInChartOfAccounts.CorporateGroupAccount AS CorporateGroupAccount,
  _ChartOfAccounts.CorporateGroupChartOfAccounts AS CorporateGroupChartOfAccounts,
  cast (' ' as fis_disalteracct) AS AlternativeGLAccountIsUsed,
  cast (CompanyCodeCurrency as fis_waers) AS Currency,
  cast( 1 as fis_repo_amount ) AS PeriodBalanceAmount,
  cast( 1 as fis_comp_amount ) AS ComparisonPeriodBalanceAmount,
  cast( '00000000' as fis_glaccthier_keydate ) AS GLAccountHierarchyKeyDate,
  cast( ' ' as fis_zerobalance) AS ZeroBalanceAccountIsDisplayed,
  cast( ' ' as fis_inclyearendpostings ) AS YrEndClsgPostingIsDisplayed,
  GLRecordType,
  BusinessTransactionCategory,
  $parameters.P_FinancialStatementSection AS FinancialStatementSection,
  AssetClass,
  CostCenter,
  DistributionChannel,
  FinancialAccountType,
  OrganizationDivision,
  SalesOrganization,
  ValuationArea,
  AccountingDocumentType,
  Customer,
  OrderID,
  SalesDocument,
  ServiceDocument,
  ServiceDocumentType,
  Supplier,
  PostingDate
FROM I_GLAccountLineItem
LEFT OUTER JOIN I_FinancialStatementLeafItem AS _FinancialStatementLeafItem ON FinancialStatementLeafItem = _FinancialStatementLeafItem.FinancialStatementLeafItem  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _CorpGroupChartOfAccounts ON corporategroupchartofaccounts = _CorpGroupChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _CorporateGroupAccount ON corporategroupchartofaccounts = _CorporateGroupAccount.ChartOfAccounts AND CorporateGroupAccount = _CorporateGroupAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_AlternativeGLAccountIsUsed AS _AlternativeGLAccountIsUsed ON AlternativeGLAccountIsUsed = _AlternativeGLAccountIsUsed.AlternativeGLAccountIsUsed  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _ZeroBalanceAccountIsDisplayed ON ZeroBalanceAccountIsDisplayed = _ZeroBalanceAccountIsDisplayed.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _YrEndClsgPostingIsDisplayed ON YrEndClsgPostingIsDisplayed = _YrEndClsgPostingIsDisplayed.IndicatorValue  -- association [0..1]
;