I_IL_PAYMENTITEMLOG

CDS View
21 Fields 8 CDS Views

IL Payment Item Log

I_IL_PAYMENTITEMLOG is a CDS View in S/4HANA. IL Payment Item Log. It contains 21 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_IL_CancellableDepositDoc view_entity from COMPOSITE IL Cancellable Deposit Document
I_IL_CashRegisterIntraday view_entity from COMPOSITE Cash Register Balance
I_IL_CashRegisterOpenBalance view_entity from COMPOSITE Cash Register Balance
I_IL_DepositEnabledCash view_entity inner COMPOSITE IL Depositable Cash Item
I_IL_DepositEnabledCheque view_entity inner COMPOSITE IL Depositable Cheque Item
I_IL_ReturnableCash view_entity inner COMPOSITE IL Returnable Cash Amount
P_IL_IntradayCashTransfer01 view_entity from COMPOSITE Cash Register Balance
P_IL_TransferCash01 view_entity inner COMPOSITE Helper for cash payment

Fields (21)

KeyField CDS FieldsUsed in Views
KEY EntryTimestamp EntryTimestamp 2
KEY IL_IdentifierCashPaymentItem IL_IdentifierCashPaymentItem 2
KEY RefAccountingDocument AccountingDocument,RefAccountingDocument 2
KEY ReferenceCompanyCode CompanyCode,ReferenceCompanyCode 2
KEY ReferenceFiscalYear FiscalYear,ReferenceFiscalYear 2
BankAccount BankAccount 2
BankNumber BankNumber 2
Customer Customer 2
IL_CashNumberKey IL_CashNumberKey 2
IL_ChequeDueDate IL_ChequeDueDate 2
IL_ChequeNumber IL_ChequeNumber 2
IL_CreditCardReference IL_CreditCardReference 2
IL_PaymentMethod IL_PaymentMethod 2
IL_PaymentStatus IL_PaymentStatus 2
IL_PaytItmAmountInDocCrcy IL_PaytItmAmountInDocCrcy 1
LastChangeByUser LastChangeByUser 1
LastChangeDate LastChangeDate 2
LastChangeTime LastChangeTime 2
PaymentMethod PaymentMethod 2
Supplier Supplier 2
TransactionCurrency TransactionCurrency 4

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- IL Payment Item Log
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_IL_PAYMENTITEMLOG (
    ENTRYTIMESTAMP,
    IL_IDENTIFIERCASHPAYMENTITEM,
    REFACCOUNTINGDOCUMENT,
    REFERENCECOMPANYCODE,
    REFERENCEFISCALYEAR,
    BANKACCOUNT,
    BANKNUMBER,
    CUSTOMER,
    IL_CASHNUMBERKEY,
    IL_CHEQUEDUEDATE,
    IL_CHEQUENUMBER,
    IL_CREDITCARDREFERENCE,
    IL_PAYMENTMETHOD,
    IL_PAYMENTSTATUS,
    IL_PAYTITMAMOUNTINDOCCRCY,
    LASTCHANGEBYUSER,
    LASTCHANGEDATE,
    LASTCHANGETIME,
    PAYMENTMETHOD,
    SUPPLIER,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (ENTRYTIMESTAMP, IL_IDENTIFIERCASHPAYMENTITEM, REFACCOUNTINGDOCUMENT, REFERENCECOMPANYCODE, REFERENCEFISCALYEAR)
);

Learn More