I_GLAccountTextRawData

General Ledger Account - Text | view: IFIGLACCTTRD | TEXT | Extraction: Full or Incremental | Component: Information System
Tables used: SKAT
Column Name Description
ChartOfAccounts FK Chart of Accounts
GLAccount FK G/L Account Number
Language FK Language Key
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
GLAccountName G/L Account Short Text TEXT20
GLAccountLongName G/L Account Long Text TEXT50
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_GLACCOUNTTEXTRAWDATA.MANDT == T004.MANDT
  • I_GLACCOUNTTEXTRAWDATA.CHARTOFACCOUNTS == T004.KTOPL
G/L Account Number
  • Client
  • G/L Account Number
  • Chart of Accounts
  • I_GLACCOUNTTEXTRAWDATA.MANDT == SKA1.MANDT
  • I_GLACCOUNTTEXTRAWDATA.GLACCOUNT == SKA1.SAKNR
  • I_GLACCOUNTTEXTRAWDATA.CHARTOFACCOUNTS == SKA1.KTOPL
Language Key I_GLACCOUNTTEXTRAWDATA.LANGUAGE == T002.SPRAS