P_Arbsitmonacc

On Account Posting with Bank Statement Data | view: PARBSITONACC | Extraction: Not supported | Component: Information System
Tables used: FEBEP, FEBRE, FEBRE_ORIG, SRGBTBREL, FEBKO, FEBKO, FEBKO_REVERSED, BKPF, BSEG, FEBKO, FCLM_BAM_AMD, FCLM_BAM_AC_TYPE, T001, TKA02, BNKA, FCLM_BAM_ACLINK2, T012, FEB_TATYP, FEB_TATYP_C, FEB_TATYP_T, FEB_TATYP_TC, T028I, FCLM_BAM_ACLINK2, FDC_D_DFT_AC_HDR, FDC_D_DFT_HDR, FEB_REPRO_RRCT, T012, T028E, BNKA, T001, T014, T033F
Column Name Description
Column Name Description
💲 Currency Key (Currency):
AmountInTransactionCurrency Amount in Account Currency
💲 Payment Currency Key (OriginalCurrency):
AmountInOriginalCurrency Foreign Currency Amount (Different from Account Currency)
💲 Transaction Currency (OITransactionCurrency):
OIAmountInTransactionCurrency Amount in Transaction Currency
💲 Company Code Currency (OICompanyCodeCurrency):
OIAmountInCompanyCodeCurrency Amount in Company Code Currency
Column Name Description
Column Name Description
BankStatementImportDate Bank Statement Import Date into System
BankStatementImportTime Bank Statement Import Time into System
PostingDate Posting Date in the Document
OIPostingDate Posting Date
OIAccountingDocCreationDate Accounting Document Entry Date
OICreationTime Creation Time
OIClearingCreationDate Clearing Creation Date
Column Name Description
PaymentAdviceAccountType Payment Advice Account Type 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
InterpretationAlgorithm Interpretation Algorithm Show values
MachineLrngBankStmntItemStatus Machine Learning Status of Item Show values
OIDebitCreditCode Debit/Credit Code Show values
OIFinancialAccountType Account Type Show values
Column Name Description Domain name
BankStatementShortID Bank Statement Short Key FARP_KUKEY
BankStatement Bank Statement Number FARP_AZNUM
HouseBank Short Key for a House Bank HBKID
HouseBankAccount ID for Account Details HKTID
BankInternalID Bank Keys BANKK
BankAccount Bank Account Number BANKN
BankName Name of House Bank TEXT60
BankStatementDate Bank Statement Identification CHAR20
CreatedByUser User who uploaded the file into the System CHAR12
BankStatementItem Line Item Number FARP_ESNUM
PaymentAdviceAccount Account Number KTONR
PaymentAdvice Payment Advice Number AVSID
CustomerReferenceNumber Check number CHCKN
PaymentReference Payment Reference CHAR30
DocumentReferenceID Reference Document Number XBLNR1
AssignmentReference Assignment number ZUONR
BankPostingKey Text Key CHAR4
PaymentExternalTransacType External Business Transaction VGEXT_EB
DocumentItemText Item Text TEXT50
DebitCreditCode Debit/Credit Key for Line Items (for Bank Purposes) CHAR1
IsCompleted Line Item Completed CHAR1
BusinessPartnerName Business Partner CHAR55
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
PartnerBankName Name of Financial Institution TEXT60
BankLedgerDocument Document Number of an Accounting Document BELNR
SubledgerDocument Subledger document number BELNR
SubledgerOnAccountDocument Payment on account document number BELNR
BankReference Bank Reference Number CHAR35
MemoLine Memo Line FAR_MEMO_LINE
OIAccountingDocument Journal Entry BELNR
OIFiscalYear Fiscal Year GJAHR
OIDocumentReferenceID Document Reference ID XBLNR1
OIOriginalReferenceDocument Original Reference Document AWKEY
OIReferenceDocumentLogicalSys Logical System of Reference Document LOGSYS
OIReferenceDocumentType Reference Document Type AWTYP
OIAccountingDocumentHeaderText Document Header Text TEXT25
OIAccountingDocCreatedByUser User that created the journal entry
OITransactionCode Transaction Code TCODE
OIAccountingDocumentItem Posting View Item BUZEI
OIClearingAccountingDocument Clearing Document Number BELNR
OIClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
OIAssignmentReference Assignment Reference ZUONR
OIPaymentReference Payment Reference CHAR30
OIDocumentItemText Item Text TEXT50
Master Data Relations Join Conditions
Input Help for Posting Rule (Internal Activity)
  • Client
  • Bank Statement Posting Rule
  • P_ARBSITMONACC.MANDT == T028D.MANDT
  • P_ARBSITMONACC.BANKSTATEMENTPOSTINGRULE == T028D.VGINT
Company code
  • Company Code
  • Company Code
  • Client
  • P_ARBSITMONACC.OICOMPANYCODE == T001.BUKRS
  • P_ARBSITMONACC.COMPANYCODE == T001.BUKRS
  • P_ARBSITMONACC.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • P_ARBSITMONACC.MANDT == TCURC.MANDT
  • P_ARBSITMONACC.CURRENCY == TCURC.WAERS
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_ARBSITMONACC.MANDT == T003.MANDT
  • P_ARBSITMONACC.OIACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Company Code
  • Company Code
  • Client
  • P_ARBSITMONACC.OICOMPANYCODE == T001.BUKRS
  • P_ARBSITMONACC.COMPANYCODE == T001.BUKRS
  • P_ARBSITMONACC.MANDT == T001.MANDT
Customer
  • Customer
  • Client
  • P_ARBSITMONACC.OIDEBTOR == KNA1.KUNNR
  • P_ARBSITMONACC.MANDT == KNA1.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • P_ARBSITMONACC.OITRANSACTIONCURRENCY == TCURC.WAERS
  • P_ARBSITMONACC.MANDT == TCURC.MANDT
Foreign currency (not account currency)
  • Payment Currency Key
  • Client
  • P_ARBSITMONACC.ORIGINALCURRENCY == TCURC.WAERS
  • P_ARBSITMONACC.MANDT == TCURC.MANDT
Partner Bank
  • Client
  • Country/Region Key of Partner Bank
  • P_ARBSITMONACC.MANDT == T005.MANDT
  • P_ARBSITMONACC.PARTNERBANKCOUNTRY == T005.LAND1