I_SAFTJournalLineItem

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_SAFTJournalLineItem.
-- 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: ISAFTJOURNALITM

CREATE VIEW I_SAFTJournalLineItem AS
SELECT
  JournalEntryItem.SourceLedger AS SourceLedger,
  JournalEntryItem.CompanyCode AS CompanyCode,
  JournalEntryItem.FiscalYear AS FiscalYear,
  JournalEntryItem.AccountingDocument AS AccountingDocument,
  JournalEntryItem.LedgerGLLineItem AS LedgerGLLineItem,
  JournalEntryItem.Ledger AS Ledger,
  JournalEntryItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  JournalEntryItem.GLAccount AS GLAccount,
  JournalEntryItem.AlternativeGLAccount AS AlternativeGLAccount,
  JournalEntryItem.ChartOfAccounts AS ChartOfAccounts,
  JournalEntryItem.CountryChartOfAccounts AS CountryChartOfAccounts,
  JournalEntryItem.ReferenceDocument AS ReferenceDocument,
  JournalEntryItem.PostingDate AS PostingDate,
  JournalEntryItem.DocumentItemText AS DocumentItemText,
  JournalEntryItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  JournalEntryItem.DebitCreditCode AS DebitCreditCode,
  JournalEntryItem.Customer AS Customer,
  JournalEntryItem.Supplier AS Supplier,
  JournalEntryItem.TaxCode AS TaxCode,
  JournalEntryItem.ReferenceDocumentType AS ReferenceDocumentType,
  JournalEntryItem.ReversalReferenceDocument AS ReversalReferenceDocument,
  JournalEntryItem.IsReversed AS IsReversed,
  JournalEntryItem.CostCenter AS CostCenter,
  JournalEntryItem.ControllingArea AS ControllingArea,
  JournalEntryItem.Quantity AS Quantity,
  JournalEntryItem.LogicalSystem AS LogicalSystem,
  JournalEntryItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  JournalEntryItem.FinancialAccountType AS FinancialAccountType,
  JournalEntryItem._CompanyCode.Country AS Country,
  JournalEntryItem._CompanyCode._Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  JournalEntryItem.OrderID AS OrderID,
  JournalEntryItem.PersonnelNumber AS PersonnelNumber,
  JournalEntryItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  JournalEntryItem.WBSElement AS WBSElement,
  JournalEntryItem.TransactionCurrency AS TransactionCurrency,
  JournalEntryItem.ValueDate AS ValueDate,
  JournalEntryItem.AccountingDocumentItem AS AccountingDocumentItem,
  JournalEntryItem.IsReversal AS IsReversal,
  JournalEntryItem.SalesDocument AS SalesDocument,
  JournalEntryItem.SalesDocumentItem AS SalesDocumentItem,
  JournalEntryItem.InvoiceReference AS InvoiceReference,
  JournalEntryItem.InvoiceItemReference AS InvoiceItemReference,
  JournalEntryItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  JournalEntryItem._JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  coalesce(AcctgDocItem.PaymentReference, ' ') AS PaymentReference,
  coalesce(AcctgDocItem.BillingDocument, ' ') AS BillingDocument,
  AcctgDocItem.DueCalculationBaseDate AS DueCalculationBaseDate,
  AcctgDocItem.CashDiscount2Days AS CashDiscount2Days,
  AcctgDocItem.CashDiscount1Days AS CashDiscount1Days,
  AcctgDocItem.NetPaymentDays AS NetPaymentDays,
  AcctgDocItem.AccountingDocumentItemType AS AccountingDocumentItemType,
  CFinBillingDocument.CentralFinanceBillingDocument AS CentralFinanceBillingDocument,
  CFinBillingDocument._Item.CentralFinanceSalesDocument AS CentralFinanceSalesDocument,
  CFinBillingDocument._Item.ReferenceSDDocument AS ReferenceSDDocument,
  CFinBillingDocument.SDDocumentCategory AS SDDocumentCategory,
  GLAccount.ReconciliationAccountType AS ReconciliationAccountType,
  JournalEntryItem.SpecialGLCode AS SpecialGLCode,
  cast( JournalEntryItem._JournalEntry.ExchangeRate as cade_kursf ) AS ExchangeRate,
  JournalEntryItem.ReferenceDocumentContext AS ReferenceDocumentContext,
  JournalEntryItem._CompanyCode AS _CompanyCode
FROM I_JournalEntryItem AS JournalEntryItem
INNER JOIN I_CFinBillingDocument AS CFinBillingDocument ON /* join condition not captured in parsed metadata */
INNER JOIN I_GLAccountInCompanyCode AS GLAccount ON /* join condition not captured in parsed metadata */
INNER JOIN I_CompanyCode AS CompanyCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TaxItem AS _TaxItem ON _TaxItem.AccountingDocument = JournalEntryItem.AccountingDocument AND _TaxItem.CompanyCode = JournalEntryItem.CompanyCode AND _TaxItem.FiscalYear = JournalEntryItem.FiscalYear AND _TaxItem.TaxCode = JournalEntryItem.TaxCode  -- association [0..*]
LEFT OUTER JOIN I_CFinPurchasingDocHistory AS _CFinPurchasingDocHistory ON JournalEntryItem.ReferenceDocument = _CFinPurchasingDocHistory.CFinMaterialDocument AND ( JournalEntryItem.ReferenceDocumentType = 'RMRP' OR JournalEntryItem.ReferenceDocumentType = 'CF3PM' ) AND JournalEntryItem.LogicalSystem = _CFinPurchasingDocHistory.SenderLogicalSystem  -- association [0..*]
LEFT OUTER JOIN I_CustomerToBusinessPartner AS _CustomerToBP ON _CustomerToBP.Customer = JournalEntryItem.Customer  -- association [0..*]
LEFT OUTER JOIN I_SupplierToBusinessPartner AS _SupplierToBP ON _SupplierToBP.Supplier = JournalEntryItem.Supplier  -- association [0..*]
-- UNION with additional select branch(es): I_JournalEntryItem
;