I_SAFTJournalItem

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 I_SAFTJournalItem.
-- 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: IPTJRNLENTRYI

CREATE VIEW I_SAFTJournalItem AS
SELECT
  a.SourceLedger AS SourceLedger,
  a.CompanyCode AS CompanyCode,
  a.FiscalYear AS FiscalYear,
  a.AccountingDocument AS AccountingDocument,
  a.LedgerGLLineItem AS LedgerGLLineItem,
  a.Ledger AS Ledger,
  b.ChartOfAccounts AS ChartOfAccounts,
  b.GLAccount AS GLAccount,
  b.AccountingDocumentCategory AS AccountingDocumentCategory,
  b.PostingDate AS PostingDate,
  b._JournalEntry.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  b._JournalEntry.CreationTime AS CreationTime,
  b.DocumentItemText AS DocumentItemText,
  b.DebitCreditCode AS DebitCreditCode,
  b.CompanyCodeCurrency AS CompanyCodeCurrency,
  b.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  b.ReferenceDocumentType AS ReferenceDocumentType,
  a.ReferenceDocument AS ReferenceDocument,
  b.AccountingDocumentItem AS AccountingDocumentItem,
  a.Customer AS Customer,
  a.Supplier AS Supplier,
  b.ControllingArea AS ControllingArea,
  b.CostCenter AS CostCenter,
  b.OrderID AS OrderID,
  b.PersonnelNumber AS PersonnelNumber,
  b.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  a.WBSElement AS WBSElement,
  b.TaxCode AS TaxCode,
  b.TransactionCurrency AS TransactionCurrency,
  b.TransactionTypeDetermination AS TransactionTypeDetermination,
  b.FinancialAccountType AS FinancialAccountType,
  b.InvoiceReference AS InvoiceReference,
  b.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  b.InvoiceItemReference AS InvoiceItemReference,
  b.SalesDocument AS SalesDocument,
  b.SalesDocumentItem AS SalesDocumentItem,
  a.ReversalReferenceDocument AS ReversalReferenceDocument,
  a.IsReversal AS IsReversal,
  b._CompanyCode.Country AS Country,
  b.BillingDocument AS BillingDocument,
  b.AccountingDocumentItemType AS AccountingDocumentItemType,
  b.PaymentReference AS PaymentReference,
  b.ValueDate AS ValueDate,
  b._CompanyCode._Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  b.CashDiscount1Days AS CashDiscount1Days,
  b.CashDiscount2Days AS CashDiscount2Days,
  b.NetPaymentDays AS NetPaymentDays,
  b.DueCalculationBaseDate AS DueCalculationBaseDate,
  coalesce(b._JournalEntry.DocumentReferenceID, ' ') AS DocumentReferenceID,
  a._SourceLedger AS _SourceLedger,
  a._CompanyCode AS _CompanyCode,
  a._FiscalYear AS _FiscalYear,
  a._JournalEntry AS _JournalEntry,
  a._Ledger AS _Ledger,
  b._DebitCreditCode AS _DebitCreditCode,
  b._CompanyCodeCurrency AS _CompanyCodeCurrency,
  b._AccountingDocumentCategory AS _AccountingDocumentCategory,
  b._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  b._ChartOfAccounts AS _ChartOfAccounts,
  b._ReferenceDocumentType AS _ReferenceDocumentType,
  a._Customer AS SourceLedgerasSourceLedger,
  a._Customer AS _Customer
FROM I_JournalEntryItem AS a
INNER JOIN I_OperationalAcctgDocItem AS b ON /* join condition not captured in parsed metadata */
INNER JOIN P_SAFTGLItems AS c ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OperationalAcctgDocItem AS b ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_SAFTCompensationDocument
;