C_GR_StRpTrialBalHierCube

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_StRpTrialBalHierCube.
-- 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

CREATE VIEW C_GR_StRpTrialBalHierCube AS
SELECT
  cube.Ledger AS Ledger,
  cube.CompanyCode AS CompanyCode,
  cube.SourceLedger AS SourceLedger,
  cube.AccountingDocument AS AccountingDocument,
  cube.FiscalYear AS FiscalYear,
  cube.LedgerGLLineItem AS LedgerGLLineItem,
  cube.StatryRptgEntity AS StatryRptgEntity,
  cube.StatryRptCategory AS StatryRptCategory,
  cube.StatryRptRunID AS StatryRptRunID,
  cube.GLAccount AS GLAccount,
  cube.ChartOfAccounts AS ChartOfAccounts,
  cube.CountryChartOfAccounts AS CountryChartOfAccounts,
  cube.AlternativeGLAccount AS AlternativeGLAccount,
  cube.FiscalPeriod AS FiscalPeriod,
  cube.PostingDate AS PostingDate,
  cube.DocumentDate AS DocumentDate,
  cube.Supplier AS Supplier,
  cube.GLAccountLongName AS GLAccountLongName,
  cube.Customer AS Customer,
  cube.BusinessArea AS BusinessArea,
  cube.FunctionalArea AS FunctionalArea,
  cube.FinancialAccountType AS FinancialAccountType,
  cube.SpecialGLCode AS SpecialGLCode,
  cube.AccountingDocumentType AS AccountingDocumentType,
  cube.PostingKey AS PostingKey,
  cube.AccountingDocumentCategory AS AccountingDocumentCategory,
  cube.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  cube.DebitCreditCode AS DebitCreditCode,
  cube.AssignmentReference AS AssignmentReference,
  cube.DocumentItemText AS DocumentItemText,
  CompanyCodeCurrency,
  CarryFwdBalAmtInCCCrcy,
  DebitCarryFwdBalAmtInCCCrcy,
  CreditCarryFwdBalAmtInCCCrcy,
  PrevPeriodYTDAmtInCCCrcy,
  DebitPrevPeriodYTDAmtInCCCrcy,
  CreditPrevPeriodYTDAmtInCCCrcy,
  StartingBalanceAmtInCoCodeCrcy,
  DebitStartingBalAmtInCCCrcy,
  CreditStartingBalAmtInCCCrcy,
  AmountInCompanyCodeCurrency,
  DebitAmountInCoCodeCrcy,
  CreditAmountInCoCodeCrcy,
  EndingBalanceAmtInCoCodeCrcy,
  DebitEndingBalAmtInCCCrcy,
  CreditEndingBalAmtInCCCrcy,
  YTDAmtInLoclCrcy,
  YTDDebitAmtInCoCodeCrcy,
  YTDCrdtAmtInCoCodeCrcy,
  TransactionCurrency,
  CarryFwdBalanceAmtInTransCrcy,
  DebitCarryFwdBalAmtInTransCrcy,
  CrdtCarryFwdBalAmtInTransCrcy,
  PrevPerdYTDAmountInTransCrcy,
  DebitPrevPerdYTDAmtInTransCrcy,
  CrdtPrevPerdYTDAmtInTransCrcy,
  StartingBalanceAmtInTransCrcy,
  DebitStartingBalAmtInTransCrcy,
  CrdtStartingBalAmtInTransCrcy,
  AmountInTransactionCurrency,
  DebitAmountInTransCrcy,
  CreditAmountInTransCrcy,
  EndingBalanceAmtInTransCrcy,
  DebitEndingBalAmtInTransCrcy,
  CreditEndingBalAmtInTransCrcy,
  YrToDteAmtInTransacCrcy,
  YTDDebitAmtInTransCrcy,
  YTDCrdtAmtInTransCrcy,
  BalanceTransactionCurrency,
  CarryFwdBalAmtInBalTransCrcy,
  DebitCarryFwdBalAmtInBlTCrcy,
  CrdtCarryFwdBalAmtInBlTCrcy,
  PrevPeriodYTDAmtInBalTransCrcy,
  DebitPrevPerdYTDAmtInBlTCrcy,
  CrdtPrevPerdYTDAmtInBlTCrcy,
  StartingBalAmtInBalTransCrcy,
  DebitStrtgBalAmtInBalTransCrcy,
  CrdtStrtgBalAmtInBalTransCrcy,
  DebitAmountInBalanceTransCrcy,
  CreditAmountInBalanceTransCrcy,
  EndingBalanceAmtInBalTransCrcy,
  DebitEndgBalAmtInBalTransCrcy,
  CreditEndgBalAmtInBalTransCrcy,
  YearToDateAmountInBalTransCrcy,
  DebitYTDAmountInBalTransCrcy,
  CreditYTDAmountInBalTransCrcy,
  GlobalCurrency,
  CarryFwdBalanceAmtInGlobalCrcy,
  DebitCarryFwdBalAmtInGlobCrcy,
  CrdtCarryFwdBalAmtInGlobalCrcy,
  PrevPerdYTDAmountInGlobalCrcy,
  DebitPrevPerdYTDAmtInGlobCrcy,
  CreditPrevPerdYTDAmtInGlobCrcy,
  StartingBalanceAmtInGlobalCrcy,
  DebitStartingBalAmtInGlobCrcy,
  CreditStartingBalAmtInGlobCrcy,
  DebitAmountInGlobalCrcy,
  CreditAmountInGlobalCrcy,
  EndingBalanceAmtInGlobalCrcy,
  DebitEndingBalAmtInGlobalCrcy,
  CreditEndingBalAmtInGlobalCrcy,
  YearToDateAmountInGlobalCrcy,
  DebitYTDAmountInGlobalCurrency,
  CreditYTDAmtInGlobalCurrency,
  FreeDefinedCurrency1,
  CarryFwdBalAmountInFDCrcy1,
  DebitCarryFwdBalAmtInFDCrcy1,
  CreditCarryFwdBalAmtInFDCrcy1,
  PrevPerdYTDAmountInFDCrcy1,
  DebitPrevPerdYTDAmtInFDCrcy1,
  CreditPrevPerdYTDAmtInFDCrcy1,
  StrtgBalAmtInFreeDfndCrcy1,
  DebitStartBalAmountInFDCrcy1,
  CreditStartBalAmountInFDCrcy1,
  DebitAmountInFreeDfndCrcy1,
  CreditAmountInFreeDfndCrcy1,
  EndingBalAmtInFreeDfndCrcy1,
  DebitEndingBalAmountInFDCrcy1,
  CreditEndingBalAmountInFDCrcy1,
  YearToDateAmountInFDCrcy1,
  DebitYTDAmountInFDCrcy1,
  CreditYTDAmountInFDCrcy1
FROM I_StRpTrialBalanceItemCube
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]
;