C_RU_GLAcctBalanceQuery

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_GLAcctBalanceQuery.
-- 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: CRUGLACCTBALQ
-- Parameters: P_Language : sylangu, P_KeyDate : sydate, 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_GLAcctBalanceQuery AS
SELECT
  lookupEntity: 'I_CalendarDate' AS lookupEntityI_CalendarDate,
  resultElement: 'FirstDayofMonthDate' AS resultElementFirstDayofMonthDate,
  resultElement: 'CalendarDate' AS resultElementCalendarDate,
  _Ledger._Text[1: Language = $parameters.P_Language].LedgerName AS LedgerName,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  cast(OffsettingItem as firu_offs_item) AS OffsettingItem,
  cast(ChartOfAccounts as fis_ktopl) AS ChartOfAccounts,
  cast(CountryChartOfAccounts as fis_ktop2) AS CountryChartOfAccounts,
  cast(GLAccount as fis_racct) AS GLAccount,
  _GLAccountInChartOfAccounts._Text[1: Language = $parameters.P_Language].GLAccountName AS GLAccountName,
  cast(AlternativeGLAccount as fis_altkt_skb1) AS AlternativeGLAccount,
  _AlternativeGLAccount._Text[1: Language = $parameters.P_Language].GLAccountName AS AlternativeGLAccountName,
  cast(GLAccountExternal as firu_account_gr) AS GLAccountExternal,
  DocumentDate,
  cast(DocumentItemText as fis_sgtxt) AS DocumentItemText,
  LogicalSystem,
  AccountingDocumentCreationDate,
  DocumentReferenceID,
  AccountingDocumentHeaderText,
  cast(OffsettingAccount as fis_gkont) AS OffsettingAccount,
  _OffsettingAccount._Text[1: Language = $parameters.P_Language].GLAccountName AS OffsettingAccountName,
  cast(OffsettingAccountExternal as firu_offs_account_gr) AS OffsettingAccountExternal,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  CostCenter,
  _CostCenter[1:ValidityEndDate >= $parameters.P_KeyDate and ValidityStartDate <= $parameters.P_KeyDate]._Text[1:Language = $parameters.P_Language].CostCenterName AS CostCenterName,
  ProfitCenter,
  _ProfitCenter[1:ValidityEndDate >= $parameters.P_KeyDate and ValidityStartDate <= $parameters.P_KeyDate]._Text[1:Language = $parameters.P_Language].ProfitCenterName AS ProfitCenterName,
  FunctionalArea,
  _FunctionalArea._Text[1: Language = $parameters.P_Language].FunctionalAreaName AS FunctionalAreaName,
  BusinessArea,
  _BusinessArea._Text[1: Language = $parameters.P_Language].BusinessAreaName AS BusinessAreaName,
  Segment,
  _Segment._Text[1: Language = $parameters.P_Language].SegmentName AS SegmentName,
  OrderID,
  WBSElementInternalID,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  _WBSElementBasicData.WBSDescription AS WBSDescription,
  cast(ContractNum as j_3rf_intcntnum) AS ContractNum,
  Product,
  _Product._Text[1: Language = $parameters.P_Language].ProductName AS ProductName,
  Plant,
  _Plant.PlantName AS PlantName,
  Supplier,
  _Supplier.BPSupplierName AS BPSupplierName,
  Customer,
  _Customer.BPCustomerName AS BPCustomerName,
  AccountingDocumentType,
  _AccountingDocumentType._Text[1:Language = $parameters.P_Language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  DebitCreditCode,
  _DebitCreditCode._Text[1:Language = $parameters.P_Language].DebitCreditCodeName AS DebitCreditCodeName,
  PostingDate,
  FiscalPeriod,
  cast(StartingBalAmtInDspCrcy as firu_start_bal) AS StartingBalAmtInDspCrcy,
  cast(DebitAmountInDisplayCrcy as fis_debit_amount_display_crcy) AS DebitAmountInDisplayCrcy,
  cast(CreditAmountInDisplayCrcy as firu_cred_amount_display_crcy) AS CreditAmountInDisplayCrcy,
  cast(EndingBalAmtInDspCrcy as fis_end_bal) AS EndingBalAmtInDspCrcy,
  cast(Currency as vdm_v_display_currency) AS Currency
FROM C_RU_GLAcctBalanceCube
;