P_ARJrnlEntrItmOpenRec2_WSJ

P_ARJrnlEntrItmOpenRec1 | view: PARJEITMOPNREC2W | 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
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction 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 Due Date for Net Payment
Column Name Description
AccountingDocumentCategory Journal Entry Category Show values
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
SpecialGLTransactionType Special G/L Transaction Type UMSKS
BillingDocument Billing Document VBELN
AssignmentReference Assignment Reference ZUONR
Reference1IDByBusinessPartner ID of Reference 1 by Business Partner CHAR12
Reference2IDByBusinessPartner ID of Reference 2 by Business Partner CHAR12
Reference3IDByBusinessPartner ID of Reference 3 by Business Partner CHAR20
RefInvcNetPaymentDays Net Payment Terms Period ZBDXT
RefInvcInvoiceReference Document No. of the Invoice to Which the Transaction Belongs BELNR
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_ARJRNLENTRITMOPENREC2_WSJ.MANDT == T003.MANDT
  • P_ARJRNLENTRITMOPENREC2_WSJ.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Business Area
  • Client
  • Business Area
  • P_ARJRNLENTRITMOPENREC2_WSJ.MANDT == TGSB.MANDT
  • P_ARJRNLENTRITMOPENREC2_WSJ.BUSINESSAREA == TGSB.GSBER
Company Code
  • Client
  • Company Code
  • P_ARJRNLENTRITMOPENREC2_WSJ.MANDT == T001.MANDT
  • P_ARJRNLENTRITMOPENREC2_WSJ.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • P_ARJRNLENTRITMOPENREC2_WSJ.MANDT == TCURC.MANDT
  • P_ARJRNLENTRITMOPENREC2_WSJ.COMPANYCODECURRENCY == TCURC.WAERS
Customer Number
  • Client
  • Customer Number
  • P_ARJRNLENTRITMOPENREC2_WSJ.MANDT == KNA1.MANDT
  • P_ARJRNLENTRITMOPENREC2_WSJ.CUSTOMER == KNA1.KUNNR
G/L Account
  • Client
  • G/L Account
  • Company Code
  • P_ARJRNLENTRITMOPENREC2_WSJ.MANDT == SKB1.MANDT
  • P_ARJRNLENTRITMOPENREC2_WSJ.GLACCOUNT == SKB1.SAKNR
  • P_ARJRNLENTRITMOPENREC2_WSJ.COMPANYCODE == SKB1.BUKRS
Payment Method
  • Payment Method
  • ?
  • Client
  • P_ARJRNLENTRITMOPENREC2_WSJ.PAYMENTMETHOD == T042Z.ZLSCH
  • P_ARJRNLENTRITMOPENREC2_WSJ.[column in domain "LAND1"] == T042Z.LAND1
  • P_ARJRNLENTRITMOPENREC2_WSJ.MANDT == T042Z.MANDT
Profit Center
  • Profit Center
  • Client
  • ?
  • ?
  • P_ARJRNLENTRITMOPENREC2_WSJ.PROFITCENTER == CEPC.PRCTR
  • P_ARJRNLENTRITMOPENREC2_WSJ.MANDT == CEPC.MANDT
  • P_ARJRNLENTRITMOPENREC2_WSJ.[column in domain "DATBI"] == CEPC.DATBI
  • P_ARJRNLENTRITMOPENREC2_WSJ.[column in domain "KOKRS"] == CEPC.KOKRS
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_ARJRNLENTRITMOPENREC2_WSJ.MANDT == FAGL_SEGM.MANDT
  • P_ARJRNLENTRITMOPENREC2_WSJ.SEGMENT == FAGL_SEGM.SEGMENT
Special G/L Indicator
  • Account Type
  • Account Type
  • Client
  • Special G/L Indicator
  • P_ARJRNLENTRITMOPENREC2_WSJ.REFINVCFINANCIALACCOUNTTYPE == T074U.KOART
  • P_ARJRNLENTRITMOPENREC2_WSJ.FINANCIALACCOUNTTYPE == T074U.KOART
  • P_ARJRNLENTRITMOPENREC2_WSJ.MANDT == T074U.MANDT
  • P_ARJRNLENTRITMOPENREC2_WSJ.SPECIALGLCODE == T074U.UMSKZ
Transaction Currency
  • Client
  • Transaction Currency
  • P_ARJRNLENTRITMOPENREC2_WSJ.MANDT == TCURC.MANDT
  • P_ARJRNLENTRITMOPENREC2_WSJ.TRANSACTIONCURRENCY == TCURC.WAERS