I_MY_JournalEntryItemCube

Journal Entry Item Cube for MY GAF | view: IMYGENJRNLCUBE | TRAN | Extraction: Full only | Component: Financials Malaysia
Tables used: BKPFBSEGBUT000T004KNA1CVI_CUST_LINKSKA1T030LFA1CVI_VEND_LINKT001T014SKATT004
Column Name Description
CompanyCode FK Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
💲 Reporting Currency (ReportingCurrency):
DebitAmountInDisplayCrcy null
CreditAmountInDisplayCrcy null
GLAcctBalanceAmt Line Balance
💲 Company Code Currency (CompanyCodeCurrency):
DebitAmountInCoCodeCrcy null
CreditAmountInCoCodeCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
TaxReportingDate Tax Reporting Date
DocumentDate Journal Entry Date
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
FinancialAccountType Account Type Show values
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
OriginRefDocBusObjTypeName null
AccountingDocumentHeaderText Document Header Text TEXT25
GLAccountName G/L Account Short Text TEXT20
ProfitLossAccountType P&L statement account type CHAR2
BusinessPartnerPhysicianName Name of Supplier TEXT80
AuthorizationGroup Authorization Group BRGRU
OriginalReferenceDocument Original Reference Document AWKEY
Master Data Relations Join Conditions
Chart of Accounts
  • Chart of Accounts
  • Chart of Accounts
  • Client
  • I_MY_JOURNALENTRYITEMCUBE.OPERATIONALCHARTOFACCOUNTS == T004.KTOPL
  • I_MY_JOURNALENTRYITEMCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • I_MY_JOURNALENTRYITEMCUBE.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • I_MY_JOURNALENTRYITEMCUBE.COMPANYCODE == T001.BUKRS
  • I_MY_JOURNALENTRYITEMCUBE.MANDT == T001.MANDT
G/L Account
  • Company Code
  • G/L Account
  • Client
  • I_MY_JOURNALENTRYITEMCUBE.COMPANYCODE == SKB1.BUKRS
  • I_MY_JOURNALENTRYITEMCUBE.GLACCOUNT == SKB1.SAKNR
  • I_MY_JOURNALENTRYITEMCUBE.MANDT == SKB1.MANDT
Chart of Accounts
  • Chart of Accounts
  • Chart of Accounts
  • Client
  • I_MY_JOURNALENTRYITEMCUBE.OPERATIONALCHARTOFACCOUNTS == T004.KTOPL
  • I_MY_JOURNALENTRYITEMCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • I_MY_JOURNALENTRYITEMCUBE.MANDT == T004.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • I_MY_JOURNALENTRYITEMCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_MY_JOURNALENTRYITEMCUBE.MANDT == TCURC.MANDT