C_NO_SAFTJournalItemAnalysis

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_SAFTJournalItemAnalysis.
-- 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 : budat, P_ToPostingDate : budat, P_Ledger : fins_ledger

CREATE VIEW C_NO_SAFTJournalItemAnalysis 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.CostCenter AS CostCenter,
  JournalItem.PostingDate AS PostingDate,
  JournalItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  JournalItem.TransactionCurrency AS TransactionCurrency,
  case when JournalItem.DebitCreditCode = 'S' then JournalItem.AmountInCompanyCodeCurrency else cast( '0.00' as fis_wsl ) end as DebitAmountInCoCodeCrcy AS 00asfis_wslendasDebitAmountInCoCodeCrcy,
  case when JournalItem.DebitCreditCode = 'S' and JournalItem.CompanyCodeCurrency <> JournalItem.TransactionCurrency then JournalItem.AmountInTransactionCurrency else cast( '0.00' as fis_wsl ) end as DebitAmountInTransCrcy AS 00asfis_wslendasDebitAmountInTransCrcy,
  case when JournalItem.DebitCreditCode = 'H' and JournalItem.AmountInCompanyCodeCurrency < 0 then abs(JournalItem.AmountInCompanyCodeCurrency) when JournalItem.DebitCreditCode = 'H' and JournalItem.AmountInCompanyCodeCurrency > 0 then JournalItem.AmountInCompanyCodeCurrency * -1 else cast( '0.00' as fis_wsl ) end as CreditAmountInCoCodeCrcy AS 00asfis_wslendasCreditAmountInCoCodeCrcy,
  case when JournalItem.DebitCreditCode = 'H' and JournalItem.CompanyCodeCurrency <> JournalItem.TransactionCurrency and JournalItem.AmountInTransactionCurrency < 0 then abs(JournalItem.AmountInTransactionCurrency) when JournalItem.DebitCreditCode = 'H' and JournalItem.CompanyCodeCurrency <> JournalItem.TransactionCurrency and JournalItem.AmountInTransactionCurrency > 0 then JournalItem.AmountInTransactionCurrency * -1 else cast( '0.00' as fis_wsl ) end as CreditAmountInTransCrcy AS 00asfis_wslendasCreditAmountInTransCrcy,
  '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,
  JournalItem._Ledger AS _Ledger
;