P_Arbanktransactiondoc

AR Bank Transaction Document | view: PARBKTRANSDOC | Extraction: Not supported | Component: Information System
Column Name Description
StatementShortID Short Key for Bank Statement (Surrogate Key)
Column Name Description
OpeningBalanceAmtInTransCrcy Opening Balance Amount
ClosingBalanceAmtInTransCrcy Ending Balance Amount
InterimOpenBalAmtInTransCrcy Interim Opening Balance Amount
InterimClsgBalAmtInTransCrcy Interim Closing Balance Amount
💲 Currency Key (Currency):
TotalDebitAmountInTransCrcy Total Debit
TotalCreditAmountInTransCrcy Total Credit
Column Name Description
Column Name Description
StatementDate Statement Date
BankStatementTime Further Processing Time
StatementImportDate Import Date into Bank Data Buffer
StatementImportTime Import Time into Bank Data Buffer
BankStatementImportDate Import Date into Bank Data Buffer
BankStatementImportTime Import Time into Bank Data Buffer
Column Name Description
BankDataStorageApplication Application Using Bank Data Storage Show values
CashMgmtPaymtAdviceNoteCreated X - Cash Management Payment Advice Notes Were Created Show values
SummarizeBankStatementItems Summarize Bank Statement Items Show values
BkStmntIsCashUpdateRelevant Cash Position Update Indicator Show values
PostingType Bank Statement Posting Category Show values
Column Name Description Domain name
SendingBank Sending Bank (Electronic Bank Statement) CHAR50
InternalID Bank Statement Identification CHAR20
InternalIDLength null
BankStatementRecipientRefID Payee Keys CHAR20
HouseBank Short Key for a House Bank HBKID
HouseBankAccount ID for Account Details HKTID
StatementNumber Statement Number NUM5
StatementStatus Statement Status CHAR1
StatementStatusName Short Text for Fixed Values DDTEXT
BankLedgerIsPosted All Postings in Area 1 Are OK CHAR1
SubledgerIsPostedSuccessfully All Postings in Area 2 Are OK CHAR1
StatementIsInterpreted All Items on Header Record Were Interpreted CHAR1
BankAccount Bank account number BANKN
BankAccountUUID GUID SYSUUID_C
BankAccountHolderName Bank Account Holder CHAR35
BankAccountAdditionalName Special Account Name CHAR35
StatementPageNumber Page Number of Statement (5 Digits) NUM5
OpeningBalanceIsInterim null
ClosingBalanceIsInterim null
IsManuallyCreated null
IsLatestStatement null
InterestRateInPercent Credit Interest HZINS_EB
BankAccountType Bank Account Type CHAR23
NumberOfItems Number of Memo Records from the Bank Statement NUM5
PaymentTransactionTypeGroup Transaction Type VGTYP_EB
CreatedByUser User Who Fills the Bank Data Buffer CHAR12
AccountReferenceText Reference Details for Bank Details CHAR20
StatementInputFormat Input Format INPUT_FORMAT
BankAccountReferenceText Reference Details for Bank Details CHAR20
IBAN Sender Bank Account: IBAN IBAN
CashPositionIsUpdated Cash Position Update Status CASHUPDOK
BankInternalID Bank Keys BANKK
BankName Name of Financial Institution TEXT60
Master Data Relations Join Conditions
Bank Account Technical ID
  • Client
  • ?
  • Bank Account Technical ID
  • P_ARBANKTRANSACTIONDOC.MANDT == FCLM_BAM_AMD.MANDT
  • P_ARBANKTRANSACTIONDOC.[column in domain "FCLM_REVISION"] == FCLM_BAM_AMD.REVISION
  • P_ARBANKTRANSACTIONDOC.BANKACCOUNTINTERNALID == FCLM_BAM_AMD.ACC_ID
Country/Region Key of Bank
  • Country/Region Key of Bank
  • Client
  • P_ARBANKTRANSACTIONDOC.BANKCOUNTRY == T005.LAND1
  • P_ARBANKTRANSACTIONDOC.MANDT == T005.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_ARBANKTRANSACTIONDOC.MANDT == T004.MANDT
  • P_ARBANKTRANSACTIONDOC.CHARTOFACCOUNTS == T004.KTOPL
Company code
  • Company Code
  • Client
  • P_ARBANKTRANSACTIONDOC.COMPANYCODE == T001.BUKRS
  • P_ARBANKTRANSACTIONDOC.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • P_ARBANKTRANSACTIONDOC.MANDT == TCURC.MANDT
  • P_ARBANKTRANSACTIONDOC.CURRENCY == TCURC.WAERS
General ledger account
  • Company Code
  • Client
  • General Ledger Account
  • P_ARBANKTRANSACTIONDOC.COMPANYCODE == SKB1.BUKRS
  • P_ARBANKTRANSACTIONDOC.MANDT == SKB1.MANDT
  • P_ARBANKTRANSACTIONDOC.GLACCOUNT == SKB1.SAKNR