	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

147 columns | ERP 6.0 | KMEIN

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/1CN/CBPSAP001	Vendor/product	20	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
2	/1CN/CBPSAP016	Contract Item	19	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
3	/1CN/CBPSAP019	Contract Header	19	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
4	/1CN/CBPSAP068	Location-Dependent	20	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
5	/1CN/CBPSAP118	Product	19	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
6	/1CN/CPTSAP00001	Business Partner/Product Group	20	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
7	/1CN/CPTSAP00004	Business Partner/Product GUID	20	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
8	/1CN/CPTSAP00005	Business Partner/Product Group/Product GUID	21	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
9	/1CN/CPTSAP00006	Business Partner	19	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
10	/1CN/CTXSAPD0001	Country/Cost Center/Product Usage	21	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
11	/1CN/CTXSAPD0002	Country/Order/Product Usage	21	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
12	/1CN/CTXSAPD0003	Country/Product Usage	20	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
13	/1CN/CTXSAPD0004	Country	19	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
14	/1CN/CTXSAPD0201	Country/Tax Code	20	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
15	/1CN/CTXSAPR0100	Country/Product Tax Group/Business Partner Tax Group	21	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
16	/1CN/CTXSAPR0103	Country/Product Tax Group	20	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
17	/1CN/CTXSAPR0104	Country	19	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
18	/1CN/CTXSAPR0105	Country/Tax Event	20	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
19	/1CN/CTXSAPR0106	Country/Region/Product Tax Group/Business Partner Tax Group	22	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
20	/1CN/CTXSAPR0107	Country/Tax Event/ST Jurisdiction Code	21	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
21	/1CN/CTXSAPR0108	Country/Region/Product Tax Group	21	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
22	/1CN/CTXSAPR0110	Country/1L Sppl.Jur.Code/1L Rec.Jur.Code	21	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
23	/1CN/CTXSAPR0111	Country/2L Sppl.Jur.Code/2L Rec.Jur.Code	21	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
24	/1CN/CTXSAPR0112	Country/2L Sppl.Jur.Code/2L Rec.Jur.Code/Tax Tariff Code	22	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
25	/1CN/CTXSAPR0113	Country/2L Sppl.Jur.Code/2L Rec.Jur.Code/Product Tax Group	22	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
26	/1CN/CTXSAPR0120	Country/Tax Tariff Code	20	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
27	/1CN/CTXSAPR0130	Country/3L Jur.Code	20	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
28	/1CN/CTXSAPR0131	Country/3L Jur.Code/Product Tax Group	21	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
29	/1CN/CTXSAPR0140	Country/Tax Event/Jurisdiction Code	21	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
30	/1CN/CTXSAPR0201	Country/Tax Code	20	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
31	/1CN/CTXSAPRBR01	Country/Tax Tariff Code	20	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
32	/1CN/CTXSAPRBR02	Country/Product Tax Group	20	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
33	/1CN/CTXSAPRBR03	Country/Product Tax Group/Business Partner Tax Group	21	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
34	/1CN/CTXSAPRBR10	Country/1L Sppl.Jur.Code/1L Rec.Jur.Code	21	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
35	/1CN/CTXSAPRBR11	Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Tax Tariff Code	22	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
36	/1CN/CTXSAPRBR12	Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Product Tax Group	22	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
37	/1CN/CTXSAPRBR20	Country/2L Jur.Code	20	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
38	/1CN/CTXSAPRBR21	Country/2L Jur.Code/Product Tax Group	21	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
39	/1CN/CTXSAPRIN03	Country/Tax Tariff Code/Business Partner ID	21	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
40	/1CN/CTXSAPRIN04	Recipient Country/Tax Tariff Code/Business Partner ID	21	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
41	/1CN/CTXSAPRIN06	Country/Spl Reg./Rec Region/Tax Group/Tax Group	23	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
42	/1CN/CTXSAPRIN07	Country/Partner ID/Recip. Tax Region/Tax Group	22	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
43	/1CN/CTXSAPS0100	Country/Business Process	20	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
44	/1CN/CTXSAPS0101	Country/Bus. Transaction	20	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
45	/1CN/CTXSAPS0102	Country/Bus. Transaction	20	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
46	/1CN/CTXSAPW0201	Country/Tax Code	20	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
47	/1CN/CTXSAPW0202	Country/Business Partner Tax Group	20	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
48	/1CN/CTXSAPX0100	Country/Region	20	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
49	/1CN/CTXSAPX0101	Country/Supplier BP ID/Business Partner ID	21	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
50	/1CN/CTXSAPX0102	Country/Business Partner Tax Group	20	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
51	/1CN/CTXSAPX0103	Country/Supplier BP ID/Business Partner ID/Product Tax Group	22	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
52	/1CN/CTXSAPX0104	Recipient Country/Recipient Tax Region/Locat. Relationship	21	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
53	/1CN/CTXSAPX0105	Country/Product Tax Group	20	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
54	/1CN/CTXSAPX0106	Country/Region/Product Tax Group	21	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
55	/1CN/CTXSAPX0140	Country/Product Tax Group/Jurisdiction Code	21	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
56	/1CN/CTXSAPX0141	Country/Business Partner Tax Group/Jurisdiction Code	21	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
57	/1CN/CTXSAPX0146	Country/Region/Product Tax Group	21	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
58	/1CN/CTXSAPX0147	Country/Region/Business Partner Tax Group	21	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
59	/1CN/CTXSAPX0148	Country	19	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
60	/1CN/CTXSAPXBR01	Country/Tax Tariff Code	20	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
61	/1CN/CTXSAPXBR02	Country/Product Tax Group	20	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
62	/1CN/CTXSAPXBR03	Country/Product Tax Group/Business Partner Tax Group	21	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
63	/1CN/CTXSAPXBR11	Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Tax Tariff Code	22	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
64	/1CN/LBPSCALEEVL	Scale Table - Fixed Data Part of a Scale	5	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
65	/1CN/LPTSCALEEVL	Scale Table - Fixed Data Part of a Scale	5	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
66	/1CN/LTXSCALEEVL	Scale Table - Fixed Data Part of a Scale	5	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
67	/BIC/B0000178000	PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item	52	KMEIN		nvarchar	3	0
68	/BIC/B0000179000	PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule	60	KMEIN		nvarchar	3	0
69	KONV	Conditions (Transaction Data)	15	KMEIN	Condition unit in the document	nvarchar	3	0
70	ZCM_FIX_ALLOC_DB	Fixation Allocation Table	15	KMEIN	Condition unit	nvarchar	3	0
71	ZEIM_LIPS	SD document: Delivery: Item data	167	KMEIN	Condition unit	nvarchar	3	0
72	ZEIM_VBAP	Sales Document: Item Data	95	KMEIN	Condition unit	nvarchar	3	0
TOPConditions
73	KOND	Conditions (Data)	21	KMEIN	Condition unit	nvarchar	3	0
74	KONDN	Conditions: Free goods - Data section	35	KMEIN	Condition unit	nvarchar	3	0
75	KONP	Conditions (Item)	17	KMEIN	Condition unit	nvarchar	3	0
76	T685Z	Condition Types: Lower/Higher Limits for Pricing Elements	9	KMEIN	Condition unit	nvarchar	3	0
TOPCost Center Accounting
77	TKRSTR	Transport Resource Prices	21	KMEIN	Condition unit	nvarchar	3	0
TOPCross-Application Components
78	VKONV	Conditions (Transaction Data)	15	KMEIN	Condition unit in the document	nvarchar	3	0
79	VVBAP	Sales Document: Item Data	95	KMEIN	Condition unit	nvarchar	3	0
TOPData Collection
80	S015	Subsequent Settlement: Evaluation	20	KMEIN	Condition unit in the document	nvarchar	3	0
81	S015E	S015 - Structural Information	13	KMEIN	Condition unit in the document	nvarchar	3	0
82	S060	Model Structure for Info Structures with Initial VAKEY	13	KMEIN	Condition unit in the document	nvarchar	3	0
83	S074	Subsequent Settlement: Operative	16	KMEIN	Condition unit in the document	nvarchar	3	0
84	S074E	S074 - Structural Information	9	KMEIN	Condition unit in the document	nvarchar	3	0
TOPExchanges
85	OIA12ICOND	Conditions of OIA12I items	11	KMEIN	Condition unit	nvarchar	3	0
86	OIANF	Fee Condition Records	15	KMEIN	Condition unit in the document	nvarchar	3	0
TOPExtended Rebate
87	S469	Erweiterte Bonusabrechnung	14	KMEIN	Hoeveelheidseenheid conditie in document	nvarchar	3	0
TOPFreight Processing
88	VFKGRP	(Freight) Group Conditions	17	KMEIN	Condition unit	nvarchar	3	0
89	VFKONV	(Freight) Conditions	22	KMEIN	Condition unit	nvarchar	3	0
90	VFSCAH	Scale Header	7	KMEIN	Condition unit	nvarchar	3	0
91	VFSI	Shipment Costs: Sub-item Data	20	KMEIN	Condition unit	nvarchar	3	0
TOPGlobal Trade
92	WB2_D_PRASP	Trading Contract: pricing aspects	15	KMEIN	Condition unit	nvarchar	3	0
TOPIntegration
93	FKK_KONV_SHORT	Price Conditions for SD Billing Document - Extracts	19	KMEIN	Condition unit	nvarchar	3	0
TOPInvoice Verification
94	RBDIFFKO	Invoice Verification - Conditions	18	KMEIN	Condition unit	nvarchar	3	0
TOPJoint Venture und Production Sharing Accounting
95	JVKONV	IS-Oil / Joint Venture / Data table for CRP pricing data	15	KMEIN	Condition unit in the document	nvarchar	3	0
TOPLocalization
96	J_1BFIFOIN	Incoming FIFO relevant Consignment movements (BRAZIL)	22	KMEIN	Condition unit	nvarchar	3	0
97	J_1BFIFOOUT	Outgoing FIFO relevant Consignment movements (BRAZIL)	21	KMEIN	Condition unit	nvarchar	3	0
98	J_1IADDEXC	Additional Excise rate table	10	KMEIN	Condition unit	nvarchar	3	0
99	J_1IEXCTAX	Tax calc. - Excise tax rates	10	KMEIN	Condition unit	nvarchar	3	0
100	J_1IMATEXP	Exceptional materials excise rates	13	KMEIN	Condition unit	nvarchar	3	0
101	VIXCJPFXDUNPRICE	Fixed Unit Prices for Service Charge Settlement	15	KMEIN	Condition unit	nvarchar	3	0
TOPLogistics Execution
102	/DSD/PE_CNDRDI	Pricing: Retrieved Condition Records - Item Info.	8	KMEIN	Condition unit	nvarchar	3	0
TOPMarketing, Accounting and Pricing
103	OIC_KONV	Conditions (Procedure Data)	15	KMEIN	Condition unit in the document	nvarchar	3	0
104	OIC_OIANF	Fee Condition Records	15	KMEIN	Condition unit in the document	nvarchar	3	0
TOPOverhead Cost Controlling
105	KONR	Resource Prices: Help Table for Variable Fields	29	KMEIN	Condition unit	nvarchar	3	0
106	KONR1	Resource Prices: Help Table for Variable Fields	29	KMEIN	Condition unit	nvarchar	3	0
TOPOverhead Cost Orders
107	KONX	Overhead Rates: Help Table for Variable Fields	26	KMEIN	Condition unit	nvarchar	3	0
108	KONX1	Overhead Rates: Help Table for Variable Fields	26	KMEIN	Condition unit	nvarchar	3	0
109	TKZUTR	Transport Overhead Records	21	KMEIN	Condition unit	nvarchar	3	0
TOPPeriodical Sales and Distribution
110	JKEP	Sales Order: Schedule Line Data	29	KMEIN	Condition unit	nvarchar	3	0
111	JKONV	IS-M/SD: Conditions (Transaction Data)	15	KMEIN	Condition unit in the document	nvarchar	3	0
112	JLTPST2	IS-M/SD: Main Data for Batch Input Postal Charges	10	KMEIN	3-Byte field	nvarchar	3	0
TOPPricing
113	PRCC_COND_LIMITS	Condition Types: Lower/Higher Limits for Pricing Elements	9	KMEIN	Unit of Measure for Product-Specific Quantity	nvarchar	3	0
114	PRCD_COND	Price Condition - Item - Condition (KONV)	51	KMEIN	Condition Unit	nvarchar	3	0
115	PRCM_TABL_000	Reference Table for Condition Tables (A000)	19	KMEIN	Condition Unit	nvarchar	3	0
TOPRecycling Administration Core Functions
116	J_7LP02	REA Price List: Items	15	KMEIN	Condition unit	nvarchar	3	0
117	J_7LV1P	REA Document: Item Data	21	KMEIN	Condition unit	nvarchar	3	0
TOPRemaining Beverage - Obsolete Objects
118	/BEV1/BO_DATA	Proof Table for Rebate Processing	30	KMEIN	Condition unit	nvarchar	3	0
119	/BEV1/RBKP	Copy Table for KONP for Accrual (Field KBRUE)	17	KMEIN	Condition unit	nvarchar	3	0
120	/BEV1/RBPA	Intermediate Table (Material-Specific Contrib. Margin Acc.)	16	KMEIN	Condition unit in the document	nvarchar	3	0
121	/BEV1/RBVBAP	Sales Document: Item Data	95	KMEIN	Condition unit	nvarchar	3	0
122	/BEV1/RBWE	Itemized Proof Rebate Settlement	22	KMEIN	Condition unit	nvarchar	3	0
TOPSales
123	VBAP	Sales Document: Item Data	95	KMEIN	Condition unit	nvarchar	3	0
TOPService Station Retailing
124	OIRADBT	Document base table	27	KMEIN	Condition unit	nvarchar	3	0
125	OIRCCOMPD	SSR Pricing - Competitor price differences	7	KMEIN	Condition unit	nvarchar	3	0
126	OIRCCOMPDM	SSR Pricing - Competitor price differences/Material	8	KMEIN	Condition unit	nvarchar	3	0
127	OIRCLPCD	SSR Pricing - Location price cluster differences	7	KMEIN	Condition unit	nvarchar	3	0
128	OIRCLPCDM	SSR Pricing - Location price cluster differences/Material	8	KMEIN	Condition unit	nvarchar	3	0
129	OIRCMDPGR	SSR Pricing - Material differences rates	7	KMEIN	Condition unit	nvarchar	3	0
130	OIRCSDPGR	SSR Pricing - Service type differences rates	7	KMEIN	Condition unit	nvarchar	3	0
131	OIRCT685	SSR Pricing - Condition type definition	7	KMEIN	Condition unit	nvarchar	3	0
132	OIRCT685_H	SSR Pricing - Condition type definition	8	KMEIN	Condition unit	nvarchar	3	0
133	OIRC_GMMH	SSR Meters - History	29	KMEIN	Condition unit	nvarchar	3	0
134	OIRC_GMMH_DEL	SSR Meters - Deleted meter readings history	30	KMEIN	Condition unit	nvarchar	3	0
135	OIRC_MRREJ	SSR Meters - Meter readings rejected records	32	KMEIN	Condition unit	nvarchar	3	0
136	OIRC_PRCHK	SSR Pricing - Price check	15	KMEIN	SSR Pricing - Actual price condition unit	nvarchar	3	0
137	OIRC_PRLOG_DIF	SSR Pricing - Price update differences	13	KMEIN	Condition unit	nvarchar	3	0
138	OIRC_PRLOG_PRL	SSR Pricing - Old and new prices	10	KMEIN	Condition unit	nvarchar	3	0
139	OIRC_PRLOG_PRM	SSR Pricing - Price update parameter log	14	KMEIN	Condition unit	nvarchar	3	0
140	OIREUPLPXXXX	SSR PC: DTF table for item information	14	KMEIN	Condition unit	nvarchar	3	0
TOPShipping
141	LIPS	SD document: Delivery: Item data	167	KMEIN	Condition unit	nvarchar	3	0
TOPSimulation
142	VSVBAP_CN	Version: Sales document: Item data	96	KMEIN	Condition unit	nvarchar	3	0
TOPSubsequent Settlement
143	EBABP	Settlement Runs Subsequent Settlement, Condition Record	15	KMEIN	Condition unit	nvarchar	3	0
144	S015BIW1	S015BIW1 * Supplementary settlement - Evaluation	20	KMEIN	Condition unit in the document	nvarchar	3	0
145	S015BIW2	S015BIW2 * Supplementary settlement - Evaluation	20	KMEIN	Condition unit in the document	nvarchar	3	0
TOPUnique Identification
146	IUID_MAN_DATA	Manually Maintained Values for IUID Messages	26	KMEIN	Condition unit	nvarchar	3	0
147	IUID_PEDIGREE	UII IDoc Message Data for Supporting Supplier Collaboration	26	KMEIN	Condition unit	nvarchar	3	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

147 columns | ERP 6.0 | KMEIN