SKM1 SAP (Sample G/L accounts) Table details

Dictionary Type: Table
Description: Sample G/L accounts




ABAP Code to SELECT data from SKM1
Related tables to SKM1
Access table SKM1




Table field list including key, data, relationships and ABAP select examples

SKM1 is a standard SAP Table which is used to store Sample G/L accounts data and is available within R/3 SAP systems depending on the version and release level.

The SKM1 table consists of various fields, each holding specific information or linking keys about Sample G/L accounts data available in SAP. These include KTOPL (Chart of Accounts), MUSTR (Number of the sample account), BEGRU (Authorization Group), BUSAB (Accounting clerk).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)

Text table = SKMT


SAP SKM1 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
KTOPLChart of Accounts KTOPLCHAR4T004KTOPLKPLC_KTOPL
MUSTRNumber of the sample account MUSTRCHAR10ALPHAMUSTRMST
BEGRUAuthorization Group BRGRUCHAR4Assigned to domainBRGRU
BUSABAccounting clerk BUSABCHAR2Assigned to domainBUSAB
DATLZDate of the last interest calculation run DATLZDATS8DATUM
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
FDGRVPlanning group FDGRVCHAR10T035ALPHAFDGRP
FDLEVPlanning level FDLEVCHAR2Assigned to domainFDLEVFFE
FIPLSFinancial Budget Item FIPLSNUMC3FIPLS
FSTAGField status group FSTAGCHAR4Assigned to domainFSTAG
HBKIDShort Key for a House Bank HBKIDCHAR5Assigned to domainHBKID
HKTIDID for account details HKTIDCHAR5Assigned to domainHKTID
KDFSLKey for Exchange Rate Differences in Foreign Currency Accts KDFSLCHAR4T030SKDFSL
MITKZAccount is reconciliation account MITKZCHAR1MITKZ
MWSKZTax Category in Account Master Record SMWSKCHAR2SMWSK
STEXTG/L account additional text STEXT_SKB1CHAR50TEXT50
VZSKZInterest calculation indicator VZSKZCHAR2T056VZSKZ
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
WMETHIndicator: account managed in external system WMETHCHAR2WMETH
XGKONCash receipt account / cash disbursement account XGKONCHAR1XFELD
XINTBIndicator: Is account only posted to automatically? XINTBCHAR1XFELD
XKRESIndicator: Can Line Items Be Displayed by Account? XKRESCHAR1XFELD
XNKONIndicator: Supplement for automatic postings ? XNKONCHAR1XFELD
XOPVWIndicator: Open item management? XOPVWCHAR1XFELD
ZINDTKey date of the last interest calculation DZINDTDATS8DATUM
ZINRTInterest calculation frequency in months DZINRTNUMC2ZINRT
ZUAWAKey for sorting according to assignment numbers DZUAWACHAR3TZUNZUAWA
ALTKTAlternative account number in company code ALTKT_SKB1CHAR10Assigned to domainALPHASAKNR
XMITKIndicator: Reconcil.acct ready for input at time of posting? XMITKCHAR1XFELD
RECIDRecovery Indicator JV_RECINDCHAR2Assigned to domainALPHAJV_RECIND
FIPOSCommitment Item FIPOSCHAR14Assigned to domainFIPOSFIP
XMWNOIndicator: Tax code is not a required field XMWNOCHAR1XFELD
XSALHIndicator: Only Manage Balances in Local Currency XSALHCHAR1XFELD
BEWGPValuation Group BEWGPCHAR10CHAR10
INFKYInflation Key J_1AIFSKSCHAR8Assigned to domainJ_1AIFSKS
XLGCLRClearing Specific to Ledger Groups XLGCLRCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP table SKM1 using ABAP code

The following ABAP code Example will allow you to do a basic selection on SKM1 to SELECT all data from the table
DATA: WA_SKM1 TYPE SKM1.

SELECT SINGLE *
FROM SKM1
INTO CORRESPONDING FIELDS OF WA_SKM1
WHERE...

How to access SAP table SKM1

Within an ECC or HANA version of SAP you can also view further information about SKM1 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!