C_LU_SAFTGenLedgerLine

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_LU_SAFTGenLedgerLine.
-- 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: CLUSAFTGENLDGRL

CREATE VIEW C_LU_SAFTGenLedgerLine AS
SELECT
  JournalEntryItem.CompanyCode AS CompanyCode,
  JournalEntryItem.FiscalYear AS FiscalYear,
  JournalEntryItem.AccountingDocument AS AccountingDocument,
  JournalEntryItem.LedgerGLLineItem AS LedgerGLLineItem,
  JournalEntryItem.Ledger AS Ledger,
  JournalEntryItem.AccountingDocumentItem AS AccountingDocumentItem,
  JournalEntryItem.ChartOfAccounts AS ChartOfAccounts,
  JournalEntryItem.PostingDate AS PostingDate,
  JournalEntryItem.FinancialAccountType AS FinancialAccountType,
  cast(case when AlternateAccount.IsAltAcct is not initial then concat(JournalEntryItem.CompanyCode, concat('_', JournalEntryItem.AlternativeGLAccount)) else concat(JournalEntryItem.CompanyCode, concat('_', JournalEntryItem.GLAccount)) end as abap.char(70)) as SAFTGeneralLedgerAccountID AS char70asSAFTGeneralLedgerAccountID,
  JournalEntryItem.GLAccount AS GLAccount,
  JournalEntryItem.DocumentItemText AS DocumentItemText,
  JournalEntryItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  case when JournalEntryItem.TransactionTypeDetermination = ' ' and JournalEntryItem.FinancialAccountType = 'S' then JournalEntryItem.TaxCode else ' ' end as TaxCode AS TaxCodeelseendasTaxCode,
  cast( abs(round( JournalEntryItem.Quantity, 0)) as abap.int8 ) AS Quantity,
  JournalEntryItem.ExchangeRate AS ExchangeRate,
  ' ' AS CAIsDownPaymentRequest,
  JournalEntryItem.IsReversal AS IsReversal,
  JournalEntryItem.AccountingDocumentItemType AS AccountingDocumentItemType,
  JournalEntryItem.AccountingDocumentType AS AccountingDocumentType,
  JournalEntryItem.AlternativeGLAccount AS AlternativeGLAccount
FROM I_LU_SAFTJournalEntry AS JournalEntryItem
INNER JOIN P_LU_SAFTIsAlternateAccount AS AlternateAccount ON /* join condition not captured in parsed metadata */
;