fisvd_glacct_all

Master Data of GL Accounts in Chart of Accounts | view: FISV_GLACCT_ALL | Extraction: Not supported | Component: Information System
Tables used: SKAT, T004T, TFKBT, T005, T005T, SKA1, T004, T030, SKB1, T001, TKA02, TCURC, TCURT, TCURX
Column Name Description
ktopl FK Chart of Accounts
saknr G/L Account Number
Column Name Description
Column Name Description
Column Name Description
erdat Date on which the Record Was Created
erdat_skb1 Date on which the Record Was Created
datlz Date of Last Interest Calculation Run
zindt Key Date of Last Interest Calculation
Column Name Description
xbilk Indicator: Account is a balance sheet account? Show values
xloev Indicator: Account Marked for Deletion? Show values
xspea Indicator: Account Is Blocked for Creation ? Show values
xspeb Indicator: Is Account Blocked for Posting? Show values
xspep Indicator: Account Blocked for Planning ? Show values
mitkz Account is Reconciliation Account Show values
xkres Indicator: Can Line Items Be Displayed by Account? Show values
xopvw Indicator: Open Item Management? Show values
xspeb_skb1 Indicator: Is Account Blocked for Posting? Show values
xgkon Cash Receipt Account / Cash Disbursement Account Show values
xloeb Indicator: Account Marked for Deletion? Show values
xmitk Indicator: Reconcil.Acct Ready for Input at Time of Posting? Show values
xintb Indicator: Is Account only Posted to Automatically? Show values
xlgclr Open Item Management by Ledger Group Show values
wmeth Indicator: Account Managed in External System Show values
xnkon Indicator: Supplement for Automatic Postings ? Show values
xsalh Manage Balances in Local Currency Only (Indicator) Show values
zinrt Interest Calculation Frequency in Months Show values
xmwno Indicator: Tax code is not a required field Show values
Column Name Description Domain name
xplkt null
sakan G/L Account Number, Significant Length CHAR10
ernam Name of Person who Created the Object USNAM
gvtyp P&L statement account type CHAR2
altkt Alternative Account Number in Company Code SAKNR
butxt Name of Company Code or Company TEXT25
begru Authorization Group BRGRU
ernam_skb1 Name of Person who Created the Object USNAM
mwskz Tax Category in Account Master Record SMWSK
saknr_txt50 G/L Account Long Text TEXT50
bilkt_txt50 G/L Account Long Text TEXT50
altkt_txt50 G/L Account Long Text TEXT50
ktopl_name Chart of Accounts Description TEXT50
kktpl_name Chart of Accounts Description TEXT50
ktop2_name Chart of Accounts Description TEXT50
fkbtx Name of the functional area TEXT25
bewgp Valuation Group CHAR10
xunusd null
Master Data Relations Join Conditions
Group Account Number
  • Client
  • Group Chart of Accts
  • Group Account Number
  • FISVD_GLACCT_ALL.MANDT == SKA1.MANDT
  • FISVD_GLACCT_ALL.KKTPL == SKA1.KTOPL
  • FISVD_GLACCT_ALL.BILKT == SKA1.SAKNR
Company Code
  • Client
  • Company Code
  • FISVD_GLACCT_ALL.MANDT == T001.MANDT
  • FISVD_GLACCT_ALL.BUKRS == T001.BUKRS
Accounting Clerk Abbreviation
  • Client
  • Company Code
  • Accounting Clerk Abbreviation
  • FISVD_GLACCT_ALL.MANDT == T001S.MANDT
  • FISVD_GLACCT_ALL.BUKRS == T001S.BUKRS
  • FISVD_GLACCT_ALL.BUSAB == T001S.BUSAB
Planning Group
  • Client
  • Planning Group
  • FISVD_GLACCT_ALL.MANDT == T035.MANDT
  • FISVD_GLACCT_ALL.FDGRV == T035.GRUPP
Planning Level
  • Client
  • Planning Level
  • FISVD_GLACCT_ALL.MANDT == T036.MANDT
  • FISVD_GLACCT_ALL.FDLEV == T036.EBENE
Field status group
  • ?
  • Client
  • Field status group
  • FISVD_GLACCT_ALL.[column in domain "FSTVA"] == T004F.BUKRS
  • FISVD_GLACCT_ALL.MANDT == T004F.MANDT
  • FISVD_GLACCT_ALL.FSTAG == T004F.FSTAG
Functional Area
  • Client
  • Functional Area
  • FISVD_GLACCT_ALL.MANDT == TFKB.MANDT
  • FISVD_GLACCT_ALL.FUNC_AREA == TFKB.FKBER
Short Key for a House Bank
  • Client
  • Company Code
  • Short Key for a House Bank
  • FISVD_GLACCT_ALL.MANDT == T012.MANDT
  • FISVD_GLACCT_ALL.BUKRS == T012.BUKRS
  • FISVD_GLACCT_ALL.HBKID == T012.HBKID
