C_GR_GLAccountSuplrDetCube

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_GLAccountSuplrDetCube.
-- 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_GLAccountSuplrDetCube 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.Supplier AS Supplier,
  Item.GLAccount AS GLAccount,
  Item.ChartOfAccounts AS ChartOfAccounts,
  Item.CountryChartOfAccounts AS CountryChartOfAccounts,
  Item.AlternativeGLAccount AS AlternativeGLAccount,
  Item.PostingDate AS PostingDate,
  Item.PostingKey AS PostingKey,
  Item.SpecialGLCode AS SpecialGLCode,
  Item.BranchAccount AS BranchAccount,
  _JournalEntryItem.ReferenceDocument AS ReferenceDocument,
  _JournalEntryItem.DocumentItemText AS DocumentItemText,
  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,
  _Supplier.BPSupplierName AS SupplierName,
  _Supplier._SupplierCompany[1: CompanyCode = companycode ].SupplierHeadOffice AS SupplierHeadOffice,
  _Supplier.AddressID AS SupplierAddressID,
  _Supplier.Country AS SupplierCountry,
  _Supplier.VATRegistration AS SupplierVATRegistration
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_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- 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]
;