P_CN_FinStmntBalance02

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 P_CN_FinStmntBalance02.
-- 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: PCNFINSTMNTBAL02
-- Parameters: P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_FromCurrentDate : fis_budat_from, P_FromQuarterDate : fis_budat_from, P_ToQuarterDate : fis_budat_to, P_ComprnFromPostingDate : fis_comprn_budat_from, P_ComprnToPostingDate : fis_comprn_budat_to, P_ComprnFromCurrentDate : fis_comprn_budat_from, P_FiscalPeriod : fins_fiscalperiod, P_ToQuarterFiscalPeriod : fins_fiscalperiod, P_CompanyCode : fis_bukrs, P_CurrencyCode : fac_crcyrole, P_Ledger : fis_rldnr, P_LedgerFiscalYear : fis_gjahr, P_ChartOfAccounts : fis_ktopl

CREATE VIEW P_CN_FinStmntBalance02 AS
SELECT
  Ledger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  LedgerFiscalYear,
  GLAccount,
  AlternativeGLAccount,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  Segment,
  PostingDate,
  ChartOfAccounts,
  CountryChartOfAccounts,
  DebitCreditCode,
  FiscalPeriod
FROM P_CN_FinStmntBalance01
LEFT OUTER JOIN I_LedgerCompanyCodeCrcyRoleVH AS _Currency ON _Currency.CompanyCode = P_CN_FinStmntBalance01.CompanyCode AND _Currency.Ledger = P_CN_FinStmntBalance01.Ledger  -- association [0..1]
;