P_RU_GLAcctBalance4

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_RU_GLAcctBalance4.
-- 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: PRUGLACCTBAL4
-- Parameters: P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_DisplayCurrency : firu_display_currency, P_GLAccountGroup : firu_account_grouping, P_DisplayAltvAcct : firu_display_account, P_ZeroBalanceGLAccIsDisplayed : firu_zero_turnover

CREATE VIEW P_RU_GLAcctBalance4 AS
SELECT
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  Ledger,
  ChartOfAccounts,
  CountryChartOfAccounts,
  GLAccount,
  GLAccountExternal,
  AlternativeGLAccount,
  DocumentDate,
  DocumentItemText,
  LogicalSystem,
  AccountingDocumentCreationDate,
  DocumentReferenceID,
  AccountingDocumentHeaderText,
  OffsettingItem,
  OffsettingChartOfAccounts,
  OffsettingAccount,
  OffsettingAccountExternal,
  ControllingArea,
  CostCenter,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  Segment,
  OrderID,
  WBSElement,
  WBSElementInternalID,
  ContractNumber,
  Product,
  Plant,
  Supplier,
  Customer,
  AccountingDocumentType,
  DebitCreditCode,
  PostingDate,
  FiscalPeriod,
  StartingBalAmtInDspCrcy,
  EndingBalAmtInDspCrcy,
  DebitAmountInDisplayCrcy,
  CreditAmountInDisplayCrcy,
  PeriodTurnoverInDisplayCrcy,
  Currency,
  BaseUnit,
  Quantity
FROM P_RU_GLAcctBalance3
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _AlternativeGLAccount ON CountryChartOfAccounts = _AlternativeGLAccount.ChartOfAccounts AND AlternativeGLAccount = _AlternativeGLAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _OffsettingAccount ON OffsettingChartOfAccounts = _OffsettingAccount.ChartOfAccounts AND OffsettingAccount = _OffsettingAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _CountryChartOfAccounts ON CountryChartOfAccounts = _CountryChartOfAccounts.ChartOfAccounts  -- association [0..1]
;