P_JP_GRMaterialDocumentItem

Goods Receipt Material Document Item List | view: PJPGRMDOCIT | Extraction: Not supported | Component: Financials Japan
Column Name Description
Supplier FK Supplier
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
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Currency Key (DocumentCurrency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
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
InvoiceIsGoodsReceiptBased Indicator: GR-Based Invoice Verification Show values
FinancialAccountType Account Type Show values
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
MaterialDocument Reference document number AWREF
JP_Annex205APLeadingAcctgDoc Japan Annex20(5) Leading Accounting Document Number BELNR
FiscalPeriod Fiscal Period POPER
AccountingDocumentHeaderText Document Header Text TEXT25
DocumentItemText Item Text TEXT50
ReferenceDocument Reference document number AWREF
ReferenceDocumentItem Reference Document Item NUMC6
NetPriceQuantity Price Unit DEC5
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_JP_GRMATERIALDOCUMENTITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_JP_GRMATERIALDOCUMENTITEM.MANDT == T003.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_JP_GRMATERIALDOCUMENTITEM.MANDT == T006.MANDT
  • P_JP_GRMATERIALDOCUMENTITEM.BASEUNIT == T006.MSEHI
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_JP_GRMATERIALDOCUMENTITEM.MANDT == T004.MANDT
  • P_JP_GRMATERIALDOCUMENTITEM.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • P_JP_GRMATERIALDOCUMENTITEM.COMPANYCODE == T001.BUKRS
  • P_JP_GRMATERIALDOCUMENTITEM.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • P_JP_GRMATERIALDOCUMENTITEM.MANDT == TCURC.MANDT
  • P_JP_GRMATERIALDOCUMENTITEM.COMPANYCODECURRENCY == TCURC.WAERS
Currency Key
  • Currency Key
  • Client
  • P_JP_GRMATERIALDOCUMENTITEM.DOCUMENTCURRENCY == TCURC.WAERS
  • P_JP_GRMATERIALDOCUMENTITEM.MANDT == TCURC.MANDT
G/L Account
  • Company Code
  • Client
  • G/L Account
  • P_JP_GRMATERIALDOCUMENTITEM.COMPANYCODE == SKB1.BUKRS
  • P_JP_GRMATERIALDOCUMENTITEM.MANDT == SKB1.MANDT
  • P_JP_GRMATERIALDOCUMENTITEM.GLACCOUNT == SKB1.SAKNR
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • P_JP_GRMATERIALDOCUMENTITEM.ORDERPRICEUNIT == T006.MSEHI
  • P_JP_GRMATERIALDOCUMENTITEM.MANDT == T006.MANDT
Product Number
  • Client
  • Product Number
  • P_JP_GRMATERIALDOCUMENTITEM.MANDT == MARA.MANDT
  • P_JP_GRMATERIALDOCUMENTITEM.PRODUCT == MARA.MATNR
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Supplier
  • Client
  • Supplier
  • P_JP_GRMATERIALDOCUMENTITEM.MANDT == LFA1.MANDT
  • P_JP_GRMATERIALDOCUMENTITEM.SUPPLIER == LFA1.LIFNR
Transaction Currency
  • Client
  • Transaction Currency
  • P_JP_GRMATERIALDOCUMENTITEM.MANDT == TCURC.MANDT
  • P_JP_GRMATERIALDOCUMENTITEM.TRANSACTIONCURRENCY == TCURC.WAERS