	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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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

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

104 columns | ERP 6.0 | KNDNR

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/1RA/0SD010MI	Items for Class SD01 - Raw Data	85	KNDNR	Customer	nvarchar	10	0
2	B006	SOrg/DstCh/Division/Customer	7	KNDNR	Customer number	nvarchar	10	0
3	CE1PR22	Périm. résultat IDES	20	KNDNR	Client	nvarchar	10	0
4	CE2PR22	Périm. résultat IDES	14	KNDNR	Client	nvarchar	10	0
5	CE4PR22	Périm. résultat IDES	8	KNDNR	Client	nvarchar	10	0
6	CE4PR22_ACCT	Périm. résultat IDES	6	KNDNR	Client	nvarchar	10	0
7	CE4PR22_FLAG	Périm. résultat IDES	5	KNDNR	Flag : caract. imputée manuellement ou via TKEZU	nvarchar	1	0
8	CE4PR22_KENC	Périm. résultat IDES	7	KNDNR	Client	nvarchar	10	0
9	P2RN_NKO	Payroll Results: Childcare (NL)	10	KNDNR	Object Identification	nvarchar	2	0
10	ZAC99000	Senderstruktur AC99000	7	KNDNR		nvarchar	10	0
TOPConditions
11	B001	Sales Organization/Customer Number	5	KNDNR	Customer number	nvarchar	10	0
12	KOTH002	Customer/Material	4	KNDNR	Customer number	nvarchar	10	0
13	KOTH003	Customer/Plant/Material	4	KNDNR	Customer number	nvarchar	10	0
14	KOTH504	Condition Table for Batch Search Strategy KOTH504	4	KNDNR	Customer number	nvarchar	10	0
15	KOTI002	Material/Customer	5	KNDNR	Customer number	nvarchar	10	0
TOPNetherlands
16	PA0525	Childcare	25	KNDNR	Object Identification	nvarchar	2	0
TOPProfitability Analysis
17	CE18500		20	KNDNR	Customer	nvarchar	10	0
18	CE1BGIS	Ergebnisbereich für	20	KNDNR	Kunde	nvarchar	10	0
19	CE1E_B1	Model Bank	20	KNDNR	Customer	nvarchar	10	0
20	CE1IDEA	Op. Concern BR World	20	KNDNR	Customer	nvarchar	10	0
21	CE1IDEB	Ergebnisbereich IDES	20	KNDNR	Kunde	nvarchar	10	0
22	CE1IDES	Ergebnisbereich IDES	20	KNDNR	Kunde	nvarchar	10	0
23	CE1INT1	Ergebnisbereich IDES	20	KNDNR	Kunde	nvarchar	10	0
24	CE1OC01	Bike International	20	KNDNR	Customer	nvarchar	10	0
25	CE1R300	Operating Concern IDES	20	KNDNR	Customer	nvarchar	10	0
26	CE1S001	Sample operating concern	20	KNDNR	Customer	nvarchar	10	0
27	CE1S300	Operating Concern IDES	20	KNDNR	Customer	nvarchar	10	0
28	CE1S_AL	Airline Route Profit	20	KNDNR	Customer	nvarchar	10	0
29	CE1S_CP	Template for Consumer Goods Industry	20	KNDNR	Customer	nvarchar	10	0
30	CE1S_GO	Quickstart Template	20	KNDNR	Customer	nvarchar	10	0
31	CE28500		14	KNDNR	Customer	nvarchar	10	0
32	CE2BGIS	Ergebnisbereich für	14	KNDNR	Kunde	nvarchar	10	0
33	CE2E_B1	Model Bank	14	KNDNR	Customer	nvarchar	10	0
34	CE2IDEA	Op. Concern BR World	14	KNDNR	Customer	nvarchar	10	0
35	CE2IDEB	Ergebnisbereich IDES	14	KNDNR	Kunde	nvarchar	10	0
36	CE2IDES	Ergebnisbereich IDES	14	KNDNR	Kunde	nvarchar	10	0
37	CE2INT1	Ergebnisbereich IDES	14	KNDNR	Kunde	nvarchar	10	0
38	CE2OC01	Bike International	14	KNDNR	Customer	nvarchar	10	0
39	CE2R300	Operating Concern IDES	14	KNDNR	Customer	nvarchar	10	0
40	CE2S001	Sample operating concern	14	KNDNR	Customer	nvarchar	10	0
41	CE2S300	Operating Concern IDES	14	KNDNR	Customer	nvarchar	10	0
42	CE2S_AL	Airline Route Profit	14	KNDNR	Customer	nvarchar	10	0
43	CE2S_CP	Template for Consumer Goods Industry	14	KNDNR	Customer	nvarchar	10	0
44	CE2S_GO	Quickstart Template	14	KNDNR	Customer	nvarchar	10	0
45	CE48500		8	KNDNR	Customer	nvarchar	10	0
46	CE48500_ACCT		6	KNDNR	Customer	nvarchar	10	0
47	CE48500_FLAG		5	KNDNR	Flag: Characteristic Assigned Manually or Using TKEZU	nvarchar	1	0
48	CE48500_KENC		7	KNDNR	Customer	nvarchar	10	0
49	CE4BGIS	Ergebnisbereich für	8	KNDNR	Kunde	nvarchar	10	0
50	CE4BGIS_ACCT	Ergebnisbereich für	6	KNDNR	Kunde	nvarchar	10	0
51	CE4BGIS_FLAG	Ergebnisbereich für	5	KNDNR	Flag: Merkmal manuell oder über TKEZU kontiert	nvarchar	1	0
52	CE4BGIS_KENC	Ergebnisbereich für	7	KNDNR	Kunde	nvarchar	10	0
53	CE4E_B1	Model Bank	8	KNDNR	Customer	nvarchar	10	0
54	CE4E_B1_ACCT	Model Bank	6	KNDNR	Customer	nvarchar	10	0
55	CE4E_B1_FLAG	Model Bank	5	KNDNR	Flag: Characteristic Assigned Manually or Using TKEZU	nvarchar	1	0
56	CE4E_B1_KENC	Model Bank	7	KNDNR	Customer	nvarchar	10	0
57	CE4IDEA	Op. Concern BR World	8	KNDNR	Customer	nvarchar	10	0
58	CE4IDEA_ACCT	Op. Concern BR World	6	KNDNR	Customer	nvarchar	10	0
59	CE4IDEA_FLAG	Op. Concern BR World	5	KNDNR	Flag: Characteristic Assigned Manually or Using TKEZU	nvarchar	1	0
60	CE4IDEA_KENC	Op. Concern BR World	7	KNDNR	Customer	nvarchar	10	0
61	CE4IDEB	Ergebnisbereich IDES	8	KNDNR	Kunde	nvarchar	10	0
62	CE4IDEB_ACCT	Ergebnisbereich IDES	6	KNDNR	Kunde	nvarchar	10	0
63	CE4IDEB_FLAG	Ergebnisbereich IDES Banking	5	KNDNR	Flag: Merkmal manuell oder über TKEZU kontiert	nvarchar	1	0
64	CE4IDEB_KENC	Ergebnisbereich IDES	7	KNDNR	Kunde	nvarchar	10	0
65	CE4IDES	Ergebnisbereich IDES	8	KNDNR	Kunde	nvarchar	10	0
66	CE4IDES_ACCT	Ergebnisbereich IDES	6	KNDNR	Kunde	nvarchar	10	0
67	CE4IDES_FLAG	Ergebnisbereich IDES	5	KNDNR	Flag: Merkmal manuell oder über TKEZU kontiert	nvarchar	1	0
68	CE4IDES_KENC	Ergebnisbereich IDES	7	KNDNR	Kunde	nvarchar	10	0
69	CE4INT1	Ergebnisbereich IDES	8	KNDNR	Kunde	nvarchar	10	0
70	CE4INT1_ACCT	Ergebnisbereich IDES	6	KNDNR	Kunde	nvarchar	10	0
71	CE4INT1_FLAG	Ergebnisbereich IDES	5	KNDNR	Flag: Merkmal manuell oder über TKEZU kontiert	nvarchar	1	0
72	CE4INT1_KENC	Ergebnisbereich IDES	7	KNDNR	Kunde	nvarchar	10	0
73	CE4OC01	Bike International	8	KNDNR	Customer	nvarchar	10	0
74	CE4OC01_ACCT	Bike International	6	KNDNR	Customer	nvarchar	10	0
75	CE4OC01_KENC	Bike International	7	KNDNR	Customer	nvarchar	10	0
76	CE4R300	Operating Concern IDES	8	KNDNR	Customer	nvarchar	10	0
77	CE4R300_ACCT	Ergebnisbereich IDES	6	KNDNR	Kunde	nvarchar	10	0
78	CE4R300_FLAG	Ergebnisbereich IDES	5	KNDNR	Flag: Merkmal manuell oder über TKEZU kontiert	nvarchar	1	0
79	CE4R300_KENC	Operating Concern IDES	7	KNDNR	Customer	nvarchar	10	0
80	CE4S001	Sample operating concern	6	KNDNR	Customer	nvarchar	10	0
81	CE4S001_ACCT	Sample operating con	6	KNDNR	Customer	nvarchar	10	0
82	CE4S001_FLAG	Sample Operating Concern 1	5	KNDNR	Flag: Characteristic Assigned Manually or Using TKEZU	nvarchar	1	0
83	CE4S001_KENC	Sample operating con	7	KNDNR	Customer	nvarchar	10	0
84	CE4S300	Operating Concern IDES	8	KNDNR	Customer	nvarchar	10	0
85	CE4S300_ACCT	Operating Concern IDES	6	KNDNR	Customer	nvarchar	10	0
86	CE4S300_FLAG	Ergebnisbereich IDES Serv.Prov	5	KNDNR	Flag: Merkmal manuell oder über TKEZU kontiert	nvarchar	1	0
87	CE4S300_KENC	Operating Concern IDES	7	KNDNR	Customer	nvarchar	10	0
88	CE4S_AL	Airline Route Profit	8	KNDNR	Customer	nvarchar	10	0
89	CE4S_AL_ACCT	Airline Route Profit	6	KNDNR	Customer	nvarchar	10	0
90	CE4S_AL_FLAG	Airline Route Profit	5	KNDNR	Flag: Characteristic Assigned Manually or Using TKEZU	nvarchar	1	0
91	CE4S_AL_KENC	Airline Route Profit	7	KNDNR	Customer	nvarchar	10	0
92	CE4S_CP	Template for Consumer Goods Industry	8	KNDNR	Customer	nvarchar	10	0
93	CE4S_CP_ACCT	Template for Consumer Goods Industry	6	KNDNR	Customer	nvarchar	10	0
94	CE4S_CP_FLAG	Template for Consumer Goods Industry	5	KNDNR	Flag: Characteristic Assigned Manually or Using TKEZU	nvarchar	1	0
95	CE4S_CP_KENC	Template for Consumer Goods Industry	7	KNDNR	Customer	nvarchar	10	0
96	CE4S_GO	Quickstart Template	8	KNDNR	Customer	nvarchar	10	0
97	CE4S_GO_ACCT	Quickstart Template	6	KNDNR	Customer	nvarchar	10	0
98	CE4S_GO_FLAG	Quickstart Template	5	KNDNR	Flag: Characteristic Assigned Manually or Using TKEZU	nvarchar	1	0
99	CE4S_GO_KENC	Quickstart Template	7	KNDNR	Customer	nvarchar	10	0
100	CEST4	Segment table (CO-PA)	8	KNDNR	Customer	nvarchar	10	0
TOPProfitability Analysis Basic Functions
101	K810005	Verdichtungsebene KT: 800 KE 01 CE1IDEA 000313	2	KNDNR	Kunde	nvarchar	10	0
TOPR2-R3 Link
102	LDK04	Communication Rec. 04 LVS Decentr.: DN Supplem. R/2 -> ERP	14	KNDNR	Sold-to party from delivery document for WMS link	nvarchar	8	0
TOPReuse Services for Country Development
103	PA0651	HR Master Record Infotype 0651	84	KNDNR	Child Number	nvarchar	2	0
TOPShipping
104	LDA01	Decentralized WMS: Delivery Document Appendix	13	KNDNR	Sold-to party from delivery document for WMS link	nvarchar	8	0

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

104 columns | ERP 6.0 | KNDNR