P_ARJrnlEntrItmOpenRec1

P_ARJrnlEntrItmOpenRec1 | view: PARJEITMOPNREC1 | Extraction: Not supported | Component: Information System

Tables used: ACDOCA, BKPF, BSEG, PROJ, PRPS, T001, T014, FINSC_LEDGER_REP

🔑 Keys (4)
💰 Amounts (2)
∑ Quantities
📅 Dates (4)
☰ Categorical (2)
Other (11)
🔗 Relations (11)

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
NetDueDate	Net Due Date

Column Name	Description
AccountingDocumentCategory	Journal Entry Category	Show values
FinancialAccountType	Account Type	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

Master Data Relations	Join Conditions
Journal Entry Type Client Journal Entry Type	`P_ARJRNLENTRITMOPENREC1.MANDT == T003.MANDT` `P_ARJRNLENTRITMOPENREC1.ACCOUNTINGDOCUMENTTYPE == T003.BLART`
Business Area Business Area Client	`P_ARJRNLENTRITMOPENREC1.BUSINESSAREA == TGSB.GSBER` `P_ARJRNLENTRITMOPENREC1.MANDT == TGSB.MANDT`
Company Code Client Company Code	`P_ARJRNLENTRITMOPENREC1.MANDT == T001.MANDT` `P_ARJRNLENTRITMOPENREC1.COMPANYCODE == T001.BUKRS`
Company Code Currency Client Company Code Currency	`P_ARJRNLENTRITMOPENREC1.MANDT == TCURC.MANDT` `P_ARJRNLENTRITMOPENREC1.COMPANYCODECURRENCY == TCURC.WAERS`
Customer Number Client Customer Number	`P_ARJRNLENTRITMOPENREC1.MANDT == KNA1.MANDT` `P_ARJRNLENTRITMOPENREC1.CUSTOMER == KNA1.KUNNR`
G/L Account G/L Account Client Company Code	`P_ARJRNLENTRITMOPENREC1.GLACCOUNT == SKB1.SAKNR` `P_ARJRNLENTRITMOPENREC1.MANDT == SKB1.MANDT` `P_ARJRNLENTRITMOPENREC1.COMPANYCODE == SKB1.BUKRS`
Payment Method ? Client Payment Method	`P_ARJRNLENTRITMOPENREC1.[column in domain "LAND1"] == T042Z.LAND1` `P_ARJRNLENTRITMOPENREC1.MANDT == T042Z.MANDT` `P_ARJRNLENTRITMOPENREC1.PAYMENTMETHOD == T042Z.ZLSCH`
Profit Center Client ? ? Profit Center	`P_ARJRNLENTRITMOPENREC1.MANDT == CEPC.MANDT` `P_ARJRNLENTRITMOPENREC1.[column in domain "KOKRS"] == CEPC.KOKRS` `P_ARJRNLENTRITMOPENREC1.[column in domain "DATBI"] == CEPC.DATBI` `P_ARJRNLENTRITMOPENREC1.PROFITCENTER == CEPC.PRCTR`
Segment for Segmental Reporting Client Segment for Segmental Reporting	`P_ARJRNLENTRITMOPENREC1.MANDT == FAGL_SEGM.MANDT` `P_ARJRNLENTRITMOPENREC1.SEGMENT == FAGL_SEGM.SEGMENT`
Special G/L Indicator Client Special G/L Indicator Account Type	`P_ARJRNLENTRITMOPENREC1.MANDT == T074U.MANDT` `P_ARJRNLENTRITMOPENREC1.SPECIALGLCODE == T074U.UMSKZ` `P_ARJRNLENTRITMOPENREC1.FINANCIALACCOUNTTYPE == T074U.KOART`
Transaction Currency Client Transaction Currency	`P_ARJRNLENTRITMOPENREC1.MANDT == TCURC.MANDT` `P_ARJRNLENTRITMOPENREC1.TRANSACTIONCURRENCY == TCURC.WAERS`