P_Arbanktransactiondoc_02

Fetch the Header Detals from FEBKO | view: PARBKTRANSDOC02 | TRAN | Extraction: Not supported | Component: Information System
Tables used: FEBKOFEBKO_REVERSED
Column Name Description
StatementShortID Short Key for Bank Statement (Surrogate Key)
Column Name Description
OpeningBalanceAmtInTransCrcy Opening Balance Amount
ClosingBalanceAmtInTransCrcy Ending Balance Amount
💲 Currency Key (Currency):
TotalDebitAmountInTransCrcy Total Debit
TotalCreditAmountInTransCrcy Total Credit
Column Name Description
Column Name Description
StatementDate Statement Date
BankStatementTime Further Processing Time
BankStatementImportDate Import Date into Bank Data Buffer
BankStatementImportTime Import Time into Bank Data Buffer
StatementImportDate Import Date into Bank Data Buffer
StatementImportTime 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
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
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
BankAccountHolderName Bank Account Holder CHAR35
BankAccountAdditionalName Special Account Name CHAR35
StatementPageNumber Page Number of Statement (5 Digits) NUM5
OpeningBalanceIsInterim Beginning Balance Type (F=Begin Balance, M=Interim Balance) CHAR1
ClosingBalanceIsInterim Ending Balance Type (F=Ending Balance, M=Interim Balance) CHAR1
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
IsManuallyCreated Input Type CHAR1
BankStatementInputFormat Input Format INPUT_FORMAT
StatementInputFormat Input Format INPUT_FORMAT
CreatedByUser User Who Fills the Bank Data Buffer CHAR12
BankAccountReferenceText Reference Details for Bank Details CHAR20
AccountReferenceText Reference Details for Bank Details CHAR20
IBAN Sender Bank Account: IBAN IBAN
IsReversed null
CashPositionIsUpdated Cash Position Update Status CASHUPDOK
Master Data Relations Join Conditions
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_ARBANKTRANSACTIONDOC_02.CHARTOFACCOUNTS == T004.KTOPL
  • P_ARBANKTRANSACTIONDOC_02.MANDT == T004.MANDT
Company code
  • Client
  • Company Code
  • P_ARBANKTRANSACTIONDOC_02.MANDT == T001.MANDT
  • P_ARBANKTRANSACTIONDOC_02.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • P_ARBANKTRANSACTIONDOC_02.MANDT == TCURC.MANDT
  • P_ARBANKTRANSACTIONDOC_02.CURRENCY == TCURC.WAERS
General ledger account
  • Client
  • Company Code
  • General Ledger Account
  • P_ARBANKTRANSACTIONDOC_02.MANDT == SKB1.MANDT
  • P_ARBANKTRANSACTIONDOC_02.COMPANYCODE == SKB1.BUKRS
  • P_ARBANKTRANSACTIONDOC_02.GLACCOUNT == SKB1.SAKNR