P_ARJrnlEntrItmOpenRec

Open Receivables Journal Entry View | view: PARJEITMOPNREC | Extraction: Not supported | Component: Information System
Tables used: ACDOCABKPFBSEGT001TKA02PROJPRPST001T014FINSC_LEDGER_REP
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
Column Name Description
Column Name Description
ClearingDate Clearing Date
PostingDate Posting Date
DocumentDate Journal Entry Date
RefInvcDocumentDate Journal Entry Date
RefInvcNetDueDate Due Date for Net Payment
NetDueDate Net Due Date
Column Name Description
FinancialAccountType Account Type Show values
RefInvcFinancialAccountType Account Type Show values
RefInvcDebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
AccountingDocumentItem Journal Entry Posting View Item BUZEI
InvoiceReference Invoice Reference BELNR
InvoiceItemReference Invoice Item Reference BUZEI
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
FollowOnDocumentType Follow-On Document Type REBZT
RefInvcNetPaymentDays Net Payment Terms Period ZBDXT
RefInvcInvoiceReference Document No. of the Invoice to Which the Transaction Belongs BELNR
BillingDocument Billing Document VBELN
AssignmentReference Assignment Reference ZUONR
NetDueArrearsDays null
Master Data Relations Join Conditions
Business Area
  • Client
  • Business Area
  • P_ARJRNLENTRITMOPENREC.MANDT == TGSB.MANDT
  • P_ARJRNLENTRITMOPENREC.BUSINESSAREA == TGSB.GSBER
Company Code
  • Company Code
  • Client
  • P_ARJRNLENTRITMOPENREC.COMPANYCODE == T001.BUKRS
  • P_ARJRNLENTRITMOPENREC.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • P_ARJRNLENTRITMOPENREC.MANDT == TCURC.MANDT
  • P_ARJRNLENTRITMOPENREC.COMPANYCODECURRENCY == TCURC.WAERS
Customer Number
  • Customer Number
  • Client
  • P_ARJRNLENTRITMOPENREC.CUSTOMER == KNA1.KUNNR
  • P_ARJRNLENTRITMOPENREC.MANDT == KNA1.MANDT
G/L Account
  • Company Code
  • Client
  • G/L Account
  • P_ARJRNLENTRITMOPENREC.COMPANYCODE == SKB1.BUKRS
  • P_ARJRNLENTRITMOPENREC.MANDT == SKB1.MANDT
  • P_ARJRNLENTRITMOPENREC.GLACCOUNT == SKB1.SAKNR
Profit Center
  • Client
  • ?
  • Profit Center
  • ?
  • P_ARJRNLENTRITMOPENREC.MANDT == CEPC.MANDT
  • P_ARJRNLENTRITMOPENREC.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_ARJRNLENTRITMOPENREC.PROFITCENTER == CEPC.PRCTR
  • P_ARJRNLENTRITMOPENREC.[column in domain "DATBI"] == CEPC.DATBI
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_ARJRNLENTRITMOPENREC.MANDT == FAGL_SEGM.MANDT
  • P_ARJRNLENTRITMOPENREC.SEGMENT == FAGL_SEGM.SEGMENT
Special G/L Indicator
  • Client
  • Account Type
  • Special G/L Indicator
  • P_ARJRNLENTRITMOPENREC.MANDT == T074U.MANDT
  • P_ARJRNLENTRITMOPENREC.FINANCIALACCOUNTTYPE == T074U.KOART
  • P_ARJRNLENTRITMOPENREC.SPECIALGLCODE == T074U.UMSKZ