P_CN_FinStmntUnassignBalCal

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_FinStmntUnassignBalCal.
-- 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: PCNFINSTMNTUBCAL
-- Parameters: P_Ledger : fis_rldnr, 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 : bukrs, P_FinStmntFormStruc : idcn_fsckey, P_FinancialStatementVariant : versn_011, P_ChartOfAccounts : ktopl, P_LedgerFiscalYear : fis_gjahr, P_CurrencyCode : fac_crcyrole

CREATE VIEW P_CN_FinStmntUnassignBalCal AS
SELECT
  FinancialStatementVariant,
  FinancialStatementItem,
  l.ChartOfAccounts AS ChartOfAccounts,
  l.GLAccount AS GLAccount,
  FunctionalArea,
  CountryChartOfAccounts,
  AlternativeGLAccount,
  ProfitCenter,
  BusinessArea,
  Segment,
  LedgerFiscalYear,
  CurrencyCode,
  StartingBalanceAmountInDspCcry + DebitAmountInDspCcry + CreditAmountInDspCcry AS EndingBalanceAmountInDspCcry,
  StartingBalanceAmountInDspCcry,
  cast(DebitAmountInDspCcry + CreditAmountInDspCcry as abap.curr( 23,2) ) AS YearBalanaceAmountInDspCcry,
  cast(PeriodDebitAmountInDspCcry + PeriodCreditAmountInDspCcry as abap.curr( 23,2) ) AS PeriodBalanceAmountInDspCcry,
  cast(QuarterDebitAmountInDspCcry + QuarterCreditAmountInDspCcry as abap.curr( 23,2) ) AS QuarterBalanceAmountInDspCcry,
  cast(ComprnPerdDebitAmtInDspCcry + ComprnPerdCreditAmtInDspCcry as abap.curr( 23,2) ) AS ComprnPerdBalanceAmtInDspCcry,
  cast(ComprnDebitAmtInDspCcry + ComprnCreditAmtInDspCcry as abap.curr( 23,2) ) AS ComprnYearBalanceAmtInDspCcry
FROM P_CN_FinStmntUnassignItemWBal
;