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
A Assets
D Customers
K Vendors
V Contract accounts receivable
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
NULL Standard account management
X Account managed in another system
XGKON Cash receipt account / cash disbursement account XGKON CHAR 1 0
X Yes
NULL No
XINTB Indicator: Is account only posted to automatically? XINTB CHAR 1 0
X Yes
NULL No
XKRES Indicator: Can Line Items Be Displayed by Account? XKRES CHAR 1 0
X Yes
NULL No
XLOEB Indicator: Account marked for deletion? XLOEV CHAR 1 0
X Yes
NULL No
XNKON Indicator: Supplement for automatic postings ? XNKON CHAR 1 0
X Yes
NULL No
XOPVW Indicator: Open item management? XOPVW CHAR 1 0
X Yes
NULL No
XSPEB Indicator: Is Account Blocked for Posting? XSPEB CHAR 1 0
X Yes
NULL No
ZINDT Key date of the last interest calculation DZINDT DATS 8 0
ZINRT Interest calculation frequency in months DZINRT NUMC 2 0
01 1 month
02 2 months
03 3 months
04 4 months
05 5 months
06 6 months
07 7 months
08 8 months
09 9 months
10 10 months
11 11 months
12 12 months
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
X Yes
NULL No
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
X Yes
NULL No
XSALH Indicator: Only Manage Balances in Local Currency XSALH CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
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