SAP Table SKB1
G/L account master (company code)
SKB1 (G/L account master (company code)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link SKB1 to other SAP tables.
SKB1 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||||||||||||||
|
BUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||
|
SAKNR
G/L Account Number
|
SAKNR | SKA1 |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||
|
BEGRU
Authorization Group
|
BRGRU |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||||
|
BUSAB
Accounting clerk
|
BUSAB | T001S |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||
|
DATLZ
Date of the last interest calculation run
|
DATLZ |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||
|
ERDAT
Date on which the Record Was Created
|
ERDAT_RF |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||
|
ERNAM
Name of Person who Created the Object
|
ERNAM_RF |
CHAR
|
12 | 0 | ||||||||||||||||||||||||||||
|
FDGRV
Planning group
|
FDGRV | T035 |
CHAR
|
10 | 0 | |||||||||||||||||||||||||||
|
FDLEV
Planning level
|
FDLEV | T036 |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||
|
FIPLS
Financial Budget Item
|
FIPLS |
NUMC
|
3 | 0 | ||||||||||||||||||||||||||||
|
FSTAG
Field status group
|
FSTAG | T004F |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||
|
HBKID
Short Key for a House Bank
|
HBKID | T012 |
CHAR
|
5 | 0 | |||||||||||||||||||||||||||
|
HKTID
ID for account details
|
HKTID | T012K |
CHAR
|
5 | 0 | |||||||||||||||||||||||||||
|
KDFSL
Key for Exchange Rate Differences in Foreign Currency Accts
|
KDFSL | T030S |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||
|
MITKZ
Account is reconciliation account
|
MITKZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
MWSKZ
Tax Category in Account Master Record
|
SMWSK |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||||
|
STEXT
G/L account additional text
|
STEXT_SKB1 |
CHAR
|
50 | 0 | ||||||||||||||||||||||||||||
|
VZSKZ
Interest calculation indicator
|
VZSKZ | T056 |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||
|
WAERS
Account currency
|
WAERS_SKB1 | TCURC |
CUKY
|
5 | 0 | |||||||||||||||||||||||||||
|
WMETH
Indicator: account managed in external system
|
WMETH |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
XGKON
Cash receipt account / cash disbursement account
|
XGKON |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
XINTB
Indicator: Is account only posted to automatically?
|
XINTB |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
XKRES
Indicator: Can Line Items Be Displayed by Account?
|
XKRES |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
XLOEB
Indicator: Account marked for deletion?
|
XLOEV |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
XNKON
Indicator: Supplement for automatic postings ?
|
XNKON |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
XOPVW
Indicator: Open item management?
|
XOPVW |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
XSPEB
Indicator: Is Account Blocked for Posting?
|
XSPEB |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
ZINDT
Key date of the last interest calculation
|
DZINDT |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||
|
ZINRT
Interest calculation frequency in months
|
DZINRT |
NUMC
|
2 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
ZUAWA
Key for sorting according to assignment numbers
|
DZUAWA | TZUN |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||
|
ALTKT
Alternative account number in company code
|
ALTKT_SKB1 |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||||
|
XMITK
Indicator: Reconcil.acct ready for input at time of posting?
|
XMITK |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
RECID
Recovery Indicator
|
JV_RECIND | T8JJ |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||
|
FIPOS
Commitment Item
|
FIPOS |
CHAR
|
14 | 0 | ||||||||||||||||||||||||||||
|
XMWNO
Indicator: Tax code is not a required field
|
XMWNO |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
XSALH
Indicator: Only Manage Balances in Local Currency
|
XSALH |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
BEWGP
Valuation Group
|
BEWGP |
CHAR
|
10 | 0 | ||||||||||||||||||||||||||||
|
INFKY
Inflation Key
|
J_1AIFSKS | J_1AINFSKS |
CHAR
|
8 | 0 | |||||||||||||||||||||||||||
|
TOGRU
Tolerance Group for G/L Accounts
|
TOGRU_S | T043S |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||
|
XLGCLR
Clearing Specific to Ledger Groups
|
XLGCLR |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
MCAKEY
MCA Key
|
GLE_DTE_MCA_MCAKEY | GLE_MCA_TMCAKEY |
CHAR
|
5 | 0 | |||||||||||||||||||||||||||
SKB1 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| SKB1 | BUKRS | SKB1 | MANDT |
T001
Company Codes
|
MANDT |
| SKB1 | BUKRS | SKB1 | BUKRS |
T001
Company Codes
|
BUKRS |
| SKB1 | BUSAB | SKB1 | MANDT |
T001S
Accounting Clerks
|
MANDT |
| SKB1 | BUSAB | SKB1 | BUKRS |
T001S
Accounting Clerks
|
BUKRS |
| SKB1 | BUSAB | SKB1 | BUSAB |
T001S
Accounting Clerks
|
BUSAB |
| SKB1 | FDGRV | SKB1 | MANDT |
T035
Planning groups
|
MANDT |
| SKB1 | FDGRV | SKB1 | FDGRV |
T035
Planning groups
|
GRUPP |
| SKB1 | FDLEV | SKB1 | MANDT |
T036
Planning levels
|
MANDT |
| SKB1 | FDLEV | SKB1 | FDLEV |
T036
Planning levels
|
EBENE |
| SKB1 | FSTAG | SKB1 | FSTAG |
T004F
Field status definition groups
|
FSTAG |
| SKB1 | FSTAG | SKB1 | MANDT |
T004F
Field status definition groups
|
MANDT |
| SKB1 | FSTAG | T001 | FSTVA |
T004F
Field status definition groups
|
BUKRS |
| SKB1 | HBKID | SKB1 | MANDT |
T012
House Banks
|
MANDT |
| SKB1 | HBKID | SKB1 | BUKRS |
T012
House Banks
|
BUKRS |
| SKB1 | HBKID | SKB1 | HBKID |
T012
House Banks
|
HBKID |
| SKB1 | HKTID | SKB1 | HBKID |
T012K
House Bank Accounts
|
HBKID |
| SKB1 | HKTID | SKB1 | HKTID |
T012K
House Bank Accounts
|
HKTID |
| SKB1 | HKTID | SKB1 | MANDT |
T012K
House Bank Accounts
|
MANDT |
| SKB1 | HKTID | SKB1 | BUKRS |
T012K
House Bank Accounts
|
BUKRS |
| SKB1 | INFKY | SKB1 | MANDT |
J_1AINFSKS
Inflation Keys - G/L Account
|
MANDT |
| SKB1 | INFKY | T001 | LAND1 |
J_1AINFSKS
Inflation Keys - G/L Account
|
LAND1 |
| SKB1 | INFKY | SKB1 | INFKY |
J_1AINFSKS
Inflation Keys - G/L Account
|
J_1AIFSKS |
| SKB1 | KDFSL | * |
T030S
Accts for Foreign Currency Assets Exchange Rate Differences
|
CURTP | |
| SKB1 | KDFSL | SKB1 | MANDT |
T030S
Accts for Foreign Currency Assets Exchange Rate Differences
|
MANDT |
| SKB1 | KDFSL | SKA1 | KTOPL |
T030S
Accts for Foreign Currency Assets Exchange Rate Differences
|
KTOPL |
| SKB1 | KDFSL | SKB1 | KDFSL |
T030S
Accts for Foreign Currency Assets Exchange Rate Differences
|
KDFSL |
| SKB1 | MANDT | SKB1 | MANDT |
T000
Clients
|
MANDT |
| SKB1 | MCAKEY | SKB1 | MANDT |
GLE_MCA_TMCAKEY
Key for assigning MCA relevant attributs to SKB1 accounts
|
.INCLUDE |
| SKB1 | MCAKEY | SKB1 | MCAKEY |
GLE_MCA_TMCAKEY
Key for assigning MCA relevant attributs to SKB1 accounts
|
MANDT |
| SKB1 | RECID | SKB1 | BUKRS |
T8JJ
Recovery Indicator
|
BUKRS |
| SKB1 | RECID | SKB1 | RECID |
T8JJ
Recovery Indicator
|
RECID |
| SKB1 | RECID | SKB1 | MANDT |
T8JJ
Recovery Indicator
|
MANDT |
| SKB1 | SAKNR | T001 | KTOPL |
SKA1
G/L Account Master (Chart of Accounts)
|
KTOPL |
| SKB1 | SAKNR | SKB1 | SAKNR |
SKA1
G/L Account Master (Chart of Accounts)
|
SAKNR |
| SKB1 | SAKNR | SKB1 | MANDT |
SKA1
G/L Account Master (Chart of Accounts)
|
MANDT |
| SKB1 | TOGRU | SKB1 | MANDT |
T043S
Tolerances for Groups of G/L Accounts
|
MANDT |
| SKB1 | TOGRU | SKB1 | BUKRS |
T043S
Tolerances for Groups of G/L Accounts
|
BUKRS |
| SKB1 | TOGRU | SKB1 | TOGRU |
T043S
Tolerances for Groups of G/L Accounts
|
TOGRU |
| SKB1 | VZSKZ | SKB1 | MANDT |
T056
Interest settlement
|
MANDT |
| SKB1 | VZSKZ | SKB1 | VZSKZ |
T056
Interest settlement
|
VZSKZ |
| SKB1 | WAERS | SKB1 | MANDT |
TCURC
Currency Codes
|
MANDT |
| SKB1 | WAERS | SKB1 | WAERS |
TCURC
Currency Codes
|
WAERS |
| SKB1 | ZUAWA | SKB1 | ZUAWA |
TZUN
Rules for 'Allocation' Field Layout
|
ZUAWA |