I_IL_PaymentItemLog

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_PaymentItemLog.
-- 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_PaymentItemLog AS
SELECT
  PMTLog.cash_pmt_id AS IL_IdentifierCashPaymentItem,
  PMTLog.timestamp AS EntryTimestamp,
  PMTLog.active AS MDChangeProcessIsActiveRecord,
  PMTLog.bukrs AS CompanyCode,
  PMTLog.gjahr AS FiscalYear,
  PMTLog.belnr AS AccountingDocument,
  PMTLog.zlsch AS PaymentMethod,
  PMTLog.pmt AS IL_PaymentMethod,
  PMTLog.cash_num AS IL_CashNumberKey,
  PMTLog.waers AS TransactionCurrency,
  PMTLog.amount AS IL_PaytItmAmountInDocCrcy,
  PMTLog.status AS IL_PaymentStatus,
  PMTLog.bankl AS BankNumber,
  PMTLog.bankn AS BankAccount,
  PMTLog.cheque_num AS IL_ChequeNumber,
  PMTLog.cc_num AS CreditCardNumber,
  PMTLog.cc_reference_num AS IL_CreditCardReference,
  PMTLog.cc_pmt_trn_type AS IL_CreditCardTransactionType,
  PMTLog.bt_id AS IL_BankTransferReferenceNumber,
  PMTLog.kunnr AS Customer,
  PMTLog.lifnr AS Supplier,
  PMTLog.hkont AS GLAccount,
  PMTLog.cheque_duedate AS IL_ChequeDueDate,
  PMTLog.is_cash_residual AS IL_ItemIsCashResidual,
  PMTLog.changed_by AS LastChangeByUser,
  PMTLog.changed_on AS LastChangeDate,
  PMTLog.changed_at AS LastChangeTime,
  PMTLog.ref_pmt_id AS IL_ReferencePaymentItem,
  PMTLog.followup_belnr AS RefAccountingDocument,
  PMTLog.followup_bukrs AS ReferenceCompanyCode,
  PMTLog.followup_gjahr AS ReferenceFiscalYear
FROM gsfincsild_pmt_l AS PMTLog
;