I_LU_SAFTJournalEntry

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_LU_SAFTJournalEntry.
-- 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: ILUSAFTGLENTRY

CREATE VIEW I_LU_SAFTJournalEntry AS
SELECT
  JournalEntry.CompanyCode AS CompanyCode,
  JournalEntry.FiscalYear AS FiscalYear,
  JournalEntry.AccountingDocument AS AccountingDocument,
  JournalItem.Ledger AS Ledger,
  JournalItem.LedgerGLLineItem AS LedgerGLLineItem,
  JournalItem.AccountingDocumentItem AS AccountingDocumentItem,
  cast(concat(JournalEntry.CompanyCode, concat ('_', JournalEntry.AccountingDocument)) as abap.char(70)) AS DocumentTransaction,
  JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  JournalEntry.DocumentDate AS DocumentDate,
  JournalEntry.PostingDate AS PostingDate,
  JournalEntry.FiscalPeriod AS FiscalPeriod,
  JournalEntry.AccountingDocumentCategory AS AccountingDocumentCategory,
  JournalEntry.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  JournalEntry.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  cast(abs(JournalEntry.ExchangeRate) as fis_absolute_exchangerate preserving type) AS ExchangeRate,
  JournalItem.Customer AS Customer,
  JournalItem.Supplier AS Supplier,
  JournalItem.FinancialAccountType AS FinancialAccountType,
  JournalItem.ChartOfAccounts AS ChartOfAccounts,
  JournalItem.GLAccount AS GLAccount,
  JournalItem.SpecialGLCode AS SpecialGLCode,
  JournalItem.TaxCode AS TaxCode,
  CompanyCode._Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  JournalItem.DocumentItemText AS DocumentItemText,
  JournalItem.DebitCreditCode AS DebitCreditCode,
  JournalItem.IsReversal AS IsReversal,
  JournalItem.Quantity AS Quantity,
  JournalItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  JournalItem.TransactionCurrency AS TransactionCurrency,
  JournalItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  JournalItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  coalesce(AcctgDoc.AccountingDocumentItemType, 'T') AS AccountingDocumentItemType,
  coalesce(AcctgDoc.VATRegistration, '') AS VATRegistration,
  CompanyCode.Country AS CompanyCodeCountry,
  cast(case when AcctgDoc.VATRegistration is not initial and AcctgDoc.VATRegistration is not null then substring ( AcctgDoc.VATRegistration, 1, 2 ) else '' end as abap.char(3)) as DelivOfGoodsDestCountry AS char3asDelivOfGoodsDestCountry,
  JournalItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  GLAccount.AlternativeGLAccount AS AlternativeGLAccount,
  AcctgDoc.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  JournalItem.LedgerFiscalYear AS LedgerFiscalYear,
  JournalItem.FiscalPeriod AS LedgerFiscalPeriod,
  JournalEntry._CompanyCode AS _CompanyCode,
  JournalEntry._FiscalYear AS _FiscalYear,
  JournalEntry._AccountingDocumentType AS _AccountingDocumentType,
  JournalEntry._FiscalPeriod AS _FiscalPeriod,
  JournalEntry._AccountingDocumentCategory AS _AccountingDocumentCategory,
  JournalEntry._AccountingDocumentTypeText AS _AccountingDocumentTypeText,
  JournalItem._Ledger AS _Ledger,
  JournalItem._ChartOfAccounts AS _ChartOfAccounts,
  JournalItem._DebitCreditCode AS _DebitCreditCode,
  JournalItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  JournalItem._TransactionCurrency AS _TransactionCurrency,
  JournalItem._Supplier AS _Supplier,
  JournalItem._Customer AS _Customer
FROM I_JournalEntry AS JournalEntry
INNER JOIN I_JournalEntryItem AS JournalItem 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_LU_SAFTGenericSettings AS GenSettings ON /* join condition not captured in parsed metadata */
INNER JOIN I_CompanyCode AS CompanyCode ON /* join condition not captured in parsed metadata */
;