SAP ABAP Table SKM1 (Sample G/L accounts)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FBS (Package) G/L Accounts

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SKM1	Table Relationship Diagram
Short Description	Sample G/L accounts

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	KTOPL	☑	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	T004
3	MUSTR	☑	MUSTR	MUSTR	CHAR	10	0	Number of the sample account
4	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	*
5	BUSAB	☐	BUSAB	BUSAB	CHAR	2	0	Accounting clerk	*
6	DATLZ	☐	DATLZ	DATUM	DATS	8	0	Date of the last interest calculation run
7	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
8	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
9	FDGRV	☐	FDGRV	FDGRP	CHAR	10	0	Planning group	T035
10	FDLEV	☐	FDLEV	FDLEV	CHAR	2	0	Planning Level	*
11	FIPLS	☐	FIPLS	FIPLS	NUMC	3	0	Financial Budget Item
12	FSTAG	☐	FSTAG	FSTAG	CHAR	4	0	Field status group	*
13	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	*
14	HKTID	☐	HKTID	HKTID	CHAR	5	0	ID for account details	*
15	KDFSL	☐	KDFSL	KDFSL	CHAR	4	0	Key for Exchange Rate Differences in Foreign Currency Accts	T030S
16	MITKZ	☐	MITKZ	MITKZ	CHAR	1	0	Account is reconciliation account
17	MWSKZ	☐	SMWSK	SMWSK	CHAR	2	0	Tax Category in Account Master Record
18	STEXT	☐	STEXT_SKB1	TEXT50	CHAR	50	0	G/L account additional text
19	VZSKZ	☐	VZSKZ	VZSKZ	CHAR	2	0	Interest calculation indicator	T056
20	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
21	WMETH	☐	WMETH	WMETH	CHAR	2	0	Indicator: account managed in external system
22	XGKON	☐	XGKON	XFELD	CHAR	1	0	Cash receipt account / cash disbursement account
23	XINTB	☐	XINTB	XFELD	CHAR	1	0	Indicator: Is account only posted to automatically?
24	XKRES	☐	XKRES	XFELD	CHAR	1	0	Indicator: Can Line Items Be Displayed by Account?
25	XNKON	☐	XNKON	XFELD	CHAR	1	0	Indicator: Supplement for automatic postings ?
26	XOPVW	☐	XOPVW	XFELD	CHAR	1	0	Indicator: Open Item Management?
27	ZINDT	☐	DZINDT	DATUM	DATS	8	0	Key date of the last interest calculation
28	ZINRT	☐	DZINRT	ZINRT	NUMC	2	0	Interest calculation frequency in months
29	ZUAWA	☐	DZUAWA	ZUAWA	CHAR	3	0	Key for sorting according to assignment numbers	TZUN
30	ALTKT	☐	ALTKT_SKB1	SAKNR	CHAR	10	0	Alternative Account Number in Company Code	*
31	XMITK	☐	XMITK	XFELD	CHAR	1	0	Indicator: Reconcil.acct ready for input at time of posting?
32	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	*
33	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
34	XMWNO	☐	XMWNO	XFELD	CHAR	1	0	Indicator: Tax code is not a required field
35	XSALH	☐	XSALH	XFELD	CHAR	1	0	Indicator: Only Manage Balances in Local Currency
36	BEWGP	☐	BEWGP	CHAR10	CHAR	10	0	Valuation Group
37	INFKY	☐	J_1AIFSKS	J_1AIFSKS	CHAR	8	0	Inflation Key	*
38	XLGCLR	☐	XLGCLR	XFELD	CHAR	1	0	Clearing Specific to Ledger Groups

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SKM1	FDGRV	T035	GRUPP	REF	C	CN
2	SKM1	KDFSL	T030S	KDFSL	REF	C	CN
3	SKM1	KTOPL	T004	KTOPL	KEY	1	CN
4	SKM1	MANDT	T000	MANDT	KEY	1	CN
5	SKM1	VZSKZ	T056	VZSKZ	REF	C	CN
6	SKM1	WAERS	TCURC	WAERS	REF	C	CN
7	SKM1	ZUAWA	TZUN	ZUAWA	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in