C_CN_FinStmntProfitNLoss

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_FinStmntProfitNLoss.
-- 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: CCNFINSTMNTPNL
-- 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_FinStmntProfitNLoss AS
SELECT
  FinStmntFormStruc,
  FinancialStatementVariant,
  HierarchyNode,
  ParentNode,
  FinancialStatementItem,
  cast('' as fis_prctr_hryid_42) AS ProfitCenterHierarchy,
  cast('' as fis_prctr_hrynid_50) AS ProfitCenterHierarchyNode,
  _FinStmntText[1: Language = $parameters.P_Language].SequenceNumber AS SequenceNumber,
  cast(FinStatementHierarchyLevelVal as abap.int2 ) - 1 AS FinStatementHierarchyLevelVal,
  FinStmntFormStrucItemCat,
  FinStmntFormStrucItemOffset,
  FinStmntFormStrucItemType,
  FinStmntFormStrucItemSign,
  GLAccount,
  AlternativeGLAccount,
  _AlternativeAccountText[1: Language = $parameters.P_Language].GLAccountName AS AlternativeGLAccountName,
  ProfitCenter,
  FunctionalArea,
  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_FinStmntBalanceCal
LEFT OUTER JOIN I_CN_FinStmntFormStrucLineText AS _FinStmntText ON FinStmntFormStruc = _FinStmntText.FinStmntFormStruc AND FinancialStatementVariant = _FinStmntText.FinancialStatementVariant AND HierarchyNode = _FinStmntText.FinStmntFormStrucLineNmbr  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON l.ChartOfAccounts = _GLAccountText.ChartOfAccounts AND l.GLAccount = _GLAccountText.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _AlternativeAccountText ON l.CountryChartOfAccounts = _AlternativeAccountText.ChartOfAccounts AND l.AlternativeGLAccount = _AlternativeAccountText.GLAccount  -- association [0..1]
;