ERP 6.0: Top 10 requests

	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
10	FMARCPAR	4	Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

B1 8.8: Top 10 requests

	Table	Columns	Description
1	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OINM	101	Whse Journal
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Cross-Application Components
1	ERP EHP7	6.0	KKNA1	157	6	General Data in Customer Master	Cross-Application Components

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	KUNNR	Customer Number	nvarchar	10	0	Allow NULL?
3	LAND1	Country Key	nvarchar	3	0	Allow NULL?
4	NAME1	Name 1	nvarchar	35	0	Allow NULL?
5	NAME2	Name 2	nvarchar	35	0	Allow NULL?
6	ORT01	City	nvarchar	35	0	Allow NULL?
7	PSTLZ	Postal Code	nvarchar	10	0	Allow NULL?
8	REGIO	Region (State, Province, County)	nvarchar	3	0	Allow NULL?
9	SORTL	Sort field	nvarchar	10	0	Allow NULL?
10	STRAS	House number and street	nvarchar	35	0	Allow NULL?
11	TELF1	First telephone number	nvarchar	16	0	Allow NULL?
12	TELFX	Fax Number	nvarchar	31	0	Allow NULL?
13	XCPDK	Indicator: Is the account a one-time account?	char	1	0	Allow NULL?
14	ADRNR	Address	nvarchar	10	0	Allow NULL?
15	MCOD1	Search term for matchcode search	nvarchar	25	0	Allow NULL?
16	MCOD2	Search Term for Matchcode Search	nvarchar	25	0	Allow NULL?
17	MCOD3	Search term for matchcode search	nvarchar	25	0	Allow NULL?
18	ANRED	Title	nvarchar	15	0	Allow NULL?
19	AUFSD	Central order block for customer	nvarchar	2	0	Allow NULL?
20	BAHNE	Express train station	nvarchar	25	0	Allow NULL?
21	BAHNS	Train station	nvarchar	25	0	Allow NULL?
22	BBBNR	International location number (part 1)	nvarchar	7	0	Allow NULL?
23	BBSNR	International location number (Part 2)	nvarchar	5	0	Allow NULL?
24	BEGRU	Authorization Group	nvarchar	4	0	Allow NULL?
25	BRSCH	Industry key	nvarchar	4	0	Allow NULL?
26	BUBKZ	Check digit for the international location number	char	1	0	Allow NULL?
27	DATLT	Data communication line no.	nvarchar	14	0	Allow NULL?
28	ERDAT	Date on which the Record Was Created	nvarchar	8	0	Allow NULL?
29	ERNAM	Name of Person who Created the Object	nvarchar	12	0	Allow NULL?
30	EXABL	Indicator: Unloading points exist	char	1	0	Allow NULL?
31	FAKSD	Central billing block for customer	nvarchar	2	0	Allow NULL?
32	FISKN	Account number of the master record with the fiscal address	nvarchar	10	0	Allow NULL?
33	KNAZK	Working Time Calendar	nvarchar	2	0	Allow NULL?
34	KNRZA	Account number of an alternative payer	nvarchar	10	0	Allow NULL?
35	KONZS	Group key	nvarchar	10	0	Allow NULL?
36	KTOKD	Customer Account Group	nvarchar	4	0	Allow NULL?
37	KUKLA	Customer classification	nvarchar	2	0	Allow NULL?
38	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	Allow NULL?
39	LIFSD	Central delivery block for the customer	nvarchar	2	0	Allow NULL?
40	LOCCO	City Coordinates	nvarchar	10	0	Allow NULL?
41	LOEVM	Central Deletion Flag for Master Record	char	1	0	Allow NULL?
42	NAME3	Name 3	nvarchar	35	0	Allow NULL?
43	NAME4	Name 4	nvarchar	35	0	Allow NULL?
44	NIELS	Nielsen ID	nvarchar	2	0	Allow NULL?
45	ORT02	District	nvarchar	35	0	Allow NULL?
46	PFACH	PO Box	nvarchar	10	0	Allow NULL?
47	PSTL2	P.O. Box Postal Code	nvarchar	10	0	Allow NULL?
48	COUNC	County Code	nvarchar	3	0	Allow NULL?
49	CITYC	City Code	nvarchar	4	0	Allow NULL?
50	RPMKR	Regional Market	nvarchar	5	0	Allow NULL?
51	SPERR	Central posting block	char	1	0	Allow NULL?
52	SPRAS	Language Key	char	1	0	Allow NULL?
53	STCD1	Tax Number 1	nvarchar	16	0	Allow NULL?
54	STCD2	Tax Number 2	nvarchar	11	0	Allow NULL?
55	STKZA	Indicator: Business Partner Subject to Equalization Tax?	char	1	0	Allow NULL?
56	STKZU	Liable for VAT	char	1	0	Allow NULL?
57	TELBX	Telebox number	nvarchar	15	0	Allow NULL?
58	TELF2	Second telephone number	nvarchar	16	0	Allow NULL?
59	TELTX	Teletex number	nvarchar	30	0	Allow NULL?
60	TELX1	Telex number	nvarchar	30	0	Allow NULL?
61	LZONE	Transportation zone to or from which the goods are delivered	nvarchar	10	0	Allow NULL?
62	XZEMP	Indicator: Is an alternative payer allowed in document?	char	1	0	Allow NULL?
63	VBUND	Company ID of trading partner	nvarchar	6	0	Allow NULL?
64	STCEG	VAT Registration Number	nvarchar	20	0	Allow NULL?
65	DEAR1	Indicator: Competitor	char	1	0	Allow NULL?
66	DEAR2	Indicator: Sales partner	char	1	0	Allow NULL?
67	DEAR3	Indicator: Sales prospect	char	1	0	Allow NULL?
68	DEAR4	Indicator for customer type 4	char	1	0	Allow NULL?
69	DEAR5	ID for default sold-to party	char	1	0	Allow NULL?
70	GFORM	Legal status	nvarchar	2	0	Allow NULL?
71	BRAN1	Industry Code 1	nvarchar	10	0	Allow NULL?
72	BRAN2	Industry code 2	nvarchar	10	0	Allow NULL?
73	BRAN3	Industry code 3	nvarchar	10	0	Allow NULL?
74	BRAN4	Industry code 4	nvarchar	10	0	Allow NULL?
75	BRAN5	Industry code 5	nvarchar	10	0	Allow NULL?
76	EKONT	Initial contact	nvarchar	10	0	Allow NULL?
77	UMSAT	Annual sales	decimal	8	2
78	UMJAH	Year For Which Sales are Given	nvarchar	4	0	Allow NULL?
79	UWAER	Currency of sales figure	nvarchar	5	0	Allow NULL?
80	JMZAH	Yearly number of employees	nvarchar	6	0	Allow NULL?
81	JMJAH	Year for which the number of employees is given	nvarchar	4	0	Allow NULL?
82	KATR1	Attribute 1	nvarchar	2	0	Allow NULL?
83	KATR2	Attribute 2	nvarchar	2	0	Allow NULL?
84	KATR3	Attribute 3	nvarchar	2	0	Allow NULL?
85	KATR4	Attribute 4	nvarchar	2	0	Allow NULL?
86	KATR5	Attribute 5	nvarchar	2	0	Allow NULL?
87	KATR6	Attribute 6	nvarchar	3	0	Allow NULL?
88	KATR7	Attribute 7	nvarchar	3	0	Allow NULL?
89	KATR8	Attribute 8	nvarchar	3	0	Allow NULL?
90	KATR9	Attribute 9	nvarchar	3	0	Allow NULL?
91	KATR10	Attribute 10	nvarchar	3	0	Allow NULL?
92	STKZN	Natural Person	char	1	0	Allow NULL?
93	UMSA1	Annual sales	decimal	15	2
94	TXJCD	Tax Jurisdiction	nvarchar	15	0	Allow NULL?
95	PERIV	Fiscal Year Variant	nvarchar	2	0	Allow NULL?
96	ABRVW	Usage Indicator	nvarchar	3	0	Allow NULL?
97	INSPBYDEBI	Inspection Carried Out By Customer (No Inspection Lot)	char	1	0	Allow NULL?
98	INSPATDEBI	Inspection for a Delivery Note After Outbound Delivery	char	1	0	Allow NULL?
99	KTOCD	Reference Account Group for One-Time Account (Customer)	nvarchar	4	0	Allow NULL?
100	PFORT	PO Box city	nvarchar	35	0	Allow NULL?
101	WERKS	Plant	nvarchar	4	0	Allow NULL?
102	DTAMS	Indicator for Data Medium Exchange	char	1	0	Allow NULL?
103	DTAWS	Instruction key for data medium exchange	nvarchar	2	0	Allow NULL?
104	DUEFL	Status of Data Transfer into Subsequent Release	char	1	0	Allow NULL?
105	HZUOR	Assignment to Hierarchy	nvarchar	2	0	Allow NULL?
106	SPERZ	Payment Block	char	1	0	Allow NULL?
107	ETIKG	IS-R Labeling: customer/plant group	nvarchar	10	0	Allow NULL?
108	CIVVE	ID for mainly non-military use	char	1	0	Allow NULL?
109	MILVE	ID for mainly military use	char	1	0	Allow NULL?
110	KDKG1	Customer condition group 1	nvarchar	2	0	Allow NULL?
111	KDKG2	Customer condition group 2	nvarchar	2	0	Allow NULL?
112	KDKG3	Customer condition group 3	nvarchar	2	0	Allow NULL?
113	KDKG4	Customer condition group 4	nvarchar	2	0	Allow NULL?
114	KDKG5	Customer condition group 5	nvarchar	2	0	Allow NULL?
115	XKNZA	Indicator: Alternative payer using account number	char	1	0	Allow NULL?
116	FITYP	Tax type	nvarchar	2	0	Allow NULL?
117	STCDT	Tax Number Type	nvarchar	2	0	Allow NULL?
118	STCD3	Tax Number 3	nvarchar	18	0	Allow NULL?
119	STCD4	Tax Number 4	nvarchar	18	0	Allow NULL?
120	STCD5	Tax Number 5	nvarchar	60	0	Allow NULL?
121	XICMS	Customer is ICMS-exempt	char	1	0	Allow NULL?
122	XXIPI	Customer is IPI-exempt	char	1	0	Allow NULL?
123	XSUBT	Customer group for Substituiçao Tributária calculation	nvarchar	3	0	Allow NULL?
124	CFOPC	Customer's CFOP category	nvarchar	2	0	Allow NULL?
125	TXLW1	Tax law: ICMS	nvarchar	3	0	Allow NULL?
126	TXLW2	Tax law: IPI	nvarchar	3	0	Allow NULL?
127	CCC01	Indicator for biochemical warfare for legal control	char	1	0	Allow NULL?
128	CCC02	Indicator for nuclear nonproliferation for legal control	char	1	0	Allow NULL?
129	CCC03	Indicator for national security for legal control	char	1	0	Allow NULL?
130	CCC04	Indicator for missile technology for legal control	char	1	0	Allow NULL?
131	CASSD	Central sales block for customer	nvarchar	2	0	Allow NULL?
132	KNURL	Uniform Resource Locator	nvarchar	132	0	Allow NULL?
133	J_1KFREPRE	Name of Representative	nvarchar	10	0	Allow NULL?
134	J_1KFTBUS	Type of Business	nvarchar	30	0	Allow NULL?
135	J_1KFTIND	Type of Industry	nvarchar	30	0	Allow NULL?
136	CONFS	Status of Change Authorization (Central)	char	1	0	Allow NULL?
137	UPDAT	Date on Which the Changes Were Confirmed	nvarchar	8	0	Allow NULL?
138	UPTIM	Time of Last Change Confirmation	nvarchar	6	0	Allow NULL?
139	NODEL	Central deletion block for master record	char	1	0	Allow NULL?
140	DEAR6	Indicator: Consumer	char	1	0	Allow NULL?
141	CVP_XBLCK	Business Purpose Completed Flag	char	1	0	Allow NULL?
142	SUFRAMA	Suframa Code	nvarchar	9	0	Allow NULL?
143	RG	RG Number	nvarchar	11	0	Allow NULL?
144	EXP	Issued by	nvarchar	3	0	Allow NULL?
145	UF	State	nvarchar	2	0	Allow NULL?
146	RGDATE	RG Issue Date	nvarchar	8	0	Allow NULL?
147	RIC	RIC Number	nvarchar	11	0	Allow NULL?
148	RNE	Foreign National Registration	nvarchar	10	0	Allow NULL?
149	RNEDATE	RNE Issue Date	nvarchar	8	0	Allow NULL?
150	CNAE	CNAE	nvarchar	7	0	Allow NULL?
151	LEGALNAT	Legal Nature	nvarchar	4	0	Allow NULL?
152	CRTN	CRT Number	char	1	0	Allow NULL?
153	ICMSTAXPAY	ICMS Taxpayer	nvarchar	2	0	Allow NULL?
154	INDTYP	Industry Main Type	nvarchar	2	0	Allow NULL?
155	TDT	Tax Declaration Type	nvarchar	2	0	Allow NULL?
156	COMSIZE	Company Size	nvarchar	2	0	Allow NULL?
157	DECREGPC	Declaration Regimen for PIS/COFINS	nvarchar	2	0	Allow NULL?

Name	Primary	Unique	Type	Columns
KKNA1~0	Yes	Yes	CLUSTERED	KUNNR, MANDT
KKNA1~001	No	No	NONCLUSTERED	CONFS, MANDT
KKNA1~A	No	No	NONCLUSTERED	SORTL, MANDT
KKNA1~MC3	No	No	NONCLUSTERED	MCOD3, MANDT
KKNA1~MCD	No	No	NONCLUSTERED	MCOD3, MCOD2, MCOD1, MANDT
KKNA1~PLZ	No	No	NONCLUSTERED	PSTLZ, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

157 COLUMNS | 6 INDEXES | ERP 6.0 | KKNA1 TABLE

TOP ERP 6.0 | KKNA1 COLUMNS

TOP ERP 6.0 | KKNA1 INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

157 COLUMNS | 6 INDEXES | ERP 6.0 | KKNA1 TABLE

TOPERP 6.0 | KKNA1 COLUMNS

TOPERP 6.0 | KKNA1 INDEXES

TOP ERP 6.0 | KKNA1 COLUMNS

TOP ERP 6.0 | KKNA1 INDEXES