P_CN_CADEAddlInfoForGLAcct

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_CADEAddlInfoForGLAcct.
-- 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: PCADEGLAADDLINFO
-- Parameters: P_CompanyCode : fis_bukrs, P_Ledger : fis_rldnr, P_FinancialStatementVariant : versn_011, P_FiscalYear : fis_gjahr, P_FromFiscalPeriod : fins_fiscalperiod, P_ToFiscalPeriod : fins_fiscalperiod, P_IsSpecialPeriod : xfeld

CREATE VIEW P_CN_CADEAddlInfoForGLAcct AS
SELECT
  CompanyCode,
  Ledger,
  GLAccount,
  FiscalYear,
  FiscalPeriod,
  cast('' as md_supplier ) AS Supplier,
  cast('' as kunnr ) AS Customer,
  cast('' as fis_kostl ) AS CostCenter,
  cast('' as fis_aufnr ) AS InternalOrder,
  cast('' as kunre ) AS BillToParty,
  cast('' as fis_rbusa ) AS BusinessArea,
  cast('' as co_prznr) AS BusinessProcess,
  cast('' as fis_kokrs ) AS ControllingArea,
  cast('' as kdgrp ) AS CustomerGroup,
  cast('' as vtweg ) AS DistributionChannel,
  cast('' as fm_farea) AS FunctionalArea,
  cast('' as bp_geber ) AS Fund,
  cast('' as farp_fistl ) AS FundsCenter,
  cast('' as farp_hbkid ) AS HouseBank,
  cast('' as fac_hktid ) AS HouseBankAccount,
  cast('' as matnr) AS Material,
  cast('' as fins_matkl_pa) AS MaterialGroup,
  cast('' as werks_d ) AS Plant,
  cast('' as fis_prctr ) AS ProfitCenter,
  cast('' as ps_pspid ) AS Project,
  cast('' as nplnr ) AS ProjectNetwork,
  cast('' as bzirk ) AS SalesDistrict,
  cast('' as vkorg ) AS SalesOrganization,
  cast('' as fb_segment ) AS Segment,
  cast('' as kunwe ) AS ShipToParty,
  cast('' as fins_matnr_pa ) AS SoldMaterial,
  cast('' as ps_posid ) AS WBSElement,
  CompanyCodeCurrency,
  Currency,
  ValueIsUsedForSubtotal,
  DebitAmountInCoCodeCrcy,
  CreditAmountInCoCodeCrcy,
  OpeningBalanceAmtInCoCodeCrcy,
  EndingBalanceAmtInCoCodeCrcy,
  P_IsSpecialPeriod: :P_IsSpecialPeriod) as ReportStructure left outer join P_CN_CADEAcctgBalWthAddlInfo( P_CompanyCode : $parameters.P_CompanyCode AS P_CompanyCode,
  P_FiscalYear : $parameters.P_FiscalYear AS P_FiscalYear,
  P_Ledger : $parameters.P_Ledger AS P_Ledger,
  P_FromFiscalPeriod : $parameters.P_FromFiscalPeriod AS P_FromFiscalPeriod,
  P_ToFiscalPeriod : $parameters.P_ToFiscalPeriod AS P_ToFiscalPeriod,
  case when TransactionCurrency is not null then TransactionCurrency else ReportStructure.CompanyCodeCurrency end as Currency AS CompanyCodeCurrencyendasCurrency,
  sum(DebitAmountInTransCrcy) AS DebitAmountInTransCrcy,
  sum(CreditAmountInTransCrcy) AS CreditAmountInTransCrcy,
  sum(OpeningBalanceAmtInTransCrcy) AS OpeningBalanceAmtInTransCrcy,
  sum(EndingBalanceAmtInTransCrcy) AS EndingBalanceAmtInTransCrcy
FROM P_CN_CADEAcctgBalWFinStmntVers
LEFT OUTER JOIN P_CN_CADEAcctgBalWthAddlInfo ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_CN_CADEAcctBalanceStructure
;