C_NL_SAFTJournalItemCube

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_NL_SAFTJournalItemCube.
-- 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: CNLSAFTJITEMC

CREATE VIEW C_NL_SAFTJournalItemCube AS
SELECT
  JournalLineItem.CompanyCode AS CompanyCode,
  JournalLineItem.FiscalYear AS FiscalYear,
  JournalLineItem.AccountingDocument AS AccountingDocument,
  JournalLineItem.LedgerGLLineItem AS LedgerGLLineItem,
  JournalLineItem.Ledger AS Ledger,
  JournalLineItem.SourceLedger AS SourceLedger,
  JournalLineItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  case when CompanyCodeSettings.IsAltAcct is initial then JournalLineItem.GLAccount else JournalLineItem.AlternativeGLAccount end as GLAccount AS AlternativeGLAccountendasGLAccount,
  JournalLineItem.ReferenceDocument AS ReferenceDocument,
  JournalLineItem.PostingDate AS PostingDate,
  JournalLineItem.DocumentItemText AS DocumentItemText,
  case when JournalLineItem.DebitCreditCode = 'S' then JournalLineItem.AmountInCompanyCodeCurrency when JournalLineItem.DebitCreditCode = 'H' and JournalLineItem.AmountInCompanyCodeCurrency < 0 then abs(JournalLineItem.AmountInCompanyCodeCurrency) when JournalLineItem.DebitCreditCode = 'H' and JournalLineItem.AmountInCompanyCodeCurrency > 0 then JournalLineItem.AmountInCompanyCodeCurrency * -1 else cast(0 as abap.curr( 23,2 )) end as AmountInCompanyCodeCurrency AS curr232endasAmountInCompanyCodeCurrency,
  cast( abs(round( JournalLineItem.Quantity, 0)) as abap.int8 ) AS Quantity,
  JournalLineItem.CostCenter AS CostCenter,
  JournalLineItem.ControllingArea AS ControllingArea,
  JournalLineItem.Customer AS Customer,
  JournalLineItem.Supplier AS Supplier,
  JournalLineItem.TaxCode AS TaxCode,
  '' AS DefaultDebitCreditCode,
  cast( 0 as fitaxrate ) AS TaxRate,
  cast( 0 as wmwst_shl ) AS TaxAmount,
  cast( '' as bu_partner ) AS BusinessPartner,
  cast( '' as fis_rebzg ) AS InvoiceReference,
  cast( '' as kdauf ) AS OrderDocument,
  cast( '' as tknum ) AS ShipmentDocument,
  JournalLineItem._CompanyCode AS _CompanyCode,
  JournalLineItem._FiscalYear AS _FiscalYear,
  JournalLineItem._JournalEntry AS _JournalEntry,
  JournalLineItem._Ledger AS _Ledger,
  JournalLineItem._SourceLedger AS _SourceLedger,
  JournalLineItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  JournalLineItem._CostCenter AS _CostCenter,
  JournalLineItem._ControllingArea AS _ControllingArea,
  JournalLineItem._Customer AS _Customer,
  JournalLineItem._Supplier AS _Supplier
INNER JOIN P_NL_SAFTCompanyCodeSettings AS CompanyCodeSettings ON /* join condition not captured in parsed metadata */
;