C_CL_StRpJournalEntryItemCube

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_CL_StRpJournalEntryItemCube.
-- 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: CCLSTRPJEITM
-- Parameters: P_ReportingCurrency : glo_reporting_currency

CREATE VIEW C_CL_StRpJournalEntryItemCube AS
SELECT
  JournalEntryItem.SourceLedger AS SourceLedger,
  JournalEntryItem.CompanyCode AS CompanyCode,
  JournalEntryItem.FiscalYear AS FiscalYear,
  JournalEntryItem.AccountingDocument AS AccountingDocument,
  JournalEntryItem.LedgerGLLineItem AS LedgerGLLineItem,
  JournalEntryItem.SourceLedger AS Ledger,
  JournalEntryLog.StatryRptgEntity AS StatryRptgEntity,
  JournalEntryLog.StatryRptCategory AS StatryRptCategory,
  JournalEntryLog.StatryRptRunID AS StatryRptRunID,
  JournalEntryItem._JournalEntry.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  JournalEntryItem._JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  JournalEntryItem.AccountingDocumentType AS AccountingDocumentType,
  cast( substring(JournalEntryItem._JournalEntry._AccountingDocumentTypeText[1:Language = $session.system_language].AccountingDocumentTypeName, 1, 15) as farp_ltext_003t ) AS AccountingDocumentTypeName,
  I_CL_DocTypeVchrTypeAssgmt.CL_ReportingDocumentType AS CL_ReportingDocumentType,
  JournalEntryItem.AccountingDocumentCategory AS AccountingDocumentCategory,
  JournalEntryItem.FinancialAccountType AS FinancialAccountType,
  JournalEntryItem.GLRecordType AS GLRecordType,
  JournalEntryItem.GLAccountType AS GLAccountType,
  JournalEntryItem.GLAccount AS GLAccount,
  JournalEntryItem._GLAccountInChartOfAccounts._Text[1:Language = $session.system_language].GLAccountLongName AS GLAccountLongName,
  JournalEntryItem.AlternativeGLAccount AS AlternativeGLAccount,
  JournalEntryItem.ChartOfAccounts AS ChartOfAccounts,
  JournalEntryItem.CountryChartOfAccounts AS CountryChartOfAccounts,
  JournalEntryItem.FiscalPeriod AS FiscalPeriod,
  JournalEntryItem.FiscalYearVariant AS FiscalYearVariant,
  JournalEntryItem.FiscalYearPeriod AS FiscalYearPeriod,
  JournalEntryItem.DocumentDate AS DocumentDate,
  JournalEntryItem.PostingDate AS PostingDate,
  JournalEntryItem.NetDueDate AS NetDueDate,
  JournalEntryItem.AccountingDocumentItem AS AccountingDocumentItem,
  JournalEntryItem.FinancialTransactionType AS FinancialTransactionType,
  JournalEntryItem.IsReversal AS IsReversal,
  JournalEntryItem.IsReversed AS IsReversed,
  JournalEntryItem.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  JournalEntryItem.ReversalReferenceDocument AS ReversalReferenceDocument,
  JournalEntryItem.ControllingArea AS ControllingArea,
  JournalEntryItem.CostCenter AS CostCenter,
  JournalEntryItem.ProfitCenter AS ProfitCenter,
  JournalEntryItem.FunctionalArea AS FunctionalArea,
  JournalEntryItem.BusinessArea AS BusinessArea,
  JournalEntryItem.Segment AS Segment,
  cast( substring ( JournalEntryItem.DocumentItemText, 1, 30) as farp_sgtxt ) AS DocumentItemText,
  JournalEntryItem.SpecialGLCode AS SpecialGLCode,
  JournalEntryItem.TaxCode AS TaxCode,
  JournalEntryItem.ClearingDate AS ClearingDate,
  cast( '' as fis_augbl ) AS ClearingAccountingDocument,
  cast( '0000' as fis_auggj ) AS ClearingDocFiscalYear,
  JournalEntryItem.Supplier AS Supplier,
  JournalEntryItem.Customer AS Customer,
  JournalEntryItem.DebitCreditCode AS DebitCreditCode,
  JournalEntryItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast( $parameters.P_ReportingCurrency as glo_reporting_currency preserving type ) AS ReportingCurrency,
  JournalEntryItem._CompanyCode AS _CompanyCode,
  JournalEntryItem._FiscalYear AS _FiscalYear,
  JournalEntryItem._JournalEntry AS _JournalEntry,
  JournalEntryItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  JournalEntryItem._AlternativeGLAccount AS _AlternativeGLAccount,
  JournalEntryItem._GLAccountType AS _GLAccountType,
  JournalEntryItem._SpecialGLCode AS _SpecialGLCode,
  JournalEntryItem._CountryChartOfAccounts AS _CountryChartOfAccounts,
  JournalEntryItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  JournalEntryItem._Customer AS _Customer,
  JournalEntryItem._Supplier AS _Supplier,
  JournalEntryItem._Segment AS _Segment,
  JournalEntryItem._ControllingArea AS _ControllingArea,
  JournalEntryItem._BusinessArea AS _BusinessArea,
  JournalEntryItem._FunctionalArea AS _FunctionalArea,
  JournalEntryItem._ChartOfAccounts AS _ChartOfAccounts,
  JournalEntryItem._ProfitCenter AS _ProfitCenter,
  JournalEntryItem._CostCenter AS _CostCenter,
  JournalEntryItem._AccountingDocumentType AS _AccountingDocumentType,
  JournalEntryItem._FinancialAccountType AS _FinancialAccountType,
  JournalEntryItem._DebitCreditCode AS _DebitCreditCode,
  JournalEntryItem._AccountingDocumentCategory AS _AccountingDocumentCategory,
  JournalEntryItem._FinancialTransactionType AS _FinancialTransactionType
FROM I_GLAccountLineItemRawData AS JournalEntryItem
INNER JOIN I_StRpJournalEntryHeaderLog AS JournalEntryLog ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _ReportingCurrency ON _ReportingCurrency.Currency = ReportingCurrency  -- association [0..1]
;