I_IL_PaymentItem

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_IL_PaymentItem.
-- 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.

CREATE VIEW I_IL_PaymentItem AS
SELECT
  cash_pmt_id AS IL_IdentifierCashPaymentItem,
  bukrs AS CompanyCode,
  gjahr AS FiscalYear,
  belnr AS AccountingDocument,
  zlsch AS PaymentMethod,
  _PaymentMethodText.PaymentMethodDescription AS PaymentMethodDescription,
  pmt AS IL_PaymentMethod,
  cash_num AS IL_CashNumberKey,
  _JournalEntry.TransactionCurrency AS TransactionCurrency,
  amount AS IL_PaytItmAmountInDocCrcy,
  status AS IL_PaymentStatus,
  bankl AS BankNumber,
  bankn AS BankAccount,
  cheque_num AS IL_ChequeNumber,
  cc_num AS CreditCardNumber,
  cc_reference_num AS IL_CreditCardReference,
  cc_pmt_trn_type AS IL_CreditCardTransactionType,
  bt_id AS IL_BankTransferReferenceNumber,
  kunnr AS Customer,
  lifnr AS Supplier,
  hkont AS GLAccount,
  cheque_duedate AS IL_ChequeDueDate,
  _JournalEntry._TransactionCurrency AS _TransactionCurrency
FROM gsfincsild_pmts
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON _JournalEntry.CompanyCode = CompanyCode AND _JournalEntry.FiscalYear = FiscalYear AND _JournalEntry.AccountingDocument = AccountingDocument  -- association [0..1]
LEFT OUTER JOIN I_PaymentMethodText AS _PaymentMethodText ON _PaymentMethodText.Country = 'IL' AND _PaymentMethodText.PaymentMethod = PaymentMethod AND _PaymentMethodText.Language = $session.system_language  -- association [0..1]
;