P_JP_ARDocumentItemList

Accounts Receivable Document Item List | view: PJPARDOCIT | Extraction: Not supported | Component: Financials Japan
Column Name Description
Customer FK Customer Number
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger in General Ledger Accounting
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
AmountInCompanyCodeCurrency Amount in Company Code Currency
AcctsRblAmtInCCCrcy Increase (Decrease) in Accounts Receivable (Net)
NetPriceAmount Net Price
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
ClearingDate Clearing Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
DocumentItemText Item Text TEXT50
DebitCreditCodeName Debit/Credit Code Name DDTEXT
ReferenceDocument Reference document number AWREF
ReferenceDocumentItem Reference Document Item NUMC6
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_JP_ARDOCUMENTITEMLIST.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_JP_ARDOCUMENTITEMLIST.MANDT == T003.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_JP_ARDOCUMENTITEMLIST.MANDT == T004.MANDT
  • P_JP_ARDOCUMENTITEMLIST.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • P_JP_ARDOCUMENTITEMLIST.COMPANYCODE == T001.BUKRS
  • P_JP_ARDOCUMENTITEMLIST.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • P_JP_ARDOCUMENTITEMLIST.MANDT == TCURC.MANDT
  • P_JP_ARDOCUMENTITEMLIST.COMPANYCODECURRENCY == TCURC.WAERS
Customer Number
  • Customer Number
  • Client
  • P_JP_ARDOCUMENTITEMLIST.CUSTOMER == KNA1.KUNNR
  • P_JP_ARDOCUMENTITEMLIST.MANDT == KNA1.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • P_JP_ARDOCUMENTITEMLIST.GLACCOUNT == SKB1.SAKNR
  • P_JP_ARDOCUMENTITEMLIST.COMPANYCODE == SKB1.BUKRS
  • P_JP_ARDOCUMENTITEMLIST.MANDT == SKB1.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Product Number
  • Client
  • Product Number
  • P_JP_ARDOCUMENTITEMLIST.MANDT == MARA.MANDT
  • P_JP_ARDOCUMENTITEMLIST.PRODUCT == MARA.MATNR
Source Ledger
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Transaction Currency
  • Transaction Currency
  • Client
  • P_JP_ARDOCUMENTITEMLIST.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_JP_ARDOCUMENTITEMLIST.MANDT == TCURC.MANDT