C_CN_FinStmntUnassignBalance

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_CN_FinStmntUnassignBalance.
-- 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: CCNFINSTMNTUBAL
-- Parameters: P_Language : sylangu, P_KeyDate : sydate, P_Ledger : fis_rldnr, P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_FromPeriodBeginDate : figlcn_period_from, P_FromQuarterBeginDate : figlcn_quarter_from, P_ToQuarterEndDate : figlcn_quarter_to, P_ComprnFromPostingDate : fis_comprn_budat_from, P_ComprnToPostingDate : fis_comprn_budat_to, P_ComprnFromPeriodBeginDate : figlcn_comprn_period_from, P_FiscalPeriod : fins_fiscalperiod, P_ReportingPeriod : fins_fiscalperiod, P_CompanyCode : fis_bukrs, P_FinStmntFormStruc : idcn_fsckey, P_FinancialStatementVariant : versn_011, P_ChartOfAccounts : fis_ktopl, P_Currency : fac_crcyrole, P_LedgerFiscalYear : fis_gjahr, P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst

CREATE VIEW C_CN_FinStmntUnassignBalance AS
SELECT
  FinancialStatementVariant,
  FinancialStatementItem,
  GLAccount,
  FunctionalArea,
  _GLAccountText[1: Language = $parameters.P_Language].GLAccountName AS GLAccountName,
  _Text[1: Language = $parameters.P_Language].FinStatementItemDescription AS FinStatementItemDescription,
  AlternativeGLAccount,
  _AlternativeAccountText[1: Language = $parameters.P_Language].GLAccountName AS AlternativeGLAccountName,
  ProfitCenter,
  BusinessArea,
  Segment,
  :P_CompanyCode AS CompanyCode,
  :P_Ledger AS Ledger,
  :P_ChartOfAccounts AS ChartOfAccounts,
  cast(:P_DisplayCurrency as vdm_v_display_currency) AS DisplayCurrency
FROM P_CN_FinStmntUnassignBalCal
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON l.ChartOfAccounts = _GLAccountText.ChartOfAccounts AND l.GLAccount = _GLAccountText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GLAccountText AS _AlternativeAccountText ON l.CountryChartOfAccounts = _AlternativeAccountText.ChartOfAccounts AND l.AlternativeGLAccount = _AlternativeAccountText.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_FinancialStatementItemText AS _Text ON FinancialStatementVariant = _Text.FinancialStatementVariant AND FinancialStatementItem = _Text.FinancialStatementItem  -- association [0..*]
;