SAP Table SKB1
G/L account master (company code)
What Is the SAP SKB1 Table?
SKB1 is a financial accounting table that stores General Ledger Company Code Master Data. It contains the detailed control information, how the general ledger account controls the company code with account management, posting controls, open-item management, line item display, field status, and other company-code dependent control settings.
Consultants and users use SKB1 table to analyze the company code details of General Ledger Account.
G/L account information is stored in different tables in SAP:
Quick overview
| SAP table | SKB1 |
|---|---|
| Short description | G/L account master (company code) |
| Table type | Transparent table |
| Primary key | MANDT (Client), BUKRS (Company Code), SAKNR (G/L Account Number) |
| Client-dependent | Yes |
| Commonly used fields | WAERS (Account Currency), FSTAG (Field status group), XOPVW (Indicator: Open Item Management?) |
Important fields explained
| Field | SAP field description | What this field means |
|---|---|---|
BUKRS |
Company Code | Identifies the company code to which the G/L account is assigned. |
SAKNR |
G/L Account Number | Identifies the G/L account number. |
FSTAG |
Field status group | Identifies the field status group assigned to the G/L account. The group controls which fields are available during document entry. |
MITKZ |
Account Is Reconciliation Account | Specifies the reconciliation account type, such as assets, customers, or vendors. |
ZUAWA |
Key for sorting according to assignment numbers | Identifies the sort key that determines how document line items are sorted for display. |
XOPVW |
Indicator: Open Item Management? | Indicates whether open-item management is active for the G/L account. |
At a glance
- Module
- Financial Accounting FI
- Application component
- GENERAL LEDGER ACCOUNTING FI-GL
- Subcomponent
- BASIC FUNCTIONS FI-GL-GL
- Specific component
- MASTER DATA FI-GL-GL-N
Technical details
- Delivery class
- C (Customizing, maintenance only by customer, no SAP imports)
- Data class
- APPL0 (Master Data, Transparent Tables)
- Package
- G/L Accounts (FBS)
Primary key fields
| Field | Description | Data element | Type | Length |
|---|---|---|---|---|
MANDT
|
Client | MANDT | CLNT | 3 |
BUKRS
|
Company Code | BUKRS | CHAR | 4 |
SAKNR
|
G/L Account Number | SAKNR | CHAR | 10 |
Table fields
45 fields
45 fields
| Field | Description | Data element | Domain | Type | Length | Decimals | Check table |
|---|---|---|---|---|---|---|---|
MANDT
Key
|
Client | MANDT | MANDT | CLNT | 3 | — | T000 |
BUKRS
Key
|
Company Code | BUKRS | BUKRS | CHAR | 4 | — | T001 |
SAKNR
Key
|
G/L Account Number | SAKNR | SAKNR | CHAR | 10 | — | SKA1 |
BEGRU
|
Authorization Group | BRGRU | BRGRU | CHAR | 4 | — | |
BUSAB
|
Accounting Clerk Abbreviation | BUSAB | BUSAB | CHAR | 2 | — | T001S |
DATLZ
|
Date of Last Interest Calculation Run | DATLZ | DATUM | DATS | 8 | — | |
ERDAT
|
Record Created On | ERDAT_RF | DATUM | DATS | 8 | — | |
ERNAM
|
Name of Person who Created the Object | ERNAM_RF | USNAM | CHAR | 12 | — | |
FDGRV
|
Planning Group | FDGRV | FDGRP | CHAR | 10 | — | T035 |
FDLEV
|
Planning Level | FDLEV | FDLEV | CHAR | 2 | — | T036 |
FIPLS
|
Financial Budget Item | FIPLS | FIPLS | NUMC | 3 | — | |
FSTAG
|
Field status group | FSTAG | FSTAG | CHAR | 4 | — | T004F |
HBKID
|
Short Key for a House Bank | HBKID | HBKID | CHAR | 5 | — | T012 |
HKTID
|
ID for Account Details | HKTID | HKTID | CHAR | 5 | — | T012K |
KDFSL
|
Key for Exchange Rate Differences in Foreign Currency Accts | KDFSL | KDFSL | CHAR | 4 | — | T030S |
MITKZ
|
Account Is Reconciliation Account | MITKZ | MITKZ | CHAR | 1 | — | |
MWSKZ
|
Tax Category in Account Master Record | SMWSK | SMWSK | CHAR | 2 | — | |
STEXT
|
G/L Account Additional Text | STEXT_SKB1 | TEXT50 | CHAR | 50 | — | |
VZSKZ
|
Interest Indicator | VZSKZ | VZSKZ | CHAR | 2 | — | T056 |
WAERS
|
Account Currency | WAERS_SKB1 | WAERS | CUKY | 5 | — | TCURC |
WMETH
|
Indicator: Account Managed in External System | WMETH | WMETH | CHAR | 2 | — | |
XGKON
|
Cash Receipt Account / Cash Disbursement Account | XGKON | XFELD | CHAR | 1 | — | |
XINTB
|
Indicator: Is Account only Posted to Automatically? | XINTB | XFELD | CHAR | 1 | — | |
XKRES
|
Indicator: Can Line Items Be Displayed by Account? | XKRES | XFELD | CHAR | 1 | — | |
XLOEB
|
Indicator: Account Marked for Deletion? | XLOEV | XFELD | CHAR | 1 | — | |
XNKON
|
Indicator: Supplement for Automatic Postings ? | XNKON | XFELD | CHAR | 1 | — | |
XOPVW
|
Indicator: Open Item Management? | XOPVW | XFELD | CHAR | 1 | — | |
XSPEB
|
Indicator: Is Account Blocked for Posting? | XSPEB | XFELD | CHAR | 1 | — | |
ZINDT
|
Key Date of Last Interest Calculation | DZINDT | DATUM | DATS | 8 | — | |
ZINRT
|
Interest Calculation Frequency in Months | DZINRT | ZINRT | NUMC | 2 | — | |
ZUAWA
|
Key for sorting according to assignment numbers | DZUAWA | ZUAWA | CHAR | 3 | — | TZUN |
ALTKT
|
Alternative Account Number in Company Code | ALTKT_SKB1 | SAKNR | CHAR | 10 | — | |
XMITK
|
Indicator: Reconcil.Acct Ready for Input at Time of Posting? | XMITK | XFELD | CHAR | 1 | — | |
RECID
|
Recovery Indicator | JV_RECIND | JV_RECIND | CHAR | 2 | — | T8JJ |
FIPOS
|
Commitment Item | FIPOS | FIPOS | CHAR | 14 | — | |
XMWNO
|
Indicator: Tax code is not a required field | XMWNO | XFELD | CHAR | 1 | — | |
XSALH
|
Manage Balances in Local Currency Only (Indicator) | XSALH | XFELD | CHAR | 1 | — | |
BEWGP
|
Valuation Group | BEWGP | CHAR10 | CHAR | 10 | — | |
INFKY
|
Inflation Key | J_1AIFSKS | J_1AIFSKS | CHAR | 8 | — | J_1AINFSKS |
TOGRU
|
Tolerance Group for G/L Accounts | TOGRU_S | TOGRU_S | CHAR | 4 | — | T043S |
XLGCLR
|
Open Item Management by Ledger Group | XLGCLR | XFELD | CHAR | 1 | — | |
X_UJ_CLR
|
Extended Open Item Management | X_UJ_CLR | BOOLE | CHAR | 1 | — | |
MCAKEY
|
MCA Key | GLE_DTE_MCA_MCAKEY | GLE_MCA_MCAKEY | CHAR | 5 | — | GLE_MCA_TMCAKEY |
COCHANGED
|
Controlling area data changed | FINS_SKB1_COCHANGED | CHAR1 | CHAR | 1 | — | |
LAST_CHANGED_TS
|
UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 |
No fields match the selected filters.
SAP SKB1 Table Availability
| SAP product | Verified release/system | Table availability | Verified on |
|---|---|---|---|
| SAP S/4HANA | 2023 - On-Premise - Initial Shipment Stack | Available |
Related SAP Tables
| Table | Description | Common Key Fields with SKB1 |
|---|---|---|
| SKA1 | G/L Account Master (Chart of Accounts) | MANDT, SAKNR |
| SKAT | G/L Account Master Record (Chart of Accounts: Description) | MANDT, SAKNR |
| T001 | Company Codes | MANDT, BUKRS |
| BSEG | Accounting Document Segment | MANDT, BUKRS |
| T012K | House Bank Accounts | MANDT, BUKRS |
Fields marked as primary keys in both tables. Additional fields or filters may be needed when joining records.
Editorial and verification
- Content editor
- ERPSAP Content Team
- Technical reviewer
- ERPSAP Technical Review Team
- Verified against
- SAP S/4HANA 2023 On-Premise system
- Last updated
- October 4, 2026
The information on this SAP SKB1 table page is based on the verified SAP S/4HANA 2023 on-premise system identified above. Table definitions, fields, and availability may differ across SAP releases and customer-specific systems.