C_Arbankstatement

Manage Bank Statement | view: CARBANKSTMNT | Extraction: Not supported | Component: Fiori UI for Accounts Receivable
Column Name Description
BankStatementShortID Bank Statement Short 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 Bank Statement Date
BankStatementTime Bank Statement Time
BankStatementImportDate Bank Statement Import Date into System
BankStatementImportTime Bank Statement Import Time into System
PostingDate Posting Date in the Document
Column Name Description
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
OpeningBalanceIsInterim Indicator that the Opening Balance is interim Show values
ClosingBalanceIsInterim Indicator that the Closing Balance is interim Show values
BankDataStorageApplication Bank Statement Type Show values
BankStatementIsManuallyCreated Has the bank statement being manually created? Show values
IsLatestBankStatement Latest Bank Statement UI Filter Show values
PostActionIsEnabled Indicator - Is action enable Show values
CreateNextActionIsEnabled Indicator - Is action enable Show values
ReverseActionIsEnabled Indicator - Is action enable Show values
ReversalLogActionIsEnabled Indicator - Is action enable Show values
CashPositionUpdateStatus Cash Position update status Show values
BankStatementPostingType Bank Statement Posting Category Show values
Column Name Description Domain name
SendingBank Sending Bank (Electronic Bank Statement) CHAR50
BankStatementInternalID Bank Statement ID CHAR20
BankStatementRecipientRefID Payee Keys CHAR20
HouseBank House Bank Key HBKID
HouseBankAccount House Bank Account ID
BankStatement Bank Statement Number FARP_AZNUM
BankAccountUUID GUID SYSUUID_C
BankStatementIsInterpreted All bank statement items have been interpreted. CHAR1
BankAccountHolderName Bank Account Holder
BankAccountAdditionalName Additional House Bank Account Name CHAR35
BankStatementPageNumber Bank Statement Page Number FARP_AZPGNO
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
CreatedByUser User who uploaded the file into the System CHAR12
PersonFullName Name of User who uploaded the file into the System TEXT80
IncomingPaymentFile Incoming Payment File ID FARP_EFILEID
BankAccountReferenceText Reference Specifications for Bank Details CHAR20
BankStatementFormat Bank Statement Format INPUT_FORMAT
IBAN Bank Account IBAN IBAN
BankName Name of House Bank TEXT60
BankAccount Bank Account Number BANKN
BankStatementReversalJob Job ID TEXT8
BankStatementReversalJobName Background Job Name CHAR32
BankInternalID Bank Keys BANKK
Master Data Relations Join Conditions
Bank Account Technical ID
  • ?
  • Bank Account Technical ID
  • Client
  • C_ARBANKSTATEMENT.[column in domain "FCLM_REVISION"] == FCLM_BAM_AMD.REVISION
  • C_ARBANKSTATEMENT.BANKACCOUNTINTERNALID == FCLM_BAM_AMD.ACC_ID
  • C_ARBANKSTATEMENT.MANDT == FCLM_BAM_AMD.MANDT
Country/Region Key of Bank
  • Country/Region Key of Bank
  • Client
  • C_ARBANKSTATEMENT.BANKCOUNTRY == T005.LAND1
  • C_ARBANKSTATEMENT.MANDT == T005.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_ARBANKSTATEMENT.CHARTOFACCOUNTS == T004.KTOPL
  • C_ARBANKSTATEMENT.MANDT == T004.MANDT
Company code
  • Company Code
  • Client
  • C_ARBANKSTATEMENT.COMPANYCODE == T001.BUKRS
  • C_ARBANKSTATEMENT.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • C_ARBANKSTATEMENT.CURRENCY == TCURC.WAERS
  • C_ARBANKSTATEMENT.MANDT == TCURC.MANDT
General ledger account
  • General Ledger Account
  • Company Code
  • Client
  • C_ARBANKSTATEMENT.GLACCOUNT == SKB1.SAKNR
  • C_ARBANKSTATEMENT.COMPANYCODE == SKB1.BUKRS
  • C_ARBANKSTATEMENT.MANDT == SKB1.MANDT