I_Arbankstatement

Interface view for Bank Statement Header details | view: IBANKSTMT | Extraction: Not supported | Component: Information System
Column Name Description
BankStatementShortID Short Key for Bank Statement (Surrogate Key)
Column Name Description
💲 Currency Key (Currency):
OpeningBalanceAmtInTransCrcy Opening Balance Amount
InterimOpenBalAmtInTransCrcy Interim Opening Balance Amount
InterimClsgBalAmtInTransCrcy Interim Closing Balance Amount
TotalDebitAmountInTransCrcy Total Debit
TotalCreditAmountInTransCrcy Total Credit
ClosingBalanceAmtInTransCrcy Closing Balance Amount
Column Name Description
Column Name Description
BankStatementDate Statement Date
BankStatementTime Bank Statement Time
BankStatementImportDate Bank Statement Import Date into System
BankStatementImportTime Bank Statement Import Time into System
Column Name Description
BankDataStorageApplication Application Using Bank Data Storage Show values
BankStatementStatus Bank Statement Status Code Show values
BankLedgerIsPosted Indicator that posting Area 1 was posted or not Show values
SubledgerIsPostedSuccessfully Indicator that posting Area 2 was posted or not Show values
CashManagementAdviceIsCreated X - Cash Management Payment Advice Notes Were Created Show values
CashMgmtAdviceIsSummarized Summarize Bank Statement Items Show values
BkStmntIsCashUpdateRelevant Cash Position Update Indicator Show values
BankStatementPostingType Bank Statement Posting Category Show values
Column Name Description Domain name
SendingBank Sending Bank (Electronic Bank Statement) CHAR50
BankStatementInternalID Bank Statement Identification CHAR20
BankStatementRecipientRefID Payee Keys CHAR20
HouseBank House Bank Key HBKID
HouseBankAccount ID for Account Details HKTID
BankStatement Statement Number NUM5
BankStatementStatusName Bank Statement Status Description DDTEXT
BankStatementIsInterpreted All Items on Header Record Were Interpreted CHAR1
BankAccountUUID GUID SYSUUID_C
BankAccount Bank Account Number BANKN
BankAccountHolderName Bank Account Holder CHAR35
BankAccountAdditionalName Special Account Name CHAR35
BankStatementPageNumber Bank Statement Page Number FARP_AZPGNO
OpeningBalanceIsInterim null
ClosingBalanceIsInterim null
InterestRateInPercent Credit Interest Rate HZINS_EB
BankAccountType Bank Account Type CHAR23
BankStatementNumberOfItems Number of Memo Records from the Bank Statement NUM5
NumberOfItems Number of Bank Statement Items FARP_NO_OF_ITEMS
PaymentTransactionTypeGroup Payment Transaction Type Group VGTYP_EB
BankStatementIsManuallyCreated null
CreatedByUser User who uploaded the file into the System CHAR12
BankAccountReferenceText Reference Specifications for Bank Details CHAR20
BankStatementFormat Bank Statement Format INPUT_FORMAT
IBAN Bank Account IBAN IBAN
BankInternalID Bank Keys BANKK
BankName Name of House Bank TEXT60
IsLatestBankStatement null
CashPositionIsUpdated Cash Position Update Status CASHUPDOK
Master Data Relations Join Conditions
Bank Account Technical ID
  • ?
  • Client
  • Bank Account Technical ID
  • I_ARBANKSTATEMENT.[column in domain "FCLM_REVISION"] == FCLM_BAM_AMD.REVISION
  • I_ARBANKSTATEMENT.MANDT == FCLM_BAM_AMD.MANDT
  • I_ARBANKSTATEMENT.BANKACCOUNTINTERNALID == FCLM_BAM_AMD.ACC_ID
Country/Region Key of Bank
  • Client
  • Country/Region Key of Bank
  • I_ARBANKSTATEMENT.MANDT == T005.MANDT
  • I_ARBANKSTATEMENT.BANKCOUNTRY == T005.LAND1
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_ARBANKSTATEMENT.MANDT == T004.MANDT
  • I_ARBANKSTATEMENT.CHARTOFACCOUNTS == T004.KTOPL
Company code
  • Client
  • Company Code
  • I_ARBANKSTATEMENT.MANDT == T001.MANDT
  • I_ARBANKSTATEMENT.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • I_ARBANKSTATEMENT.MANDT == TCURC.MANDT
  • I_ARBANKSTATEMENT.CURRENCY == TCURC.WAERS
General ledger account
  • Client
  • Company Code
  • General Ledger Account
  • I_ARBANKSTATEMENT.MANDT == SKB1.MANDT
  • I_ARBANKSTATEMENT.COMPANYCODE == SKB1.BUKRS
  • I_ARBANKSTATEMENT.GLACCOUNT == SKB1.SAKNR