I_Glaccountwithaccountcurrency

GlAccount with account currency | view: IGLACCTCY | ATTR | Extraction: Full only | Component: SAP Cash Management
Tables used: T001, TKA02, SKB1
Column Name Description
GLAccount FK G/L Account Number
CompanyCode FK Company Code
Column Name Description
Column Name Description
Column Name Description
LastInterestCalcRunDate Date of Last Interest Calculation Run
CreationDate Date on which the Record Was Created
InterestCalculationDate Key Date of Last Interest Calculation
Column Name Description
ReconciliationAccountType Account is Reconciliation Account Show values
ReconciliationAcctIsChangeable Indicator: Reconcil.Acct Ready for Input at Time of Posting? Show values
IsManagedExternally Indicator: account managed in external system Show values
IsAutomaticallyPosted Indicator: Is Account only Posted to Automatically? Show values
LineItemDisplayIsEnabled Indicator: Can Line Items Be Displayed by 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
AccountIsBlockedForPosting Indicator: Is Account Blocked for Posting? Show values
AccountIsMarkedForDeletion Indicator: Account Marked for Deletion? Show values
ClearingIsLedgerGroupSpecific Open Item Management by Ledger Group Show values
IsCashFlowAccount Cash Receipt Account / Cash Disbursement Account Show values
Column Name Description Domain name
AuthorizationGroup Authorization Group BRGRU
CreatedByUser Name of Person who Created the Object USNAM
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
TaxCategory Tax Category in Account Master Record SMWSK
AlternativeGLAccount Alternative Account Number in Company Code SAKNR
CommitmentItem Commitment Item FIPOS
ValuationGroup Valuation Group CHAR10
Master Data Relations Join Conditions
Accounting Clerk Abbreviation
  • Company Code
  • Accounting Clerk Abbreviation
  • Client
  • I_GLACCOUNTWITHACCOUNTCURRENCY.COMPANYCODE == T001S.BUKRS
  • I_GLACCOUNTWITHACCOUNTCURRENCY.ACCOUNTINGCLERK == T001S.BUSAB
  • I_GLACCOUNTWITHACCOUNTCURRENCY.MANDT == T001S.MANDT
Key for sorting according to assignment numbers I_GLACCOUNTWITHACCOUNTCURRENCY.ACCTGDOCITMDISPLAYSEQUENCERULE == TZUN.ZUAWA
Tolerance Group for G/L Accounts
  • Company Code
  • Tolerance Group for G/L Accounts
  • Client
  • I_GLACCOUNTWITHACCOUNTCURRENCY.COMPANYCODE == T043S.BUKRS
  • I_GLACCOUNTWITHACCOUNTCURRENCY.APARTOLERANCEGROUP == T043S.TOGRU
  • I_GLACCOUNTWITHACCOUNTCURRENCY.MANDT == T043S.MANDT
Planning Group
  • Client
  • Planning Group
  • I_GLACCOUNTWITHACCOUNTCURRENCY.MANDT == T035.MANDT
  • I_GLACCOUNTWITHACCOUNTCURRENCY.CASHPLANNINGGROUP == T035.GRUPP
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_GLACCOUNTWITHACCOUNTCURRENCY.CHARTOFACCOUNTS == T004.KTOPL
  • I_GLACCOUNTWITHACCOUNTCURRENCY.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • I_GLACCOUNTWITHACCOUNTCURRENCY.COMPANYCODE == T001.BUKRS
  • I_GLACCOUNTWITHACCOUNTCURRENCY.MANDT == T001.MANDT
Field status group
  • ?
  • Client
  • Field status group
  • I_GLACCOUNTWITHACCOUNTCURRENCY.[column in domain "FSTVA"] == T004F.BUKRS
  • I_GLACCOUNTWITHACCOUNTCURRENCY.MANDT == T004F.MANDT
  • I_GLACCOUNTWITHACCOUNTCURRENCY.FIELDSTATUSGROUP == T004F.FSTAG
