P_Arbanktransactiondocitem_06

Retrieve Bank Statement Item data from FEBEP | view: PARBKTRANDOCIT6 | TRAN | Extraction: Not supported | Component: Information System
Tables used: FEBEP
Column Name Description
StatementShortID Short Key for Bank Statement (Surrogate Key)
StatementItem Memo Record Number (Line Item Number in Bank Statement)
Column Name Description
💲 Account Currency Key (TransactionCurrency):
AmountInAccountCurrency Amount in Account Currency
FeeAmountInTransactionCrcy Fees in Account Currency
OverdueChargeAmtInTransacCrcy Overdue Charges from/to Partners in Account Currency
💲 Foreign Currency Key (Not Account Currency) (OriginalCurrency):
ForeignCurrencyAmount Foreign Currency Amount (Different from Account Currency)
FeeAmountInOriginalCrcy Fees in Foreign Currency (Not Same as Account Currency)
Column Name Description
Column Name Description
ValueDate Value Date of the Item to Be Cleared
BankPostingDate Posting Date at the Bank
PostingDate Posting Date in the Document
BillOfExchangeFailureDate Date of Failed Bills of Exchange in Japan
Column Name Description
InterpretationAlgorithm Interpretation Algorithm Show values
PaymentAdviceAccountType Payment Advice Account Type Show values
MemoLineIsChanged Note to Payee Has Been Changed Manually Show values
TreasuryContractType Contract Type Show values
ItemProcessingType Processing Type Show values
BankLedgerPostingIsSuppressed X - Standard (FI) Posting Should Be Suppressed Show values
SubledgerPostingIsSuppressed X - Standard (FI) Posting Should Be Suppressed Show values
CheckType Type of document which is mentioned in CHECT Show values
MachineLrngBankStmntItemStatus Machine Learning Status of Item Show values
Column Name Description Domain name
BankLedgerIsPosted Update 1 OK CHAR1
SubledgerIsPostedSuccessfully 2nd Update OK CHAR1
DebitCreditCode Debit/Credit Key for Line Items (for Bank Purposes) CHAR1
ItemGroup Bundle Number for Grouping Line Items CHAR2
PaymentTransaction Business Transaction Code CHAR3
PaymentAdviceAccount Account Number KTONR
IsInProcess Payment Advice Number AVSID
ExchangeRate Exchange Rate: Foreign Currency to Account Currency KURSF
BusinessPartnerName Business Partner CHAR55
PaymentManualTransacType Transaction VGMAN_EB
PaymentAdvice Payment Advice Number AVSID
ValueDateTime Value Date Time TIME6
PaymentExternalTransacType External Business Transaction VGEXT_EB
PaymentTransactionDescription Bank Posting Text CHAR50
AccountingClerk Accounting Clerk CHAR2
CostCenter Cost Center CHAR10
BusinessArea Business Area CHAR4
ProfitCenter Profit Center PRCTR
TreasuryContract Contract Number RANL
DaybookEntry Daybook Number CHAR10
Cheque Check number CHCKN
ItemIsInterpreted Line Items Were Interpreted CHAR1
PostingErrorStatus Error Status CHAR4
BankLedgerDocument Document Number of an Accounting Document BELNR
FiscalYear Fiscal Year GJAHR
BankPostingKey Text Key CHAR4
AcctDetnFreeDefinedAttribute Account modification KFMOD_EB
DocumentReferenceID Reference Document Number XBLNR1
AssignmentReference Assignment number ZUONR
PartnerBank Bank Number of Partner Bank BANKK
PartnerBankSWIFTCode SWIFT Code of Partner Bank SWIFT
PartnerBankAccount Account Number at the Partner Bank BANKN
FinancialAssetsMgmtStatus Financial Assets Management Status CHAR2
FinancialAssetsMgmtInfoField Financial Assets Management Information Field CHAR40
ItemDescription1 Additional Information 1 CHAR30
ItemDescription2 Additional Information 2 CHAR30
SubledgerDocument Subledger document number BELNR
BankLedgerOnAccountDocument Payment on account document number BELNR
SubledgerOnAccountDocument Payment on account document number BELNR
PayerParty Account Number of an Alternative Payer KUNNR
BatchNumber Batch Number (Bundle Number) CHAR3
AccountingExchangeRate Exchange Rate (Different from Local Currency) KURSF
DocumentItemText Item Text TEXT50
PostingAlgorithm Posting Algorithm (Lockbox only) CHAR3
NumberOfSecondSubledgerDoc Number of Second Subledger Document BELNR
BankReference Bank Reference Number CHAR35
ReferenceDocument Reference Key AWKEY
ReferenceDocumentType Reference procedure AWTYP
PaymentReference Payment Reference CHAR30
ReturnReason Customer-to-Customer Reference CHAR35
DunningBlockingReason Dunning Block MANSP
IdNumberForCashMgmtAndForecast ID number for cash management and forecast IDENR
BankLedgerExternalApplication Application Indicator APPLK_BF
BankLedgerExtPostgErrorStatus Error Status CHAR4
BankLedgerExtPostingDocument Doc. no. (IDoc number, application document no., etc.) CHAR70
BankLedgerExtPostingRefDocType Reference procedure AWTYP
SubledgerExtPostingApplication Application Indicator APPLK_BF
SubledgerExtPostingErrorStatus Error Status CHAR4
SubledgerExtPostingDocument Doc. no. (IDoc number, application document no., etc.) CHAR70
SubledgerExtPostingRefDocType Reference procedure AWTYP
PartnerBankIBAN Partner Bank Account: IBAN IBAN
ItemIsReprocessed null
PaymentTransactionCategory Transaction FEB_BSPROC_TATYP
AttachmentKey null
IsCompleted Line Item Completed CHAR1
CheckNumber Check number CHCKN
BankLedgerAcctgDocFiscalYear Fiscal Year of Bank Accounting Document GJAHR
SubledgerAcctgDocFiscalYear Fiscal Year of Subledger Accounting Document GJAHR
accdoc_tmp_doc_id Temporary Accounting Document ID FDC_ACCDOC_TMP_DOC_ID
BusinessPartnerIDCategory BP Identification Category BU_ID_CATEGORY
BusinessPartnerIDNumber Identification Number CHAR60
AdditionalInformation Additional information from file ADDITIONAL_INFO_EB
Master Data Relations Join Conditions
Reprocessing Reason Code
  • Client
  • Reprocessing Reason Code
  • P_ARBANKTRANSACTIONDOCITEM_06.MANDT == FEB_REPRO_RRC.MANDT
  • P_ARBANKTRANSACTIONDOCITEM_06.ITEMREPROCESSREASON == FEB_REPRO_RRC.REPROCREASONCODE
Foreign currency (not account currency)
  • Foreign Currency Key (Not Account Currency)
  • Client
  • P_ARBANKTRANSACTIONDOCITEM_06.ORIGINALCURRENCY == TCURC.WAERS
  • P_ARBANKTRANSACTIONDOCITEM_06.MANDT == TCURC.MANDT
Partner Bank
  • Client
  • Country/Region Key of Partner Bank
  • P_ARBANKTRANSACTIONDOCITEM_06.MANDT == T005.MANDT
  • P_ARBANKTRANSACTIONDOCITEM_06.PARTNERBANKCOUNTRY == T005.LAND1
Input Help for Posting Rule (Internal Activity)
  • Posting Rule
  • Client
  • P_ARBANKTRANSACTIONDOCITEM_06.POSTINGRULE == T028D.VGINT
  • P_ARBANKTRANSACTIONDOCITEM_06.MANDT == T028D.MANDT