C_ARBankStatementItmUpload

Consumption CDS for Excel Upload Template Generation MBS | view: CBANKSTMNTITUP | Extraction: Not supported | Component: Fiori UI for Accounts Receivable
Column Name Description
Column Name Description
💲 Account Currency Key (TransactionCurrency):
AmountInTransactionCurrency Amount in Account Currency
💲 Payment Currency Key (OriginalCurrency):
AmountInOriginalCurrency Payment Amount
Column Name Description
Column Name Description
ValueDate Value Date
Column Name Description
Column Name Description Domain name
PaymentManualTransacType Manual Transaction VGMAN_EB
PaymentExternalTransacType External Transaction VGEXT_EB
MemoLine Memo Line FAR_MEMO_LINE
Cheque Cheque Number CHCKN
PaymentMediumReference Payment Medium Reference CHCKN
CustomerReferenceNumber Customer Reference Number CHCKN
BankReference Item Reference CHAR35
BusinessPartnerName Business Partner CHAR55
PartnerBank Partner Bank Account: Bank Number BANKK
PartnerBankIBAN Partner Bank Account: IBAN IBAN
PartnerBankSWIFTCode SWIFT Code of Partner Bank SWIFT
PartnerBankAccount Partner Bank Account: Account Number BANKN
Customer Customer Number KUNNR
Supplier Account Number of Supplier LIFNR
GLAccount General Ledger Account SAKNR
DocumentItemText Item Text TEXT50
AssignmentReference Assignment Reference ZUONR
Master Data Relations Join Conditions
Foreign currency (not account currency)
  • Payment Currency Key
  • Client
  • C_ARBANKSTATEMENTITMUPLOAD.ORIGINALCURRENCY == TCURC.WAERS
  • C_ARBANKSTATEMENTITMUPLOAD.MANDT == TCURC.MANDT
Partner Bank
  • Client
  • Partner Bank Account: Bank Country/Region Key
  • C_ARBANKSTATEMENTITMUPLOAD.MANDT == T005.MANDT
  • C_ARBANKSTATEMENTITMUPLOAD.PARTNERBANKCOUNTRY == T005.LAND1