G/L Account Number
  • G/L Account Number
  • Chart of Accounts
  • Client
  • I_GLACCOUNTWITHACCOUNTCURRENCY.GLACCOUNT == SKA1.SAKNR
  • I_GLACCOUNTWITHACCOUNTCURRENCY.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_GLACCOUNTWITHACCOUNTCURRENCY.MANDT == SKA1.MANDT
Account Currency
  • Account Currency
  • Client
  • I_GLACCOUNTWITHACCOUNTCURRENCY.GLACCOUNTCURRENCY == TCURC.WAERS
  • I_GLACCOUNTWITHACCOUNTCURRENCY.MANDT == TCURC.MANDT
Inflation Key
  • Inflation Key
  • ?
  • Client
  • I_GLACCOUNTWITHACCOUNTCURRENCY.GLACCTINFLATIONKEY == J_1AINFSKS.J_1AIFSKS
  • I_GLACCOUNTWITHACCOUNTCURRENCY.[column in domain "LAND1"] == J_1AINFSKS.LAND1
  • I_GLACCOUNTWITHACCOUNTCURRENCY.MANDT == J_1AINFSKS.MANDT
Short Key for a House Bank
  • Company Code
  • Short Key for a House Bank
  • Client
  • I_GLACCOUNTWITHACCOUNTCURRENCY.COMPANYCODE == T012.BUKRS
  • I_GLACCOUNTWITHACCOUNTCURRENCY.HOUSEBANK == T012.HBKID
  • I_GLACCOUNTWITHACCOUNTCURRENCY.MANDT == T012.MANDT
ID for Account Details
  • Company Code
  • Short Key for a House Bank
  • ID for Account Details
  • Client
  • I_GLACCOUNTWITHACCOUNTCURRENCY.COMPANYCODE == T012K.BUKRS
  • I_GLACCOUNTWITHACCOUNTCURRENCY.HOUSEBANK == T012K.HBKID
  • I_GLACCOUNTWITHACCOUNTCURRENCY.HOUSEBANKACCOUNT == T012K.HKTID
  • I_GLACCOUNTWITHACCOUNTCURRENCY.MANDT == T012K.MANDT
Interest Indicator
  • Interest Indicator
  • Client
  • I_GLACCOUNTWITHACCOUNTCURRENCY.INTERESTCALCULATIONCODE == T056.VZSKZ
  • I_GLACCOUNTWITHACCOUNTCURRENCY.MANDT == T056.MANDT
Recovery Indicator
  • Company Code
  • Client
  • Recovery Indicator
  • I_GLACCOUNTWITHACCOUNTCURRENCY.COMPANYCODE == T8JJ.BUKRS
  • I_GLACCOUNTWITHACCOUNTCURRENCY.MANDT == T8JJ.MANDT
  • I_GLACCOUNTWITHACCOUNTCURRENCY.JOINTVENTURERECOVERYCODE == T8JJ.RECID
MCA Key I_GLACCOUNTWITHACCOUNTCURRENCY.MULTICURRENCYACCOUNTINGCODE == GLE_MCA_TMCAKEY.MANDT
Planning Level
  • Planning Level
  • Client
  • I_GLACCOUNTWITHACCOUNTCURRENCY.PLANNINGLEVEL == T036.EBENE
  • I_GLACCOUNTWITHACCOUNTCURRENCY.MANDT == T036.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Key for Exchange Rate Differences in Foreign Currency Accts
  • ?
  • Chart of Accounts
  • Client
  • Key for Exchange Rate Differences in Foreign Currency Accts
  • I_GLACCOUNTWITHACCOUNTCURRENCY.[column in domain "BWBER"] == T030S.CURTP
  • I_GLACCOUNTWITHACCOUNTCURRENCY.CHARTOFACCOUNTS == T030S.KTOPL
  • I_GLACCOUNTWITHACCOUNTCURRENCY.MANDT == T030S.MANDT
  • I_GLACCOUNTWITHACCOUNTCURRENCY.EXCHRATEDIFFERENCESACCOUNTDETN == T030S.KDFSL