P_PE_TrialBalanceRptgCrcyAmt

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 P_PE_TrialBalanceRptgCrcyAmt.
-- 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_ReportingCurrency : glo_reporting_currency

CREATE VIEW P_PE_TrialBalanceRptgCrcyAmt AS
SELECT
  I_StRpTrialBalanceItemCube.Ledger AS Ledger,
  I_StRpTrialBalanceItemCube.CompanyCode AS CompanyCode,
  I_StRpTrialBalanceItemCube.FiscalYear AS FiscalYear,
  I_StRpTrialBalanceItemCube.SourceLedger AS SourceLedger,
  I_StRpTrialBalanceItemCube.AccountingDocument AS AccountingDocument,
  I_StRpTrialBalanceItemCube.LedgerGLLineItem AS LedgerGLLineItem,
  I_StRpTrialBalanceItemCube.StatryRptCategory AS StatryRptCategory,
  I_StRpTrialBalanceItemCube.StatryRptgEntity AS StatryRptgEntity,
  I_StRpTrialBalanceItemCube.StatryRptRunID AS StatryRptRunID,
  FSV.FinancialStatementHierarchy AS FinancialStatementHierarchy,
  FSV.HierarchyNode AS HierarchyNode,
  FSV.ParentNode AS ParentNode,
  substring(FSV.HierarchyParentNodeVal,1,1) AS ParentNodeClass,
  I_StRpTrialBalanceItemCube.AccountingDocumentItem AS AccountingDocumentItem,
  I_StRpTrialBalanceItemCube.FiscalPeriod AS FiscalPeriod,
  I_StRpTrialBalanceItemCube.PostingDate AS PostingDate,
  I_StRpTrialBalanceItemCube.DocumentDate AS DocumentDate,
  I_StRpTrialBalanceItemCube.IsReversal AS IsReversal,
  I_StRpTrialBalanceItemCube.IsReversed AS IsReversed,
  I_StRpTrialBalanceItemCube.ProfitCenter AS ProfitCenter,
  I_StRpTrialBalanceItemCube.FunctionalArea AS FunctionalArea,
  I_StRpTrialBalanceItemCube.BusinessArea AS BusinessArea,
  I_StRpTrialBalanceItemCube.ControllingArea AS ControllingArea,
  I_StRpTrialBalanceItemCube.Segment AS Segment,
  I_StRpTrialBalanceItemCube.ChartOfAccounts AS ChartOfAccounts,
  I_StRpTrialBalanceItemCube.AlternativeGLAccount AS AlternativeGLAccount,
  I_StRpTrialBalanceItemCube.CountryChartOfAccounts AS CountryChartOfAccounts,
  I_StRpTrialBalanceItemCube.GLAccount AS GLAccount,
  I_StRpTrialBalanceItemCube.GLAccountLongName AS GLAccountLongName,
  I_StRpTrialBalanceItemCube.CorporateGroupChartOfAccounts AS CorporateGroupChartOfAccounts,
  I_StRpTrialBalanceItemCube.CorporateGroupAccount AS CorporateGroupAccount,
  I_StRpTrialBalanceItemCube.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  I_StRpTrialBalanceItemCube.ReconciliationAccountType AS ReconciliationAccountType,
  I_StRpTrialBalanceItemCube.Supplier AS Supplier,
  I_StRpTrialBalanceItemCube.Customer AS Customer,
  I_StRpTrialBalanceItemCube.FinancialAccountType AS FinancialAccountType,
  I_StRpTrialBalanceItemCube.SpecialGLCode AS SpecialGLCode,
  I_StRpTrialBalanceItemCube.AccountingDocumentType AS AccountingDocumentType,
  I_StRpTrialBalanceItemCube.PostingKey AS PostingKey,
  I_StRpTrialBalanceItemCube.AccountingDocumentCategory AS AccountingDocumentCategory,
  I_StRpTrialBalanceItemCube.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  I_StRpTrialBalanceItemCube.DebitCreditCode AS DebitCreditCode,
  I_StRpTrialBalanceItemCube.CashJournalItemType AS CashJournalItemType,
  I_StRpTrialBalanceItemCube.ItemType AS ItemType,
  I_StRpTrialBalanceItemCube.TaxCode AS TaxCode,
  I_StRpTrialBalanceItemCube.JrnlEntryItemMigrationSource AS JrnlEntryItemMigrationSource,
  I_StRpTrialBalanceItemCube.FiscalYearVariant AS FiscalYearVariant,
  I_StRpTrialBalanceItemCube.ReferenceDocument AS ReferenceDocument,
  I_StRpTrialBalanceItemCube.OffsettingAccount AS OffsettingAccount,
  I_StRpTrialBalanceItemCube.OffsettingAccountType AS OffsettingAccountType,
  I_StRpTrialBalanceItemCube.AssignmentReference AS AssignmentReference,
  I_StRpTrialBalanceItemCube.DocumentItemText AS DocumentItemText,
  cast( $parameters.P_ReportingCurrency as glo_reporting_currency preserving type ) AS ReportingCurrency,
  I_StRpTrialBalanceItemCube._AccountingDocumentType AS _AccountingDocumentType,
  I_StRpTrialBalanceItemCube._AlternativeGLAccount AS _AlternativeGLAccount,
  I_StRpTrialBalanceItemCube._BusinessArea AS _BusinessArea,
  I_StRpTrialBalanceItemCube._ChartOfAccounts AS _ChartOfAccounts,
  I_StRpTrialBalanceItemCube._CompanyCode AS _CompanyCode,
  I_StRpTrialBalanceItemCube._ControllingArea AS _ControllingArea,
  I_StRpTrialBalanceItemCube._CorporateGroupAccount AS _CorporateGroupAccount,
  I_StRpTrialBalanceItemCube._CorporateGroupChartOfAccounts AS _CorporateGroupChartOfAccounts,
  I_StRpTrialBalanceItemCube._CountryChartOfAccounts AS _CountryChartOfAccounts,
  I_StRpTrialBalanceItemCube._Customer AS _Customer,
  I_StRpTrialBalanceItemCube._FunctionalArea AS _FunctionalArea,
  I_StRpTrialBalanceItemCube._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  I_StRpTrialBalanceItemCube._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  I_StRpTrialBalanceItemCube._GLAccountText AS _GLAccountText,
  I_StRpTrialBalanceItemCube._JournalEntry AS _JournalEntry,
  I_StRpTrialBalanceItemCube._PostingKey AS _PostingKey,
  I_StRpTrialBalanceItemCube._ProfitCenter AS _ProfitCenter,
  I_StRpTrialBalanceItemCube._ReportedItemsLog AS _ReportedItemsLog,
  I_StRpTrialBalanceItemCube._Segment AS _Segment,
  I_StRpTrialBalanceItemCube._Supplier AS _Supplier,
  I_StRpTrialBalanceItemCube._TaxCode AS _TaxCode
FROM I_StRpTrialBalanceItemCube
INNER JOIN I_FinancialStatementStructure AS FSV ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _ReportingCurrency ON _ReportingCurrency.Currency = ReportingCurrency  -- association [0..1]
;