FAC_DART_Z3_CHARTOFACCOUNTS

CHARTOFACCOUNTS | view: FAC_DZCHOFACC | Extraction: Not supported | Component: DART (Data Retention Tool)
Tables used: T004T004TT001TKA02CSKACSKBTKA01T077ST077ZSKA1SKB1SKATT004T001T005T007ST001T005T007AT050TT050T
Column Name Description
GLAccount G/L Account Number
Column Name Description
Column Name Description
Column Name Description
InterestCalculationDate Key Date of Last Interest Calculation
CreationDate Date on which the Record Was Created
Column Name Description
AccountIsMarkedForDeletion Indicator: Account Marked for Deletion? Show values
AccountIsBlockedForPlanning Indicator: Account Blocked for Planning ? Show values
ReconciliationAccountType Account is Reconciliation Account Show values
SupplementIsAllowed Indicator: Supplement for Automatic Postings ? Show values
IsOpenItemManaged Indicator: Open Item Management? Show values
IntrstCalcFrequencyInMonths Interest Calculation Frequency in Months Show values
TaxCodeIsRequired Indicator: Tax code is not a required field Show values
BalanceHasLocalCurrency Manage Balances in Local Currency Only (Indicator) Show values
ClearingIsLedgerGroupSpecific Open Item Management by Ledger Group Show values
IsBalanceSheetAccount Indicator: Account is a balance sheet account? Show values
GLAccountType Type of a General Ledger Account Show values
CostElementCategory Cost element category Show values
ConsumptionQtyIsRecorded Indicator for Recording Consumption Quantities Show values
Column Name Description Domain name
ChartOfAccountsName Chart of Accounts Description TEXT50
GLAccountName G/L Account Short Text TEXT20
GLAccountLongName G/L Account Long Text TEXT50
AccountGroupName Account Group Name TEXT30
ReconciliationAccountTypeName Short Text for Fixed Values
TaxCategory Tax Category in Account Master Record SMWSK
TaxCategoryName Tax Category Name TEXT70
AlternativeGLAccount Alternative Account Number in Company Code SAKNR
CreatedByUser Name of Person who Created the Object USNAM
AlternativeGLAccountName G/L Account Short Text
AlternativeGLAccountLongName G/L Account Long Text
SystemClient Client
Master Data Relations Join Conditions
Chart of Accounts
  • Chart of Accounts
  • Client
  • FAC_DART_Z3_CHARTOFACCOUNTS.CHARTOFACCOUNTS == T004.KTOPL
  • FAC_DART_Z3_CHARTOFACCOUNTS.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • FAC_DART_Z3_CHARTOFACCOUNTS.COMPANYCODE == T001.BUKRS
  • FAC_DART_Z3_CHARTOFACCOUNTS.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • FAC_DART_Z3_CHARTOFACCOUNTS.CONTROLLINGAREA == TKA01.KOKRS
  • FAC_DART_Z3_CHARTOFACCOUNTS.MANDT == TKA01.MANDT
Alternative Chart of Accounts
  • Alternative Chart of Accounts
  • Client
  • FAC_DART_Z3_CHARTOFACCOUNTS.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • FAC_DART_Z3_CHARTOFACCOUNTS.MANDT == T004.MANDT
Functional Area
  • Functional Area
  • Client
  • FAC_DART_Z3_CHARTOFACCOUNTS.FUNCTIONALAREA == TFKB.FKBER
  • FAC_DART_Z3_CHARTOFACCOUNTS.MANDT == TFKB.MANDT
Account Currency
  • Client
  • Account Currency
  • FAC_DART_Z3_CHARTOFACCOUNTS.MANDT == TCURC.MANDT
  • FAC_DART_Z3_CHARTOFACCOUNTS.GLACCOUNTCURRENCY == TCURC.WAERS
G/L Account Group
  • G/L Account Group
  • Chart of Accounts
  • Client
  • FAC_DART_Z3_CHARTOFACCOUNTS.GLACCOUNTGROUP == T077S.KTOKS
  • FAC_DART_Z3_CHARTOFACCOUNTS.CHARTOFACCOUNTS == T077S.KTOPL
  • FAC_DART_Z3_CHARTOFACCOUNTS.MANDT == T077S.MANDT
Short Key for a House Bank
  • Company Code
  • Short Key for a House Bank
  • Client
  • FAC_DART_Z3_CHARTOFACCOUNTS.COMPANYCODE == T012.BUKRS
  • FAC_DART_Z3_CHARTOFACCOUNTS.HOUSEBANK == T012.HBKID
  • FAC_DART_Z3_CHARTOFACCOUNTS.MANDT == T012.MANDT
ID for Account Details
  • Company Code
  • Short Key for a House Bank
  • ID for Account Details
  • Client
  • FAC_DART_Z3_CHARTOFACCOUNTS.COMPANYCODE == T012K.BUKRS
  • FAC_DART_Z3_CHARTOFACCOUNTS.HOUSEBANK == T012K.HBKID
  • FAC_DART_Z3_CHARTOFACCOUNTS.HOUSEBANKACCOUNT == T012K.HKTID
  • FAC_DART_Z3_CHARTOFACCOUNTS.MANDT == T012K.MANDT
Interest Indicator
  • Client
  • Interest Indicator
  • FAC_DART_Z3_CHARTOFACCOUNTS.MANDT == T056.MANDT
  • FAC_DART_Z3_CHARTOFACCOUNTS.INTERESTCALCULATIONCODE == T056.VZSKZ
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • FAC_DART_Z3_CHARTOFACCOUNTS.PARTNERCOMPANY == T880.RCOMP
  • FAC_DART_Z3_CHARTOFACCOUNTS.MANDT == T880.MANDT
Unit of Measurement
  • Unit of Measurement
  • Client
  • FAC_DART_Z3_CHARTOFACCOUNTS.UNITOFMEASURE == T006.MSEHI
  • FAC_DART_Z3_CHARTOFACCOUNTS.MANDT == T006.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Key for Exchange Rate Differences in Foreign Currency Accts
  • ?
  • Key for Exchange Rate Differences in Foreign Currency Accts
  • Chart of Accounts
  • Client
  • FAC_DART_Z3_CHARTOFACCOUNTS.[column in domain "BWBER"] == T030S.CURTP
  • FAC_DART_Z3_CHARTOFACCOUNTS.EXCHRATEDIFFERENCESACCOUNTDETN == T030S.KDFSL
  • FAC_DART_Z3_CHARTOFACCOUNTS.CHARTOFACCOUNTS == T030S.KTOPL
  • FAC_DART_Z3_CHARTOFACCOUNTS.MANDT == T030S.MANDT