C_NO_SAFTJournalItemAnalytics

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_NO_SAFTJournalItemAnalytics.
-- 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: CNOSAFTJRITMANA
-- Parameters: P_FromPostingDate : abap.dats, P_ToPostingDate : abap.dats, P_Ledger : fins_ledger

CREATE VIEW C_NO_SAFTJournalItemAnalytics AS
SELECT
  JournalItem.CompanyCode AS CompanyCode,
  JournalItem.FiscalYear AS FiscalYear,
  JournalItem.AccountingDocument AS AccountingDocument,
  JournalItem.LedgerGLLineItem AS LedgerGLLineItem,
  JournalItem.Ledger AS Ledger,
  JournalItem.CostCenter AS CostAnalysisResourceName,
  JournalItem.PostingDate AS PostingDate,
  JournalItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  JournalItem.TransactionCurrency AS TransactionCurrency,
  case when JournalItem.CompanyCodeCurrency <> JournalItem.TransactionCurrency and JournalItem.AmountInTransactionCurrency <> 0 then JournalItem.TransactionCurrency else '' end as Currency AS TransactionCurrencyelseendasCurrency,
  abs(JournalItem.AmountInCompanyCodeCurrency) AS AmountInCompanyCodeCurrency,
  JournalItem.CostCenter AS CostCenter,
  'A' AS AnalysisStage,
  'Avdeling ' AS AnalysisStageName,
  CostCenter.ValidityEndDate AS ValidityEndDate,
  CostCenter.ValidityStartDate AS ValidityStartDate,
  cast(coalesce(CostCenter._Text[1: Language = 'O'].CostCenterDescription, coalesce(CostCenter._Text[1: Language = 'E'].CostCenterDescription, CostCenter._Text[1: Language = $session.system_language].CostCenterDescription)) as abap.char(80)) as ResultAnalysisDescription AS char80asResultAnalysisDescription,
  JournalItem._CompanyCode AS _CompanyCode,
  JournalItem._FiscalYear AS _FiscalYear,
  JournalItem._JournalEntry AS _JournalEntry,
  case when JournalItem.CompanyCodeCurrency <> JournalItem.TransactionCurrency then abs(JournalItem.AmountInTransactionCurrency) else cast(0 as abap.dec(18,2)) end as AmountInTransactionCurrency AS dec182endasAmountInTransactionCurrency,
  cast(JournalItem._AccountingDocumentTypeText[1: Language = $session.system_language].AccountingDocumentTypeName as abap.char(80)) AS ResultAnalysisDescription,
  JournalItem._Ledger AS _Ledger
;