SKAT

G/L Account Master Record (Chart of Accounts: Description) | #text | Component: Financial Accounting
Column Name Description
MANDT FK Client
SPRAS FK Language Key
KTOPL FK Chart of Accounts
SAKNR FK G/L Account Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
TXT20 G/L Account Short Text TEXT20
TXT50 G/L Account Long Text TEXT50
MCOD1 Search Term for Matchcode Search CHAR25
LAST_CHANGED_TS UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Chart of Accounts
  • Chart of Accounts
  • Client
  • SKAT.KTOPL == T004.KTOPL
  • SKAT.MANDT == T004.MANDT
Client SKAT.MANDT == T000.MANDT
G/L Account Number
  • Chart of Accounts
  • Client
  • G/L Account Number
  • SKAT.KTOPL == SKA1.KTOPL
  • SKAT.MANDT == SKA1.MANDT
  • SKAT.SAKNR == SKA1.SAKNR
Language Key SKAT.SPRAS == T002.SPRAS