1. Home
  2. Resources
  3. SAP Tables
  4. SKM1 - Sample G/L accounts

SAP Table SKM1

Sample G/L accounts

SKM1 (Sample G/L accounts) 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 SKM1 to other SAP tables.

SKM1 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
KTOPL Chart of Accounts KTOPL T004 CHAR 4 0
MUSTR Number of the sample account MUSTR CHAR 10 0
BEGRU Authorization Group BRGRU CHAR 4 0
BUSAB Accounting clerk BUSAB CHAR 2 0
DATLZ Date of the last interest calculation run DATLZ DATS 8 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
FDGRV Planning group FDGRV T035 CHAR 10 0
FDLEV Planning level FDLEV CHAR 2 0
FIPLS Financial Budget Item FIPLS NUMC 3 0
FSTAG Field status group FSTAG CHAR 4 0
HBKID Short Key for a House Bank HBKID CHAR 5 0
HKTID ID for account details HKTID 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 Currency Key WAERS 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
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
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 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 CHAR 8 0
XLGCLR Clearing Specific to Ledger Groups XLGCLR CHAR 1 0
X Yes
NULL No

SKM1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SKM1 FDGRV SKM1 MANDT T035 Planning groups MANDT
SKM1 FDGRV SKM1 FDGRV T035 Planning groups GRUPP
SKM1 KDFSL * T030S Accts for Foreign Currency Assets Exchange Rate Differences CURTP
SKM1 KDFSL SKM1 MANDT T030S Accts for Foreign Currency Assets Exchange Rate Differences MANDT
SKM1 KDFSL SKM1 KTOPL T030S Accts for Foreign Currency Assets Exchange Rate Differences KTOPL
SKM1 KDFSL SKM1 KDFSL T030S Accts for Foreign Currency Assets Exchange Rate Differences KDFSL
SKM1 KTOPL SKM1 MANDT T004 Directory of Charts of Accounts MANDT
SKM1 KTOPL SKM1 KTOPL T004 Directory of Charts of Accounts KTOPL
SKM1 MANDT SKM1 MANDT T000 Clients MANDT
SKM1 VZSKZ SKM1 MANDT T056 Interest settlement MANDT
SKM1 VZSKZ SKM1 VZSKZ T056 Interest settlement VZSKZ
SKM1 WAERS SKM1 MANDT TCURC Currency Codes MANDT
SKM1 WAERS SKM1 WAERS TCURC Currency Codes WAERS
SKM1 ZUAWA SKM1 ZUAWA TZUN Rules for 'Allocation' Field Layout ZUAWA