C_RU_GLAcctBalanceCube

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 C_RU_GLAcctBalanceCube.
-- 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: CRUGLACCTBALC
-- 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 C_RU_GLAcctBalanceCube AS
SELECT
  P_RU_GLAcctBalance4.Ledger AS Ledger,
  P_RU_GLAcctBalance4.CompanyCode AS CompanyCode,
  cast( P_RU_GLAcctBalance4.FiscalYear as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  P_RU_GLAcctBalance4.SourceLedger AS SourceLedger,
  P_RU_GLAcctBalance4.AccountingDocument AS AccountingDocument,
  P_RU_GLAcctBalance4.LedgerGLLineItem AS LedgerGLLineItem,
  ChartOfAccounts,
  CountryChartOfAccounts,
  GLAccount,
  GLAccountExternal,
  AlternativeGLAccount,
  DocumentDate,
  DocumentItemText,
  LogicalSystem,
  AccountingDocumentCreationDate,
  DocumentReferenceID,
  AccountingDocumentHeaderText,
  OffsettingItem,
  OffsettingChartOfAccounts,
  cast( OffsettingAccount as fis_racct preserving type ) AS OffsettingAccount,
  OffsettingAccountExternal,
  ControllingArea,
  CostCenter,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  Segment,
  OrderID,
  WBSElement,
  WBSElementInternalID,
  ContractNumber AS ContractNum,
  Product,
  Plant,
  P_RU_GLAcctBalance4.Supplier AS Supplier,
  P_RU_GLAcctBalance4.Customer AS Customer,
  AccountingDocumentType,
  DebitCreditCode,
  PostingDate,
  FiscalPeriod,
  StartingBalAmtInDspCrcy,
  EndingBalAmtInDspCrcy,
  DebitAmountInDisplayCrcy,
  CreditAmountInDisplayCrcy,
  P_RU_GLAcctBalance4.Currency AS Currency,
  BaseUnit,
  Quantity,
  P_RU_GLAcctBalance4._CompanyCode AS _CompanyCode,
  P_RU_GLAcctBalance4._Supplier AS _Supplier,
  P_RU_GLAcctBalance4._Customer AS _Customer,
  P_RU_GLAcctBalance4._Supplier.AuthorizationGroup AS SupplierFinsAuthorizationGrp,
  P_RU_GLAcctBalance4._Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  P_RU_GLAcctBalance4._Supplier.IsBusinessPurposeCompleted AS SupplierIsBusPrpsCmpltd,
  SupplierCompany.AuthorizationGroup AS SupplierCompanyAuthznGroup,
  SupplierCompany.IsBusinessPurposeCompleted AS SuplrCoIsBusPrpsCmpltd,
  P_RU_GLAcctBalance4._Customer.AuthorizationGroup AS CustomerFinsAuthorizationGrp,
  P_RU_GLAcctBalance4._Customer.CustomerAccountGroup AS CustomerAccountGroup,
  P_RU_GLAcctBalance4._Customer.IsBusinessPurposeCompleted AS CustomerIsBusPrpsCmpltd,
  CustomerCompany.AuthorizationGroup AS CustomerCompanyAuthznGroup,
  CustomerCompany.IsBusinessPurposeCompleted AS CustCoIsBusPrpsCmpltd
FROM P_RU_GLAcctBalance4
;