I_FinancialStatementCube

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_FinancialStatementCube.
-- 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: IFIFINSTMTCUBE
-- Parameters: P_FinancialStatementVersion : hryid, P_FromFiscalPeriod : fis_period_from, P_ToFiscalPeriod : fis_period_to, P_FiscalYear : fis_gjahr_no_conv, P_FromComparisonFiscalPeriod : fis_period_from_cmp, P_ToComparisonFiscalPeriod : fis_period_to_cmp, P_ComparisonFiscalYear : fis_gjahr_cmp_no_conv, P_Ledger : fins_ledger, P_ComparisonLedger : fis_ledger_cmp, P_CurrencyRole : fis_curtp, P_PlanningCategory : fcom_category

CREATE VIEW I_FinancialStatementCube 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_fsleaf) 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
FROM I_GLAccountLineItem
LEFT OUTER JOIN E_JournalEntryItem AS _Extension ON SourceLedger = _Extension.SourceLedger AND CompanyCode = _Extension.CompanyCode AND FiscalYear = _Extension.FiscalYear AND AccountingDocument = _Extension.AccountingDocument AND LedgerGLLineItem = _Extension.LedgerGLLineItem  -- association [1..1]
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]
;