C_GR_GLAccountCustDetCube

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_GR_GLAccountCustDetCube.
-- 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.
-- Parameters: P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_FromFiscalPeriod : fis_period_from, P_ToFiscalPeriod : fis_period_to, P_BalanceCumulativeLevel : fis_cuml_level, P_ZeroBalanceGLAccIsDisplayed : figr_de_isgl_zeroaccntdisplay, P_IsHeadOffice : figr_de_isgl_display_branch, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW C_GR_GLAccountCustDetCube AS
SELECT
  Item.Ledger AS Ledger,
  Item.SourceLedger AS SourceLedger,
  Item.FiscalYear AS FiscalYear,
  Item.CompanyCode AS CompanyCode,
  Item.AccountingDocument AS AccountingDocument,
  Item.LedgerGLLineItem AS LedgerGLLineItem,
  Item.Customer AS Customer,
  Item.GLAccount AS GLAccount,
  Item.ChartOfAccounts AS ChartOfAccounts,
  Item.CountryChartOfAccounts AS CountryChartOfAccounts,
  Item.AlternativeGLAccount AS AlternativeGLAccount,
  Item.PostingDate AS PostingDate,
  Item.PostingKey AS PostingKey,
  _JournalEntryItem.ReferenceDocument AS ReferenceDocument,
  Item.SpecialGLCode AS SpecialGLCode,
  Item.BranchAccount AS BranchAccount,
  Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  Item.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  Item.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  Item.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  Item.CumulativeBalAmtInCoCodeCrcy AS CumulativeBalAmtInCoCodeCrcy,
  Item.CarryFwdBalAmtInCCCrcy AS CarryFwdBalAmtInCCCrcy,
  Item.DebitCarryFwdBalAmtInCCCrcy AS DebitCarryFwdBalAmtInCCCrcy,
  Item.CreditCarryFwdBalAmtInCCCrcy AS CreditCarryFwdBalAmtInCCCrcy,
  Item.PrevPeriodYTDAmtInCCCrcy AS PrevPeriodYTDAmtInCCCrcy,
  Item.DebitPrevPeriodYTDAmtInCCCrcy AS DebitPrevPeriodYTDAmtInCCCrcy,
  Item.CreditPrevPeriodYTDAmtInCCCrcy AS CreditPrevPeriodYTDAmtInCCCrcy,
  Item.EndingBalanceAmtInCoCodeCrcy AS EndingBalanceAmtInCoCodeCrcy,
  _Customer.BPCustomerName AS CustomerName,
  _Customer._CustomerCompany[1: CompanyCode = companycode ].CustomerHeadOffice AS CustomerHeadOffice,
  _Customer.AddressID AS SDCustomerAddressID,
  _Customer.Country AS CustomerCountry,
  _Customer.VATRegistration AS CustomerVATRegistration,
  _JournalEntryItem.DocumentItemText AS DocumentItemText
FROM P_GR_GLAccountPartnerDetail
LEFT OUTER JOIN I_JournalEntryItem AS _JournalEntryItem ON SourceLedger = _JournalEntryItem.SourceLedger AND Ledger = _JournalEntryItem.Ledger AND FiscalYear = _JournalEntryItem.FiscalYear AND CompanyCode = _JournalEntryItem.CompanyCode AND AccountingDocument = _JournalEntryItem.AccountingDocument AND LedgerGLLineItem = _JournalEntryItem.LedgerGLLineItem  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
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_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _CountryChartOfAccounts ON CountryChartOfAccounts = _CountryChartOfAccounts.ChartOfAccounts  -- association [0..1]
;