P_ARBSITMBANKSTMT03

Cleared Bank Statement | view: PARBSITMBNKSTMT3 | Extraction: Not supported | Component: Financial Cash Application Intelligence
Tables used: FEBEPFEBKOBKPFBSEGKNA1LFA1
Column Name Description
Column Name Description
💲 Account Currency Key (TransactionCurrency):
AmountInTransactionCurrency Amount in Account Currency
Column Name Description
Column Name Description
PostingDate Posting Date in the Document
ValueDate Value Date of the Item to Be Cleared
Column Name Description
PaymentAdviceAccountType Payment Advice Account Type Show values
Column Name Description Domain name
HouseBank Short Key for a House Bank HBKID
HouseBankAccount ID for Account Details HKTID
BankStatement Statement Number NUM5
BankStatementShortID Short Key for Bank Statement (Surrogate Key) KUKEY_EB
BankStatementItem Memo Record Number (Line Item Number in Bank Statement) NUM5
FiscalYear Fiscal Year GJAHR
DebitCreditCode Debit/Credit Key for Line Items (for Bank Purposes) CHAR1
PartnerBank Bank Number of Partner Bank BANKK
PartnerBankSWIFTCode SWIFT Code of Partner Bank SWIFT
PartnerBankAccount Account Number at the Partner Bank BANKN
PartnerBankIBAN Partner Bank Account: IBAN IBAN
BusinessPartnerName Business Partner CHAR55
BankLedgerDocument Document Number of an Accounting Document BELNR
SubledgerDocument Subledger document number BELNR
DocumentReferenceID Reference Document Number XBLNR1
PaymentAdviceAccount Account Number KTONR
AssignmentReference Assignment number ZUONR
PaymentReference Payment Reference CHAR30
SubledgerOnAccountDocument Payment on account document number BELNR
PaymentAdvice Payment Advice Number AVSID
MemoLine Memo Line FAR_MEMO_LINE
PaymentTransactionDescription Bank Posting Text CHAR50
Cheque Check number CHCKN
BankPostingKey Text Key CHAR4
PaymentTransaction Business Transaction Code CHAR3
PaymentExternalTransacType External Business Transaction VGEXT_EB
Master Data Relations Join Conditions
Input Help for Posting Rule (Internal Activity)
  • Posting Rule
  • Client
  • P_ARBSITMBANKSTMT03.BANKSTATEMENTPOSTINGRULE == T028D.VGINT
  • P_ARBSITMBANKSTMT03.CLIENT == T028D.MANDT
Client P_ARBSITMBANKSTMT03.CLIENT == T000.MANDT
Company code
  • Company Code
  • Client
  • P_ARBSITMBANKSTMT03.COMPANYCODE == T001.BUKRS
  • P_ARBSITMBANKSTMT03.CLIENT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • P_ARBSITMBANKSTMT03.CURRENCY == TCURC.WAERS
  • P_ARBSITMBANKSTMT03.CLIENT == TCURC.MANDT
Partner Bank
  • P_ARBSITMBANKSTMT03.CLIENT == T005.MANDT
  • P_ARBSITMBANKSTMT03.PARTNERBANKCOUNTRY == T005.LAND1