ID for Account Details
  • Client
  • Company Code
  • Short Key for a House Bank
  • ID for Account Details
  • FISVD_GLACCT_ALL.MANDT == T012K.MANDT
  • FISVD_GLACCT_ALL.BUKRS == T012K.BUKRS
  • FISVD_GLACCT_ALL.HBKID == T012K.HBKID
  • FISVD_GLACCT_ALL.HKTID == T012K.HKTID
Inflation Key
  • Client
  • Country/Region Key
  • Inflation Key
Credit control area
  • Credit control area
  • Client
  • FISVD_GLACCT_ALL.KKBER == T014.KKBER
  • FISVD_GLACCT_ALL.MANDT == T014.MANDT
Group Chart of Accts
  • Client
  • Group Chart of Accts
  • FISVD_GLACCT_ALL.MANDT == T004.MANDT
  • FISVD_GLACCT_ALL.KKTPL == T004.KTOPL
G/L Account Number
  • G/L Account Number
  • Client
  • Chart of Accounts
  • FISVD_GLACCT_ALL.KONTS == SKA1.SAKNR
  • FISVD_GLACCT_ALL.MANDT == SKA1.MANDT
  • FISVD_GLACCT_ALL.KTOPL == SKA1.KTOPL
G/L Account Group
  • Client
  • Chart of Accounts
  • G/L Account Group
  • FISVD_GLACCT_ALL.MANDT == T077S.MANDT
  • FISVD_GLACCT_ALL.KTOPL == T077S.KTOPL
  • FISVD_GLACCT_ALL.KTOKS == T077S.KTOKS
Alternative Chart of Accounts
  • Client
  • Alternative Chart of Accounts
  • FISVD_GLACCT_ALL.MANDT == T004.MANDT
  • FISVD_GLACCT_ALL.KTOP2 == T004.KTOPL
Chart of Accounts
  • Client
  • Chart of Accounts
  • FISVD_GLACCT_ALL.MANDT == T004.MANDT
  • FISVD_GLACCT_ALL.KTOPL == T004.KTOPL
Country/Region Key
  • Client
  • Country/Region Key
  • FISVD_GLACCT_ALL.MANDT == T005.MANDT
  • FISVD_GLACCT_ALL.LAND1 == T005.LAND1
Number of the Sample Account
  • Client
  • Chart of Accounts
  • Number of the Sample Account
  • FISVD_GLACCT_ALL.MANDT == SKM1.MANDT
  • FISVD_GLACCT_ALL.KTOPL == SKM1.KTOPL
  • FISVD_GLACCT_ALL.MUSTR == SKM1.MUSTR
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • FISVD_GLACCT_ALL.MANDT == T009.MANDT
  • FISVD_GLACCT_ALL.PERIV == T009.PERIV
Tolerance Group for G/L Accounts
  • Client
  • Company Code
  • Tolerance Group for G/L Accounts
  • FISVD_GLACCT_ALL.MANDT == T043S.MANDT
  • FISVD_GLACCT_ALL.BUKRS == T043S.BUKRS
  • FISVD_GLACCT_ALL.TOGRU == T043S.TOGRU
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • FISVD_GLACCT_ALL.MANDT == T880.MANDT
  • FISVD_GLACCT_ALL.VBUND == T880.RCOMP
Interest Indicator
  • Client
  • Interest Indicator
  • FISVD_GLACCT_ALL.MANDT == T056.MANDT
  • FISVD_GLACCT_ALL.VZSKZ == T056.VZSKZ
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • FISVD_GLACCT_ALL.MANDT == TCURC.MANDT
  • FISVD_GLACCT_ALL.WAERS == TCURC.WAERS
  • FISVD_GLACCT_ALL.WAERS_SKB1 == TCURC.WAERS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • FISVD_GLACCT_ALL.MANDT == TCURC.MANDT
  • FISVD_GLACCT_ALL.WAERS == TCURC.WAERS
  • FISVD_GLACCT_ALL.WAERS_SKB1 == TCURC.WAERS
Key for sorting according to assignment numbers FISVD_GLACCT_ALL.ZUAWA == TZUN.ZUAWA
Other Relations | to Master Data Relations ↑ Join Conditions
Key for Exchange Rate Differences in Foreign Currency Accts
  • Client
  • Key for Exchange Rate Differences in Foreign Currency Accts
  • ?
  • Chart of Accounts
  • FISVD_GLACCT_ALL.MANDT == T030S.MANDT
  • FISVD_GLACCT_ALL.KDFSL == T030S.KDFSL
  • FISVD_GLACCT_ALL.[column in domain "BWBER"] == T030S.CURTP
  • FISVD_GLACCT_ALL.KTOPL == T030S.KTOPL