I_IL_PAYMENTITEM
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA