	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

146 columns | ERP 6.0 | KBETR

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/1CN/CBPSAP001	Vendor/product	18	KBETR	Condition Rate	decimal	15	2
2	/1CN/CBPSAP016	Contract Item	17	KBETR	Condition Rate	decimal	15	2
3	/1CN/CBPSAP019	Contract Header	17	KBETR	Condition Rate	decimal	15	2
4	/1CN/CBPSAP068	Location-Dependent	18	KBETR	Condition Rate	decimal	15	2
5	/1CN/CBPSAP118	Product	17	KBETR	Condition Rate	decimal	15	2
6	/1CN/CPTSAP00001	Business Partner/Product Group	18	KBETR	Condition Rate	decimal	15	2
7	/1CN/CPTSAP00004	Business Partner/Product GUID	18	KBETR	Condition Rate	decimal	15	2
8	/1CN/CPTSAP00005	Business Partner/Product Group/Product GUID	19	KBETR	Condition Rate	decimal	15	2
9	/1CN/CPTSAP00006	Business Partner	17	KBETR	Condition Rate	decimal	15	2
10	/1CN/CTXSAPD0001	Country/Cost Center/Product Usage	19	KBETR	Condition Rate	decimal	15	2
11	/1CN/CTXSAPD0002	Country/Order/Product Usage	19	KBETR	Condition Rate	decimal	15	2
12	/1CN/CTXSAPD0003	Country/Product Usage	18	KBETR	Condition Rate	decimal	15	2
13	/1CN/CTXSAPD0004	Country	17	KBETR	Condition Rate	decimal	15	2
14	/1CN/CTXSAPD0201	Country/Tax Code	18	KBETR	Condition Rate	decimal	15	2
15	/1CN/CTXSAPR0100	Country/Product Tax Group/Business Partner Tax Group	19	KBETR	Condition Rate	decimal	15	2
16	/1CN/CTXSAPR0103	Country/Product Tax Group	18	KBETR	Condition Rate	decimal	15	2
17	/1CN/CTXSAPR0104	Country	17	KBETR	Condition Rate	decimal	15	2
18	/1CN/CTXSAPR0105	Country/Tax Event	18	KBETR	Condition Rate	decimal	15	2
19	/1CN/CTXSAPR0106	Country/Region/Product Tax Group/Business Partner Tax Group	20	KBETR	Condition Rate	decimal	15	2
20	/1CN/CTXSAPR0107	Country/Tax Event/ST Jurisdiction Code	19	KBETR	Condition Rate	decimal	15	2
21	/1CN/CTXSAPR0108	Country/Region/Product Tax Group	19	KBETR	Condition Rate	decimal	15	2
22	/1CN/CTXSAPR0110	Country/1L Sppl.Jur.Code/1L Rec.Jur.Code	19	KBETR	Condition Rate	decimal	15	2
23	/1CN/CTXSAPR0111	Country/2L Sppl.Jur.Code/2L Rec.Jur.Code	19	KBETR	Condition Rate	decimal	15	2
24	/1CN/CTXSAPR0112	Country/2L Sppl.Jur.Code/2L Rec.Jur.Code/Tax Tariff Code	20	KBETR	Condition Rate	decimal	15	2
25	/1CN/CTXSAPR0113	Country/2L Sppl.Jur.Code/2L Rec.Jur.Code/Product Tax Group	20	KBETR	Condition Rate	decimal	15	2
26	/1CN/CTXSAPR0120	Country/Tax Tariff Code	18	KBETR	Condition Rate	decimal	15	2
27	/1CN/CTXSAPR0130	Country/3L Jur.Code	18	KBETR	Condition Rate	decimal	15	2
28	/1CN/CTXSAPR0131	Country/3L Jur.Code/Product Tax Group	19	KBETR	Condition Rate	decimal	15	2
29	/1CN/CTXSAPR0140	Country/Tax Event/Jurisdiction Code	19	KBETR	Condition Rate	decimal	15	2
30	/1CN/CTXSAPR0201	Country/Tax Code	18	KBETR	Condition Rate	decimal	15	2
31	/1CN/CTXSAPRBR01	Country/Tax Tariff Code	18	KBETR	Condition Rate	decimal	15	2
32	/1CN/CTXSAPRBR02	Country/Product Tax Group	18	KBETR	Condition Rate	decimal	15	2
33	/1CN/CTXSAPRBR03	Country/Product Tax Group/Business Partner Tax Group	19	KBETR	Condition Rate	decimal	15	2
34	/1CN/CTXSAPRBR10	Country/1L Sppl.Jur.Code/1L Rec.Jur.Code	19	KBETR	Condition Rate	decimal	15	2
35	/1CN/CTXSAPRBR11	Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Tax Tariff Code	20	KBETR	Condition Rate	decimal	15	2
36	/1CN/CTXSAPRBR12	Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Product Tax Group	20	KBETR	Condition Rate	decimal	15	2
37	/1CN/CTXSAPRBR20	Country/2L Jur.Code	18	KBETR	Condition Rate	decimal	15	2
38	/1CN/CTXSAPRBR21	Country/2L Jur.Code/Product Tax Group	19	KBETR	Condition Rate	decimal	15	2
39	/1CN/CTXSAPRIN03	Country/Tax Tariff Code/Business Partner ID	19	KBETR	Condition Rate	decimal	15	2
40	/1CN/CTXSAPRIN04	Recipient Country/Tax Tariff Code/Business Partner ID	19	KBETR	Condition Rate	decimal	15	2
41	/1CN/CTXSAPRIN06	Country/Spl Reg./Rec Region/Tax Group/Tax Group	21	KBETR	Condition Rate	decimal	15	2
42	/1CN/CTXSAPRIN07	Country/Partner ID/Recip. Tax Region/Tax Group	20	KBETR	Condition Rate	decimal	15	2
43	/1CN/CTXSAPS0100	Country/Business Process	18	KBETR	Condition Rate	decimal	15	2
44	/1CN/CTXSAPS0101	Country/Bus. Transaction	18	KBETR	Condition Rate	decimal	15	2
45	/1CN/CTXSAPS0102	Country/Bus. Transaction	18	KBETR	Condition Rate	decimal	15	2
46	/1CN/CTXSAPW0201	Country/Tax Code	18	KBETR	Condition Rate	decimal	15	2
47	/1CN/CTXSAPW0202	Country/Business Partner Tax Group	18	KBETR	Condition Rate	decimal	15	2
48	/1CN/CTXSAPX0100	Country/Region	18	KBETR	Condition Rate	decimal	15	2
49	/1CN/CTXSAPX0101	Country/Supplier BP ID/Business Partner ID	19	KBETR	Condition Rate	decimal	15	2
50	/1CN/CTXSAPX0102	Country/Business Partner Tax Group	18	KBETR	Condition Rate	decimal	15	2
51	/1CN/CTXSAPX0103	Country/Supplier BP ID/Business Partner ID/Product Tax Group	20	KBETR	Condition Rate	decimal	15	2
52	/1CN/CTXSAPX0104	Recipient Country/Recipient Tax Region/Locat. Relationship	19	KBETR	Condition Rate	decimal	15	2
53	/1CN/CTXSAPX0105	Country/Product Tax Group	18	KBETR	Condition Rate	decimal	15	2
54	/1CN/CTXSAPX0106	Country/Region/Product Tax Group	19	KBETR	Condition Rate	decimal	15	2
55	/1CN/CTXSAPX0140	Country/Product Tax Group/Jurisdiction Code	19	KBETR	Condition Rate	decimal	15	2
56	/1CN/CTXSAPX0141	Country/Business Partner Tax Group/Jurisdiction Code	19	KBETR	Condition Rate	decimal	15	2
57	/1CN/CTXSAPX0146	Country/Region/Product Tax Group	19	KBETR	Condition Rate	decimal	15	2
58	/1CN/CTXSAPX0147	Country/Region/Business Partner Tax Group	19	KBETR	Condition Rate	decimal	15	2
59	/1CN/CTXSAPX0148	Country	17	KBETR	Condition Rate	decimal	15	2
60	/1CN/CTXSAPXBR01	Country/Tax Tariff Code	18	KBETR	Condition Rate	decimal	15	2
61	/1CN/CTXSAPXBR02	Country/Product Tax Group	18	KBETR	Condition Rate	decimal	15	2
62	/1CN/CTXSAPXBR03	Country/Product Tax Group/Business Partner Tax Group	19	KBETR	Condition Rate	decimal	15	2
63	/1CN/CTXSAPXBR11	Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Tax Tariff Code	20	KBETR	Condition Rate	decimal	15	2
64	/1CN/LBPSCALEV01	Scale Table - Variable Data Part of a Scale	4	KBETR	Condition Rate	decimal	15	2
65	/1CN/LBPSCALEV02	Scale Table - Variable Data Part of a Scale	5	KBETR	Condition Rate	decimal	15	2
66	/1CN/LPTSCALEV01	Scale Table - Variable Data Part of a Scale	4	KBETR	Condition Rate	decimal	15	2
67	/1CN/LPTSCALEV02	Scale Table - Variable Data Part of a Scale	5	KBETR	Condition Rate	decimal	15	2
68	/1CN/LTXSCALEV01	Scale Table - Variable Data Part of a Scale	4	KBETR	Condition Rate	decimal	15	2
69	/1CN/LTXSCALEV02	Scale Table - Variable Data Part of a Scale	5	KBETR	Condition Rate	decimal	15	2
70	/BGLOCS/VATMAITM	VAT Margin Items	22	KBETR	Tax Rate	decimal	11	2
71	/CCEE/SIFI_UMSIT	Tax items applied for decrease/increase of input VAT	13	KBETR	Tax Rate	decimal	11	2
72	/SLOAP/PRICING_2	Conditions (1-Dimensional Quantity Scale)	6	KBETR	Rate (condition amount or percentage)	decimal	11	2
73	BSET	Tax Data Document Segment	28	KBETR	Tax Rate	decimal	11	2
74	FIEUD_GOODS_I	SAFT-XML:Goods Movement Line Items	51	KBETR	Rate (condition amount or percentage)	decimal	11	2
75	FIEUD_MMINVTAX	SAFT:MM: TAX Information for E-XML MM invoice for LU	12	KBETR	Rate (condition amount or percentage)	decimal	11	2
76	FIEUD_MMINV_I	SAFT:MM: Item Details for XML Purchase Invoice	29	KBETR	Rate (condition amount or percentage)	decimal	11	2
77	FISKD_VATCNTRL	Document's information reported to SK authorities	19	KBETR	Tax Rate	nvarchar	6	0
78	FUDT_VDOCBSET	Tax Data Document Segment of Verification Document	28	KBETR	Tax Rate	decimal	11	2
79	FUDT_VDOCBSETH	Tax Data Document Segment of Verification Document(History)	28	KBETR	Tax Rate	decimal	11	2
80	J_1UF_INV_REF	Document references to FI Invoice processed items	17	KBETR	Rate (condition amount or percentage)	decimal	11	2
81	J_1UF_VAT_DISTR	VAT distribution coefficient for Ukraine	6	KBETR	Rate (condition amount or percentage)	decimal	11	2
82	J_3RVATD_RUN	Stored VAT-return Runs: Main Section	13	KBETR	Tax Rate	decimal	11	2
83	J_3RVATD_RUN_TA	Stored VAT-return Runs: Tax Agent Section	13	KBETR	Tax Rate	decimal	11	2
84	KONV	Conditions (Transaction Data)	11	KBETR	Rate (condition amount or percentage)	decimal	11	2
TOPAccounting Interface
85	GLE_FI_ITEM_MODF	ECS: Modified FI Line Items (Header/Item/Currency Data)	69	KBETR	Rate (condition amount or percentage)	decimal	11	2
86	GLE_FI_ITEM_ORIG	ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)	69	KBETR	Rate (condition amount or percentage)	decimal	11	2
TOPAustria
87	PA0136	HR Master Record: Infotype 0136 (Garn. Transfer A)	30	KBETR	Amount of Transfer of Costs	decimal	9	2
TOPConditions
88	KOND	Conditions (Data)	60	KBETR	Rate (condition amount or percentage) where no scale exists	decimal	11	2
89	KONM	Conditions (1-Dimensional Quantity Scale)	6	KBETR	Rate (condition amount or percentage)	decimal	11	2
90	KONP	Conditions (Item)	14	KBETR	Rate (condition amount or percentage) where no scale exists	decimal	11	2
91	KONW	Conditions (1-Dimensional Value Scale)	6	KBETR	Rate (condition amount or percentage)	decimal	11	2
TOPCost Center Accounting
92	TKRSTR	Transport Resource Prices	18	KBETR	Rate (condition amount or percentage) where no scale exists	decimal	11	2
TOPCross-Application Components
93	VKONV	Conditions (Transaction Data)	11	KBETR	Rate (condition amount or percentage)	decimal	11	2
TOPEmpties Management
94	/BEV1/EMLGKTO	Empties Account	50	KBETR	Rate (condition amount or percentage) where no scale exists	decimal	11	2
TOPExchanges
95	OIA12ICOND	Conditions of OIA12I items	8	KBETR	Rate (condition amount or percentage)	decimal	11	2
96	OIANF	Fee Condition Records	11	KBETR	Rate (condition amount or percentage)	decimal	11	2
TOPFinancial Accounting
97	DEFTAX_ITEM	Data for Deferred Taxes	16	KBETR	Tax Rate	decimal	11	2
98	T007V	Tax Codes to be Transported	8	KBETR	Rate (condition amount or percentage)	decimal	11	2
TOPFreight Processing
99	VFSCAR1	Freight Rates (One-Dimensional)	6	KBETR	Rate (condition amount or percentage) where no scale exists	decimal	11	2
100	VFSCAR2	Freight Rates (Two-Dimensional)	6	KBETR	Rate (condition amount or percentage) where no scale exists	decimal	11	2
101	VFSCAR3	Freight Rates (Three-Dimensional)	7	KBETR	Rate (condition amount or percentage) where no scale exists	decimal	11	2
TOPGermany
102	PA0116	HR Master Record: Infotype 0116 (Garn. Transfer D)	30	KBETR	Amount of Transfer of Costs	decimal	9	2
TOPGlobal Trade
103	WB2_D_PRASP	Trading Contract: pricing aspects	12	KBETR	Rate (condition amount or percentage) where no scale exists	decimal	11	2
TOPHandheld Connectivity
104	/DSD/PR_RSAM	MDSD Promotions - Promotion Result Amounts	5	KBETR	Rate (condition amount or percentage)	decimal	11	2
TOPIncentive and Commission Management ICM
105	CACS_DOCFI_T	Data Transfer: FI Document (Tax Item)	12	KBETR	Rate (condition amount or percentage) where no scale exists	decimal	11	2
TOPIntegration
106	FKK_KONV_SHORT	Price Conditions for SD Billing Document - Extracts	15	KBETR	Rate (condition amount or percentage)	decimal	11	2
TOPInvoice Verification
107	RBDIFFKO	Invoice Verification - Conditions	15	KBETR	Rate (condition amount or percentage)	decimal	11	2
TOPJoint Venture und Production Sharing Accounting
108	JVKONV	IS-Oil / Joint Venture / Data table for CRP pricing data	11	KBETR	Rate (condition amount or percentage)	decimal	11	2
TOPLocalization
109	IDGT_CODE_LC	Tax Catalog Code	5	KBETR	VAT Tax Rate	decimal	9	2
110	J_1BFIFOIN	Incoming FIFO relevant Consignment movements (BRAZIL)	20	KBETR	Rate (condition amount or percentage)	decimal	11	2
111	J_1BFIFOOUT	Outgoing FIFO relevant Consignment movements (BRAZIL)	19	KBETR	Rate (condition amount or percentage)	decimal	11	2
112	J_1IKONV	Excise recalculated conditions	15	KBETR	Rate (condition amount or percentage)	decimal	11	2
113	J_1IRAINCND	Article Inward Note Conditions	6	KBETR	Rate (condition amount or percentage)	decimal	11	2
114	J_1ISER_BSEG	Transaction table having the Invoices with Service Category	19	KBETR	Tax Rate	decimal	11	2
115	J_3RFSEC_ITEM	Data for Secondary events for deferred tax	20	KBETR	Tax Rate	decimal	11	2
116	RFIDPTAAV	Pro-Rata Asset Acquisition Value	13	KBETR	Tax Rate	decimal	11	2
TOPLogistics Execution
117	/DSD/PE_CNDRDI	Pricing: Retrieved Condition Records - Item Info.	5	KBETR	Rate (condition amount or percentage) where no scale exists	decimal	11	2
118	/DSD/PE_CNDRDQ	Pricing: Retrieved Condition Records - Quan. Scale	6	KBETR	Rate (condition amount or percentage)	decimal	11	2
119	/DSD/PE_CNDRDV	Pricing: Retrieved Condition Records - Value Scale	6	KBETR	Rate (condition amount or percentage)	decimal	11	2
TOPMarketing, Accounting and Pricing
120	OIC_KONV	Conditions (Procedure Data)	11	KBETR	Rate (condition amount or percentage)	decimal	11	2
121	OIC_OIANF	Fee Condition Records	11	KBETR	Rate (condition amount or percentage)	decimal	11	2
TOPOverhead Cost Controlling
122	KONR	Resource Prices: Help Table for Variable Fields	26	KBETR	Rate (condition amount or percentage) where no scale exists	decimal	11	2
123	KONR1	Resource Prices: Help Table for Variable Fields	26	KBETR	Rate (condition amount or percentage) where no scale exists	decimal	11	2
TOPOverhead Cost Orders
124	KONX	Overhead Rates: Help Table for Variable Fields	23	KBETR	Rate (condition amount or percentage) where no scale exists	decimal	11	2
125	KONX1	Overhead Rates: Help Table for Variable Fields	23	KBETR	Rate (condition amount or percentage) where no scale exists	decimal	11	2
126	TKZUTR	Transport Overhead Records	18	KBETR	Rate (condition amount or percentage) where no scale exists	decimal	11	2
TOPPatient Accounting
127	NVKONV	IS-H: Conditions	10	KBETR	Rate (condition amount or percentage)	decimal	11	2
TOPPeriodical Sales and Distribution
128	JKONV	IS-M/SD: Conditions (Transaction Data)	11	KBETR	Rate (condition amount or percentage)	decimal	11	2
129	JLTPST2	IS-M/SD: Main Data for Batch Input Postal Charges	7	KBETR	Amount field for batch input	nvarchar	15	0
130	JLTPST3	IS-M/SD: Scale Data for Batch Input Postal Charges	6	KBETR	Amount field for batch input	nvarchar	15	0
TOPPricing
131	PRCD_COND	Price Condition - Item - Condition (KONV)	49	KBETR	Condition Rate	decimal	15	2
132	PRCM_TABL_000	Reference Table for Condition Tables (A000)	17	KBETR	Condition Rate	decimal	15	2
TOPRecycling Administration Core Functions
133	J_7LP03	REA Price List: Conditions	11	KBETR	Formula: Amount	decimal	17	2
TOPRemaining Beverage - Obsolete Objects
134	/BEV1/BO_DATA	Proof Table for Rebate Processing	26	KBETR	Rate (condition amount or percentage) where no scale exists	decimal	11	2
135	/BEV1/RBKP	Copy Table for KONP for Accrual (Field KBRUE)	14	KBETR	Rate (condition amount or percentage) where no scale exists	decimal	11	2
136	/BEV1/RBWE	Itemized Proof Rebate Settlement	19	KBETR	Rate (condition amount or percentage) where no scale exists	decimal	11	2
TOPRetail Pricing
137	WPFDO	Family Pricing: Diff. Dist. Chain-Depnd. Price Relationships	9	KBETR	Amount for the Price Relationship for a Family Group	decimal	11	2
138	WPFGR	Family Pricing: Defintion of Family Groups	9	KBETR	Amount for the Price Relationship for a Family Group	decimal	11	2
TOPService Station Retailing
139	OIRADBT	Document base table	24	KBETR	Rate (condition amount or percentage)	decimal	11	2
140	OIRC_GMMH	SSR Meters - History	26	KBETR	SSR Meters - Actual price	decimal	11	2
141	OIRC_GMMH_DEL	SSR Meters - Deleted meter readings history	27	KBETR	SSR Meters - Actual price	decimal	11	2
142	OIRC_MRREJ	SSR Meters - Meter readings rejected records	29	KBETR	SSR Meters - Actual price	decimal	11	2
143	OIRC_PRCHK	SSR Pricing - Price check	11	KBETR	SSR Pricing - Actual price	decimal	11	2
TOPSubsequent Settlement
144	EBABG	Settlement Runs Subsequent Settlement, Interval Scales	11	KBETR	Rate (condition amount or percentage)	decimal	11	2
145	EBABP	Settlement Runs Subsequent Settlement, Condition Record	12	KBETR	Rate (condition amount or percentage) where no scale exists	decimal	11	2
TOPWaste Management
146	EEWA_BULK_DATA	Bulk refuse order data	12	KBETR	Rate (condition amount or percentage)	decimal	11	2

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

146 columns | ERP 6.0 | KBETR