SAP ABAP Table SKB1 (G/L account master (company code))

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	SKB1	Table Relationship Diagram
Short Description	G/L account master (company code)

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	SAKNR	☑	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKA1
4	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	*
5	BUSAB	☐	BUSAB	BUSAB	CHAR	2	0	Accounting clerk	T001S
6	DATLZ	☐	DATLZ	DATUM	DATS	8	0	Date of the last interest calculation run
7	ERDAT	☐	ERDAT_RF	DATUM	DATS	8	0	Date on which the Record Was Created
8	ERNAM	☐	ERNAM_RF	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	T036
11	FIPLS	☐	FIPLS	FIPLS	NUMC	3	0	Financial Budget Item
12	FSTAG	☐	FSTAG	FSTAG	CHAR	4	0	Field status group	T004F
13	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
14	HKTID	☐	HKTID	HKTID	CHAR	5	0	ID for account details	T012K
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_SKB1	WAERS	CUKY	5	0	Account currency	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	XLOEB	☐	XLOEV	XFELD	CHAR	1	0	Indicator: Account marked for deletion?
26	XNKON	☐	XNKON	XFELD	CHAR	1	0	Indicator: Supplement for automatic postings ?
27	XOPVW	☐	XOPVW	XFELD	CHAR	1	0	Indicator: Open Item Management?
28	XSPEB	☐	XSPEB	XFELD	CHAR	1	0	Indicator: Is Account Blocked for Posting?
29	ZINDT	☐	DZINDT	DATUM	DATS	8	0	Key date of the last interest calculation
30	ZINRT	☐	DZINRT	ZINRT	NUMC	2	0	Interest calculation frequency in months
31	ZUAWA	☐	DZUAWA	ZUAWA	CHAR	3	0	Key for sorting according to assignment numbers	TZUN
32	ALTKT	☐	ALTKT_SKB1	SAKNR	CHAR	10	0	Alternative Account Number in Company Code	*
33	XMITK	☐	XMITK	XFELD	CHAR	1	0	Indicator: Reconcil.acct ready for input at time of posting?
34	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	T8JJ
35	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
36	XMWNO	☐	XMWNO	XFELD	CHAR	1	0	Indicator: Tax code is not a required field
37	XSALH	☐	XSALH	XFELD	CHAR	1	0	Indicator: Only Manage Balances in Local Currency
38	BEWGP	☐	BEWGP	CHAR10	CHAR	10	0	Valuation Group
39	INFKY	☐	J_1AIFSKS	J_1AIFSKS	CHAR	8	0	Inflation Key	J_1AINFSKS
40	TOGRU	☐	TOGRU_S	TOGRU	CHAR	4	0	Tolerance Group for G/L Accounts	T043S
41	XLGCLR	☐	XLGCLR	XFELD	CHAR	1	0	Clearing Specific to Ledger Groups
42	MCAKEY	☐	GLE_DTE_MCA_MCAKEY	GLE_MCA_MCAKEY	CHAR	5	0	MCA Key	GLE_MCA_TMCAKEY

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SKB1	BUKRS	T001	BUKRS	KEY	1	CN
2	SKB1	BUSAB	T001S	BUSAB	REF	C	CN
3	SKB1	FDGRV	T035	GRUPP	REF	C	CN
4	SKB1	FDLEV	T036	EBENE	REF	C	CN
5	SKB1	FSTAG	T004F	FSTAG	REF	1	CN
6	SKB1	HBKID	T012	HBKID	REF	C	CN
7	SKB1	HKTID	T012K	HKTID	REF	C	CN
8	SKB1	INFKY	J_1AINFSKS	J_1AIFSKS		1	CN
9	SKB1	KDFSL	T030S	KDFSL	REF	C	CN
10	SKB1	MANDT	T000	MANDT	KEY	1	CN
11	SKB1	MCAKEY	GLE_MCA_TMCAKEY	MANDT		1	CN
12	SKB1	RECID	T8JJ	RECID	REF	C	CN
13	SKB1	SAKNR	SKA1	SAKNR	KEY	1	CN
14	SKB1	TOGRU	T043S	TOGRU		1	CN
15	SKB1	VZSKZ	T056	VZSKZ	REF	C	CN
16	SKB1	WAERS	TCURC	WAERS	REF	1	CN
17	SKB1	ZUAWA	TZUN	ZUAWA	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in