I_BankStatementItem

Items of a bank statement | view: IBANKSTATMENTITM | Extraction: Not supported | Component: Fiori UI for Accounts Receivable
Tables used: FEBEPFEBKOFEBKO_REVERSED
Column Name Description
BankStatementShortID Short Key for Bank Statement (Surrogate Key)
BankStatementItem Memo Record Number (Line Item Number in Bank Statement)
Column Name Description
💲 Account Currency Key (TransactionCurrency):
AmountInTransactionCurrency Amount in Account Currency
FeeAmountInTransactionCrcy Fees in Account Currency
💲 Foreign Currency Key (Not Account Currency) (OriginalCurrency):
AmountInOriginalCurrency Payment Amount
FeeAmountInOriginalCrcy Fees in Payment Currency
Column Name Description
Column Name Description
ValueDate Value Date
BankPostingDate Posting Date of Bank Statement
PostingDate Posting Date in the Document
Column Name Description
InterpretationAlgorithm Interpretation Algorithm Show values
Column Name Description Domain name
PaymentTransaction External Payment Transaction CHAR3
MemoLine Memo Line FAR_MEMO_LINE
ValueDateTime Value Date Time TIME6
ExchangeRate Exchange Rate: Foreign Currency to Account Currency
Supplier Account Number of Supplier LIFNR
Customer Customer Number KUNNR
GLAccount General Ledger Account SAKNR
BusinessPartnerName Business Partner CHAR55
PaymentManualTransacType Manual Transaction VGMAN_EB
PaymentExternalTransacType External Transaction VGEXT_EB
PaymentAdvice Payment Advice Number AVSID
Cheque Check number CHCKN
PaymentMediumReference Payment Medium Reference CHCKN
CustomerReferenceNumber Customer Reference Number CHCKN
BankLedgerDocument Document Number (Bank Ledger) BELNR
SubledgerDocument Document Number (Subledger) BELNR
BankLedgerOnAccountDocument On Account Document (Bank Ledger) BELNR
SubledgerOnAccountDocument On Account Document (Subledger) BELNR
FiscalYear Fiscal Year GJAHR
PartnerBank Partner Bank Account: Bank Number BANKK
PartnerBankSWIFTCode SWIFT Code of Partner Bank SWIFT
PartnerBankAccount Partner Bank Account: Account Number BANKN
PartnerBankIBAN Partner Bank Account: IBAN IBAN
DocumentItemText Item Text TEXT50
BankReference Item Reference CHAR35
IsCompleted Line Item Completed CHAR1
Master Data Relations Join Conditions
Input Help for Posting Rule (Internal Activity)
  • Bank Statement Posting Rule
  • Client
  • I_BANKSTATEMENTITEM.BANKSTATEMENTPOSTINGRULE == T028D.VGINT
  • I_BANKSTATEMENTITEM.MANDT == T028D.MANDT
Company code
  • Company Code
  • Client
  • I_BANKSTATEMENTITEM.COMPANYCODE == T001.BUKRS
  • I_BANKSTATEMENTITEM.MANDT == T001.MANDT
Foreign currency (not account currency)
  • Foreign Currency Key (Not Account Currency)
  • Client
  • I_BANKSTATEMENTITEM.ORIGINALCURRENCY == TCURC.WAERS
  • I_BANKSTATEMENTITEM.MANDT == TCURC.MANDT
Partner Bank
  • Partner Bank Account: Bank Country/Region Key
  • Client
  • I_BANKSTATEMENTITEM.PARTNERBANKCOUNTRY == T005.LAND1
  • I_BANKSTATEMENTITEM.MANDT == T005.MANDT