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 | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||||||||||||||||||||||
| 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 |
Possible values
|
||||||||||||||||||||||||||
| XGKON | Cash receipt account / cash disbursement account | XGKON | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| XINTB | Indicator: Is account only posted to automatically? | XINTB | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| XKRES | Indicator: Can Line Items Be Displayed by Account? | XKRES | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| XLOEB | Indicator: Account marked for deletion? | XLOEV | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| XNKON | Indicator: Supplement for automatic postings ? | XNKON | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| XOPVW | Indicator: Open item management? | XOPVW | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| XSPEB | Indicator: Is Account Blocked for Posting? | XSPEB | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| ZINDT | Key date of the last interest calculation | DZINDT | DATS | 8 | 0 | |||||||||||||||||||||||||||
| ZINRT | Interest calculation frequency in months | DZINRT | NUMC | 2 | 0 |
Possible values
|
||||||||||||||||||||||||||
| 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 |
Possible values
|
||||||||||||||||||||||||||
| 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 |
Possible values
|
||||||||||||||||||||||||||
| XSALH | Indicator: Only Manage Balances in Local Currency | XSALH | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
| 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 |
Possible values
|
||||||||||||||||||||||||||
| 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 | MANDT | T004F | Field status definition groups | MANDT |
| SKB1 | FSTAG | T001 | FSTVA | T004F | Field status definition groups | BUKRS |
| SKB1 | FSTAG | SKB1 | FSTAG | T004F | Field status definition groups | FSTAG |
| SKB1 | HBKID | SKB1 | HBKID | T012 | House Banks | HBKID |
| SKB1 | HBKID | SKB1 | MANDT | T012 | House Banks | MANDT |
| SKB1 | HBKID | SKB1 | BUKRS | T012 | House Banks | BUKRS |
| SKB1 | HKTID | SKB1 | MANDT | T012K | House Bank Accounts | MANDT |
| SKB1 | HKTID | SKB1 | BUKRS | T012K | House Bank Accounts | BUKRS |
| SKB1 | HKTID | SKB1 | HBKID | T012K | House Bank Accounts | HBKID |
| SKB1 | HKTID | SKB1 | HKTID | T012K | House Bank Accounts | HKTID |
| 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 | INFKY | SKB1 | MANDT | J_1AINFSKS | Inflation Keys - G/L Account | MANDT |
| 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 | KDFSL | * | T030S | Accts for Foreign Currency Assets Exchange Rate Differences | CURTP | |
| 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 | MANDT | T8JJ | Recovery Indicator | MANDT |
| SKB1 | RECID | SKB1 | BUKRS | T8JJ | Recovery Indicator | BUKRS |
| SKB1 | RECID | SKB1 | RECID | T8JJ | Recovery Indicator | RECID |
| SKB1 | SAKNR | SKB1 | MANDT | SKA1 | G/L Account Master (Chart of Accounts) | 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 | 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 |
