C_PH_JournalEntryQuery

PH CAS General Journal/Ledger Query | view: CPHGENJRNLQRY | Extraction: Not supported | Component: Financials Philippines
Column Name Description
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
💲 Company Code Currency (Currency):
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
GLAccountLongName G/L Account Long Text TEXT50
AccountingDocumentTypeName Document Type Name TEXT20
ClearingAccountingDocument Clearing Journal Entry BELNR
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
DocumentReferenceID Document Reference ID XBLNR1
OriginalReferenceDocument null
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_PH_JOURNALENTRYQUERY.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_PH_JOURNALENTRYQUERY.MANDT == T003.MANDT
Business Area
  • Business Area
  • Client
  • C_PH_JOURNALENTRYQUERY.BUSINESSAREA == TGSB.GSBER
  • C_PH_JOURNALENTRYQUERY.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • C_PH_JOURNALENTRYQUERY.COMPANYCODE == T001.BUKRS
  • C_PH_JOURNALENTRYQUERY.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • C_PH_JOURNALENTRYQUERY.MANDT == TCURC.MANDT
  • C_PH_JOURNALENTRYQUERY.CURRENCY == TCURC.WAERS
G/L Account
  • Company Code
  • G/L Account
  • Client
  • C_PH_JOURNALENTRYQUERY.COMPANYCODE == SKB1.BUKRS
  • C_PH_JOURNALENTRYQUERY.GLACCOUNT == SKB1.SAKNR
  • C_PH_JOURNALENTRYQUERY.MANDT == SKB1.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Tax on Sales/Purchases Code
  • ?
  • Tax on Sales/Purchases Code
  • Client
  • C_PH_JOURNALENTRYQUERY.[column in domain "KALSM_D"] == T007A.KALSM
  • C_PH_JOURNALENTRYQUERY.TAXCODE == T007A.MWSKZ
  • C_PH_JOURNALENTRYQUERY.MANDT == T007A.MANDT