I_IL_PAYMENTITEM

CDS View

Payment Item in IL Cash System

I_IL_PAYMENTITEM is a CDS View in S/4HANA. Payment Item in IL Cash System. It contains 16 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_IL_IncomingPaymentCashItem view_entity inner COMPOSITE Payment Cash Item in IL Cashier System
I_IL_IncomingPaymentChequeItem view_entity inner COMPOSITE Payment Cheque Item in IL Cashier System
I_IL_IncomingPmtBankTransItem view_entity inner COMPOSITE Bank Transfer Item in IL Cashier System
I_IL_IncomingPmtCreditCardItem view_entity inner COMPOSITE Credit Card Item in IL Cashier System
P_IL_IncomingPaymentDocument01 view_entity from COMPOSITE

Fields (16)

KeyField CDS FieldsUsed in Views
_PaymentMethodText _PaymentMethodText 1
BankAccount BankAccount 1
BankNumber BankNumber 1
CreditCardNumber CreditCardNumber 1
Customer Customer 4
GLAccount GLAccount 4
IL_BankTransferReferenceNumber IL_BankTransferReferenceNumber 1
IL_CashNumberKey IL_CashNumberKey 4
IL_ChequeDueDate IL_ChequeDueDate 1
IL_ChequeNumber IL_ChequeNumber 1
IL_CreditCardReference IL_CreditCardReference 1
IL_CreditCardTransactionType IL_CreditCardTransactionType 1
IL_PaymentStatus IL_PaymentStatus 4
IL_PaytItmAmountInDocCrcy IL_PaytItmAmountInDocCrcy 4
PaymentMethod PaymentMethod 4
Supplier Supplier 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.

-- Payment Item in IL Cash System
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_IL_PAYMENTITEM (
    _PAYMENTMETHODTEXT,
    BANKACCOUNT,
    BANKNUMBER,
    CREDITCARDNUMBER,
    CUSTOMER,
    GLACCOUNT,
    IL_BANKTRANSFERREFERENCENUMBER,
    IL_CASHNUMBERKEY,
    IL_CHEQUEDUEDATE,
    IL_CHEQUENUMBER,
    IL_CREDITCARDREFERENCE,
    IL_CREDITCARDTRANSACTIONTYPE,
    IL_PAYMENTSTATUS,
    IL_PAYTITMAMOUNTINDOCCRCY,
    PAYMENTMETHOD,
    SUPPLIER
);