C_JP_Annex205APBookQuery

Japan Annex205 AP Book - Query | view: CJPANX205QUERY | Extraction: Not supported | Component: Financials Japan
Column Name Description
Supplier FK Supplier
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
JP_Annex205APLeadingAcctgDoc Japan Annex20(5) Leading Accounting Document Number
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
AcctsPyblAmtInCCCrcy Increase (Decrease) in Accounts Payable (Net)
💲 Currency Key (DocumentCurrency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity of Japan Annex20
📏 Order Price Unit (Purchasing) (OrderPriceUnit):
NetPriceQuantity Net price 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
AccountingDocumentHeaderText Document Header Text TEXT25
DocumentItemText Item Text TEXT50
ReferenceDocument Reference document number AWREF
ReferenceDocumentItem Reference Document Item NUMC6
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_JP_ANNEX205APBOOKQUERY.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_JP_ANNEX205APBOOKQUERY.MANDT == T003.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_JP_ANNEX205APBOOKQUERY.MANDT == T006.MANDT
  • C_JP_ANNEX205APBOOKQUERY.BASEUNIT == T006.MSEHI
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_JP_ANNEX205APBOOKQUERY.CHARTOFACCOUNTS == T004.KTOPL
  • C_JP_ANNEX205APBOOKQUERY.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • C_JP_ANNEX205APBOOKQUERY.COMPANYCODE == T001.BUKRS
  • C_JP_ANNEX205APBOOKQUERY.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • C_JP_ANNEX205APBOOKQUERY.MANDT == TCURC.MANDT
  • C_JP_ANNEX205APBOOKQUERY.COMPANYCODECURRENCY == TCURC.WAERS
Currency Key
  • Client
  • Currency Key
  • C_JP_ANNEX205APBOOKQUERY.MANDT == TCURC.MANDT
  • C_JP_ANNEX205APBOOKQUERY.DOCUMENTCURRENCY == TCURC.WAERS
G/L Account
  • Company Code
  • G/L Account
  • Client
  • C_JP_ANNEX205APBOOKQUERY.COMPANYCODE == SKB1.BUKRS
  • C_JP_ANNEX205APBOOKQUERY.GLACCOUNT == SKB1.SAKNR
  • C_JP_ANNEX205APBOOKQUERY.MANDT == SKB1.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • C_JP_ANNEX205APBOOKQUERY.ORDERPRICEUNIT == T006.MSEHI
  • C_JP_ANNEX205APBOOKQUERY.MANDT == T006.MANDT
Product Number
  • Product Number
  • Client
  • C_JP_ANNEX205APBOOKQUERY.PRODUCT == MARA.MATNR
  • C_JP_ANNEX205APBOOKQUERY.MANDT == MARA.MANDT
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Supplier
  • Client
  • Supplier
  • C_JP_ANNEX205APBOOKQUERY.MANDT == LFA1.MANDT
  • C_JP_ANNEX205APBOOKQUERY.SUPPLIER == LFA1.LIFNR
Transaction Currency
  • Transaction Currency
  • Client
  • C_JP_ANNEX205APBOOKQUERY.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_JP_ANNEX205APBOOKQUERY.MANDT == TCURC.MANDT