P_GLAcctBalance01

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_GLAcctBalance01.
-- 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: PGLACCTBAL01
-- Parameters: P_Ledger : fis_rldnr, P_StartPostingDate : fis_budat, P_EndPostingDate : fis_budat

CREATE VIEW P_GLAcctBalance01 AS
SELECT
  GLAccountLineItem.Ledger AS Ledger,
  GLAccountLineItem.CompanyCode AS CompanyCode,
  GLAccountLineItem.FiscalYear AS FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  LedgerFiscalYear,
  ChartOfAccounts,
  AccountingDocumentType,
  GLAccount,
  CountryChartOfAccounts,
  AlternativeGLAccount,
  ControllingArea,
  CostCenter,
  ProfitCenter,
  FinancialTransactionType,
  FunctionalArea,
  BusinessArea,
  Segment,
  DebitCreditCode,
  PostingDate,
  GLAccountLineItem.FiscalPeriod AS FiscalPeriod,
  PartnerCompany,
  WBSElement,
  GLAccountType,
  LedgerCompanyCodeCrcyRole.CompanyCodeCurrencyRole AS CompanyCodeCurrencyRole,
  LedgerCompanyCodeCrcyRole.GlobalCurrencyRole AS GlobalCurrencyRole,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency1Role AS FreeDefinedCurrency1Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency2Role AS FreeDefinedCurrency2Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency3Role AS FreeDefinedCurrency3Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency4Role AS FreeDefinedCurrency4Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency5Role AS FreeDefinedCurrency5Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency6Role AS FreeDefinedCurrency6Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency7Role AS FreeDefinedCurrency7Role,
  LedgerCompanyCodeCrcyRole.FreeDefinedCurrency8Role AS FreeDefinedCurrency8Role,
  LedgerCompanyCodeCrcyRole.FunctionalCurrencyRole AS FunctionalCurrencyRole,
  CompanyCodeCurrency,
  DebitAmountInCoCodeCrcy AS DebitAmtInCoCodeCrcy,
  CreditAmountInCoCodeCrcy AS CreditAmtInCoCodeCrcy,
  GlobalCurrency,
  DebitAmountInGlobalCrcy AS DebitAmtInGlobalCrcy,
  CreditAmountInGlobalCrcy AS CreditAmtInGlobalCrcy,
  FreeDefinedCurrency1,
  DebitAmountInFreeDefinedCrcy1 AS DebitAmtInFreeDefinedCrcy1,
  CreditAmountInFreeDefinedCrcy1 AS CreditAmtInFreeDefinedCrcy1,
  FreeDefinedCurrency2,
  DebitAmountInFreeDefinedCrcy2 AS DebitAmtInFreeDefinedCrcy2,
  CreditAmountInFreeDefinedCrcy2 AS CreditAmtInFreeDefinedCrcy2,
  FreeDefinedCurrency3,
  DebitAmountInFreeDefinedCrcy3 AS DebitAmtInFreeDefinedCrcy3,
  CreditAmountInFreeDefinedCrcy3 AS CreditAmtInFreeDefinedCrcy3,
  FreeDefinedCurrency4,
  DebitAmountInFreeDefinedCrcy4 AS DebitAmtInFreeDefinedCrcy4,
  CreditAmountInFreeDefinedCrcy4 AS CreditAmtInFreeDefinedCrcy4,
  FreeDefinedCurrency5,
  DebitAmountInFreeDefinedCrcy5 AS DebitAmtInFreeDefinedCrcy5,
  CreditAmountInFreeDefinedCrcy5 AS CreditAmtInFreeDefinedCrcy5,
  FreeDefinedCurrency6,
  DebitAmountInFreeDefinedCrcy6 AS DebitAmtInFreeDefinedCrcy6,
  CreditAmountInFreeDefinedCrcy6 AS CreditAmtInFreeDefinedCrcy6,
  FreeDefinedCurrency7,
  DebitAmountInFreeDefinedCrcy7 AS DebitAmtInFreeDefinedCrcy7,
  CreditAmountInFreeDefinedCrcy7 AS CreditAmtInFreeDefinedCrcy7,
  FreeDefinedCurrency8,
  DebitAmountInFreeDefinedCrcy8 AS DebitAmtInFreeDefinedCrcy8,
  CreditAmountInFreeDefinedCrcy8 AS CreditAmtInFreeDefinedCrcy8,
  FunctionalCurrency,
  DebitAmountInFunctionalCrcy,
  CreditAmountInFunctionalCrcy,
  'R' as PeriodFlag AS LedgerasLedger,
  'O' AS PeriodFlag
FROM I_GLAccountLineItem AS GLAccountLineItem
INNER JOIN I_LedgerCompanyCodeCrcyRoles AS LedgerCompanyCodeCrcyRole ON /* join condition not captured in parsed metadata */
INNER JOIN I_FiscalCalYearPeriodForLedger AS FiscalPeriodForLedger ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_GLAccountLineItem
;