C_Arbankstatementitem

Column Name Description
BankStatementShortID Bank Statement Short Key
BankStatementItem Line Item Number
Column Name Description
💲 Account Currency Key (TransactionCurrency):
AmountInTransactionCurrency Amount in Account Currency
FeeAmountInTransactionCrcy Fees in Account Currency
OverdueChargeAmtInTransacCrcy Overdue Charges from/to Partners in Account Currency
💲 Payment Currency Key (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
BillOfExchangeFailureDate Bill of Exchange Failure Date
Column Name Description
BankLedgerIsPosted Indicator that posting Area 1 was posted or not Show values
SubledgerIsPostedSuccessfully Indicator that posting Area 2 was posted or not Show values
InterpretationAlgorithm Interpretation Algorithm Show values
PaymentAdviceAccountType Payment Advice Account Type Show values
MemoLineIsChanged Memo Line has been changed manually Show values
IsInProcess Is In Process Indicator Show values
TreasuryContractType Contract Type Show values
BankStatementItemIsInterpreted Have the bank statement items been interpreted? Show values
BankStmntItemProcessingType Processing Type Show values
BankLedgerPostingIsSuppressed Posting is suppressed (Bank Ledger) Show values
SubledgerPostingIsSuppressed Posting is suppressed (Subledger) Show values
IsCompleted Bank Statement Completed Status Show values
Column Name Description Domain name
BankStatementItemGroup Number for Grouping Bankstatement Items CHAR2
PaymentManualTransacType Manual Transaction VGMAN_EB
PaymentManualTransacTypeName Manual Transaction Text TEXT40
BankStatementPostingRuleName Bank Statement Posting Rule Description TXT40
PaymentTransactionCategoryName Allocation Algorithm Description TEXT60
PaymentAdviceAccountTypeName Short Text for Fixed Values DDTEXT
Supplier Account Number of Supplier LIFNR
Customer Customer Number KUNNR
GLAccount General Ledger Account SAKNR
HasAttachment Has Attachment Indicator
MemoLine1 Payment Notes CHAR65
MemoLine Memo Line FAR_MEMO_LINE
OriginalMemoLine Memo Line FAR_MEMO_LINE
FinancialStatementItem Line Item Number FARP_ESNUM
BankInternalID Bank Keys BANKK
BankAccount Bank account number BANKN
ExchangeRate Exchange Rate: Foreign Currency to Account Currency
DebitCreditCode Debit/Credit Key for Line Items (for Bank Purposes) CHAR1
BusinessPartnerName Business Partner CHAR55
PaymentAdvice Payment Advice Number AVSID
ValueDateTime Value Date Time TIME6
PaymentExternalTransacType External Transaction VGEXT_EB
PaymentTransactionDescription Description of the External Trasaction CHAR50
AccountingClerk Accounting Clerk CHAR2
CostCenter Cost Center CHAR10
BusinessArea Business Area CHAR4
ProfitCenter Profit Center PRCTR
TreasuryContract Contract Number RANL
DaybookEntry Daybook Number CHAR10
Cheque Cheque Number CHCKN
PaymentMediumReference Payment Medium Reference CHCKN
CustomerReferenceNumber Customer Reference Number CHCKN
PostingErrorStatus Posting Error Status CHAR4
BankLedgerDocument Document Number (Bank Ledger) BELNR
FiscalYear Fiscal Year GJAHR
BankPostingKey Posting Key of Item CHAR4
AcctDetnFreeDefinedAttribute Account modification KFMOD_EB
DocumentReferenceID Reference Document Number XBLNR1
AssignmentReference Assignment Reference ZUONR
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
BankStatementItemDescription1 Item Description 1 CHAR30
BankStatementItemDescription2 Item Description 2 CHAR30
SubledgerDocument Document Number (Subledger) BELNR
BankLedgerOnAccountDocument On Account Document (Bank Ledger) BELNR
SubledgerOnAccountDocument On Account Document (Subledger) BELNR
PayerParty Account Number of an Alternative Payer KUNNR
BankStatementItmLifeCycStsName Posting Status FARP_BS_ITM_LIFECYC_STAT_NAME
AccountingExchangeRate Accounting Exchange Rate
DocumentItemText Item Text TEXT50
BankReference Item Reference CHAR35
ReferenceDocument External Reference Document AWKEY
ReferenceDocumentType External Reference Document Type AWTYP
PaymentReference Payment Reference CHAR30
ReturnReason Return Reason CHAR35
DunningBlockingReason Dunning Block MANSP
BankLedgerExternalApplication ID of External Application (Bank Ledger) APPLK_BF
BankLedgerExtPostgErrorStatus External Posting Error Status (Bank Ledger) CHAR4
BankLedgerExtPostingDocument External Posting Document Number (Bank Ledger) CHAR70
BankLedgerExtPostingRefDocType External Posting Reference Document Type (Bank Ledger) AWTYP
SubledgerExtPostingApplication ID of External Application (Subledger) APPLK_BF
SubledgerExtPostingErrorStatus External Posting Error Status (Subledger) CHAR4
SubledgerExtPostingDocument External Posting Document Number(Subledger) CHAR70
SubledgerExtPostingRefDocType External Posting Reference Document Type (Subledger) AWTYP
ApplicationLog Constant - application log for UI CHAR3
PaymentTransactionTypeGroup Payment Transaction Type Group VGTYP_EB
Master Data Relations Join Conditions
Bank Account Technical ID
  • ?
  • Bank Account Technical ID
  • Client
  • C_ARBANKSTATEMENTITEM.[column in domain "FCLM_REVISION"] == FCLM_BAM_AMD.REVISION
  • C_ARBANKSTATEMENTITEM.BANKACCOUNTINTERNALID == FCLM_BAM_AMD.ACC_ID
  • C_ARBANKSTATEMENTITEM.MANDT == FCLM_BAM_AMD.MANDT
Input Help for Posting Rule (Internal Activity)
  • Client
  • Bank Statement Posting Rule
  • C_ARBANKSTATEMENTITEM.MANDT == T028D.MANDT
  • C_ARBANKSTATEMENTITEM.BANKSTATEMENTPOSTINGRULE == T028D.VGINT
Company code
  • Company Code
  • Client
  • C_ARBANKSTATEMENTITEM.COMPANYCODE == T001.BUKRS
  • C_ARBANKSTATEMENTITEM.MANDT == T001.MANDT
Foreign currency (not account currency)
  • Payment Currency Key
  • Client
  • C_ARBANKSTATEMENTITEM.ORIGINALCURRENCY == TCURC.WAERS
  • C_ARBANKSTATEMENTITEM.MANDT == TCURC.MANDT
Partner Bank
  • Client
  • Partner Bank Account: Bank Country/Region Key
  • C_ARBANKSTATEMENTITEM.MANDT == T005.MANDT
  • C_ARBANKSTATEMENTITEM.PARTNERBANKCOUNTRY == T005.LAND1