P_Arbsitmopenitem

Open Receivable Items | view: PARBSITMOI | Extraction: Not supported | Component: Financial Cash Application Intelligence
Tables used: BKPFBSEGT001TKA02KNA1LFA1ADRCT001T014
Column Name Description
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
TaxAmountInCoCodeCrcy Signed Tax Amount in Company Code Currency
CashDiscountAmtInCoCodeCrcy Cash Discount Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
TaxAmount Tax Amount in Transaction Currency
CashDiscountAmount Cash Discount Amount
Column Name Description
Column Name Description
PostingDate Posting Date
ClearingDate Clearing Date
NetDueDate Due Date for Net Payment
CashDiscount1DueDate Due Date for Cash Discount 1
CashDiscount2DueDate Cash Discount 2 Due Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
FiscalYear Fiscal Year GJAHR
AccountingDocument Journal Entry BELNR
AccountingDocumentItem Posting View Item BUZEI
DocumentReferenceID Document Reference ID XBLNR1
AssignmentReference Assignment Reference ZUONR
PaymentReference Payment Reference CHAR30
BillingDocument Billing Document VBELN
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
ClearingAccountingDocument Clearing Document Number BELNR
DocumentItemText Item Text TEXT50
InvoiceReference Document No. of the Invoice to Which the Transaction Belongs BELNR
InvoiceReferenceFiscalYear Fiscal Year GJAHR
InvoiceItemReference Line Item BUZEI
FollowOnDocumentType Follow-On Document Type REBZT
Debtor Customer KUNNR
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
OrganizationBPName3 null
OrganizationBPName4 null
CityName City TEXT35
Country Country/Region Key LAND1
AccountingDocumentHeaderText Document Header Text TEXT25
CashDiscount1Percent Cash Discount Percentage 1 PRZ23
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
Reference1IDByBusinessPartner Business Partner Reference Key 1 CHAR12
Reference2IDByBusinessPartner Business Partner Reference Key 2 CHAR12
Reference3IDByBusinessPartner ID of Reference 3 by Business Partner CHAR20
ReceivableKey null
name1 Name 1 TEXT40
name2 Name 2 TEXT40
name3 Name 3 TEXT40
name4 Name 4 TEXT40
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_ARBSITMOPENITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_ARBSITMOPENITEM.MANDT == T003.MANDT
Company Code
  • Company Code
  • Client
  • P_ARBSITMOPENITEM.COMPANYCODE == T001.BUKRS
  • P_ARBSITMOPENITEM.MANDT == T001.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • P_ARBSITMOPENITEM.COUNTRYKEY == T005.LAND1
  • P_ARBSITMOPENITEM.MANDT == T005.MANDT
Version ID for International Addresses P_ARBSITMOPENITEM.NATION == TSADV.NATION
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • P_ARBSITMOPENITEM.PARTNERCOMPANY == T880.RCOMP
  • P_ARBSITMOPENITEM.MANDT == T880.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • P_ARBSITMOPENITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_ARBSITMOPENITEM.MANDT == TCURC.MANDT