P_RU_GLAcctBalance12

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_GLAcctBalance12.
-- 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: PRUGLACCTBAL12
-- Parameters: P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_DisplayAltvAcct : firu_display_account

CREATE VIEW P_RU_GLAcctBalance12 AS
SELECT
  GLAccountLineItem.SourceLedger AS SourceLedger,
  GLAccountLineItem.CompanyCode AS CompanyCode,
  GLAccountLineItem.FiscalYear AS FiscalYear,
  cast('' as fis_belnr) AS AccountingDocument,
  cast('' as fis_docln) AS LedgerGLLineItem,
  GLAccountLineItem.Ledger AS Ledger,
  case $parameters.P_DisplayAltvAcct when '' then GLAccountLineItem._GLAccountInChartOfAccounts.GLAccountExternal else GLAccountLineItem._AlternativeGLAccount.GLAccountExternal end as GLAccountExternal AS GLAccountExternalendasGLAccountExternal,
  cast('' as fis_gkont) AS OffsettingItem,
  cast('' as fis_ktopl) AS OffsettingChartOfAccounts,
  cast('*' as fis_racct) AS OffsettingAccount,
  cast('*' as fis_racct) AS OffsettingAccountExternal,
  GLAccountLineItem.ChartOfAccounts AS ChartOfAccounts,
  GLAccountLineItem.CountryChartOfAccounts AS CountryChartOfAccounts,
  GLAccountLineItem.GLAccount AS GLAccount,
  GLAccountLineItem.AlternativeGLAccount AS AlternativeGLAccount,
  cast('00000000' as fis_bldat) AS DocumentDate,
  cast('' as farp_sgtxt) AS DocumentItemText,
  cast('' as awsys) AS LogicalSystem,
  cast('00000000' as farp_cpudt) AS AccountingDocumentCreationDate,
  cast('' as fis_xblnr1) AS DocumentReferenceID,
  cast('' as bktxt) AS AccountingDocumentHeaderText,
  cast('' as fis_kokrs) AS ControllingArea,
  cast('' as fis_kostl) AS CostCenter,
  cast('' as fis_prctr) AS ProfitCenter,
  cast('' as fm_farea) AS FunctionalArea,
  cast('' as fis_rbusa) AS BusinessArea,
  cast('' as segment) AS Segment,
  cast('' as fis_aufnr) AS OrderID,
  cast('' as ps_posid) AS WBSElement,
  cast('00000000' as ps_s4_pspnr) AS WBSElementInternalID,
  cast('' as j_3rf_intcntnum) AS ContractNumber,
  cast('' as productnumber) AS Product,
  cast('' as werks_d) AS Plant,
  cast('' as md_supplier) AS Supplier,
  cast('' as kunnr) AS Customer,
  cast('' as fis_blart) AS AccountingDocumentType,
  cast('' as fis_shkzg) AS DebitCreditCode,
  cast('00000000' as fis_budat) AS PostingDate,
  cast('000' as fins_fiscalperiod) AS FiscalPeriod,
  GLAccountLineItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  GLAccountLineItem.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  GLAccountLineItem.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  GLAccountLineItem.TransactionCurrency AS TransactionCurrency,
  GLAccountLineItem.DebitAmountInTransCrcy AS DebitAmountInTransCrcy,
  GLAccountLineItem.CreditAmountInTransCrcy AS CreditAmountInTransCrcy,
  GLAccountLineItem.BaseUnit AS BaseUnit,
  GLAccountLineItem.Quantity AS Quantity,
  GLAccountLineItem._SourceLedger AS _SourceLedger,
  GLAccountLineItem._CompanyCode AS _CompanyCode,
  GLAccountLineItem._FiscalYear AS _FiscalYear,
  GLAccountLineItem._Ledger AS _Ledger,
  'P' AS PeriodFlag,
  coalesce(GLAcctBalance13.DisplayZeroTurnovers,'X') AS DisplayZeroTurnovers,
  '' AS EmptyValue
FROM I_GLAccountLineItem AS GLAccountLineItem
LEFT OUTER JOIN P_RU_GLAcctBalance13 ON /* join condition not captured in parsed metadata */
INNER JOIN I_FiscalCalendarDate AS FiscalYearPeriod ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_GLAccountLineItem
;