C_MY_JournalEntryItemQuery

Journal Entry Item Query for MY GAF | view: CMYGENJRNLQRY | Extraction: Not supported | Component: Financials Malaysia
Tables used: BKPFBSEGBUT000T004KNA1CVI_CUST_LINKSKA1T030LFA1CVI_VEND_LINKT001T014SKATT004
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
💲 Reporting Currency (ReportingCurrency):
DebitAmountInDisplayCrcy null
CreditAmountInDisplayCrcy null
GLAcctBalanceAmt Line Balance
Column Name Description
Column Name Description
PostingDate Posting Date
TaxReportingDate Tax Reporting Date
DocumentDate Journal Entry Date
Column Name Description
FinancialAccountType Account Type Show values
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
AccountingDocumentHeaderText Document Header Text TEXT25
GLAccountName G/L Account Short Text TEXT20
ProfitLossAccountType P&L statement account type CHAR2
BusinessPartnerPhysicianName Name of Supplier TEXT80
OriginalReferenceDocument Original Reference Document AWKEY
Master Data Relations Join Conditions
Chart of Accounts
  • Client
  • Chart of Accounts
  • Chart of Accounts
  • C_MY_JOURNALENTRYITEMQUERY.MANDT == T004.MANDT
  • C_MY_JOURNALENTRYITEMQUERY.OPERATIONALCHARTOFACCOUNTS == T004.KTOPL
  • C_MY_JOURNALENTRYITEMQUERY.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • C_MY_JOURNALENTRYITEMQUERY.MANDT == T001.MANDT
  • C_MY_JOURNALENTRYITEMQUERY.COMPANYCODE == T001.BUKRS
G/L Account
  • G/L Account
  • Client
  • Company Code
  • C_MY_JOURNALENTRYITEMQUERY.GLACCOUNT == SKB1.SAKNR
  • C_MY_JOURNALENTRYITEMQUERY.MANDT == SKB1.MANDT
  • C_MY_JOURNALENTRYITEMQUERY.COMPANYCODE == SKB1.BUKRS
Chart of Accounts
  • Client
  • Chart of Accounts
  • Chart of Accounts
  • C_MY_JOURNALENTRYITEMQUERY.MANDT == T004.MANDT
  • C_MY_JOURNALENTRYITEMQUERY.OPERATIONALCHARTOFACCOUNTS == T004.KTOPL
  • C_MY_JOURNALENTRYITEMQUERY.CHARTOFACCOUNTS == T004.KTOPL