	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

137 columns | ERP 6.0 | BWKEY

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/ATL/SMR1	Inventory value in "hard" currency	5	BWKEY	Valuation Area	nvarchar	4	0
2	/OPT/VIM_1ITEM_S	Document Item	90	BWKEY	Valuation Area	nvarchar	4	0
3	/OPT/VIM_TITEM	Document Item	90	BWKEY	Valuation Area	nvarchar	4	0
4	/SMD/MD_____00UV	SID-Tabelle fuer Valuation Area	3	BWKEY	Valuation Area	nvarchar	4	0
5	BSEG	Accounting Document Segment	183	BWKEY	Valuation Area	nvarchar	4	0
6	BSIM_BAK	Secondary Index, Documents for Material	3	BWKEY	Valuation Area	nvarchar	4	0
7	BSSEG	Accounting Document Segment	172	BWKEY	Valuation Area	nvarchar	4	0
8	CNV_20000_RSEG	Backup copy of RSEG (line item for incoming invoice)	5	BWKEY	Valuation Area	nvarchar	4	0
9	CNV_20100_T001K	CNV backup copy for T001K	3	BWKEY	Valuation Area	nvarchar	4	0
10	CNV_20100_T001W	CNV backup copy for T001W	4	BWKEY	Valuation Area	nvarchar	4	0
11	FUDT_VDOCBSEG	Verification Document Item with Additional Info	172	BWKEY	Valuation Area	nvarchar	4	0
12	FUDT_VDOCBSEGEV	Verification Document Item in the Entry View	172	BWKEY	Valuation Area	nvarchar	4	0
13	FUDT_VDOCBSEGH	Verification Document Segment with Additional Info(History)	172	BWKEY	Valuation Area	nvarchar	4	0
14	GLPCA_CT	Profit Center Documents	56	BWKEY	Valuation Area	nvarchar	4	0
15	GLPCA_T_CT	Profit Center Documents	72	BWKEY	Valuation Area	nvarchar	4	0
16	GLPOS_C_CT	FI Document: Entry View	74	BWKEY	Valuation Area	nvarchar	4	0
17	GLPOS_C_DEB_CT	GLPOS_C_CT Customer Line Items	74	BWKEY	Valuation Area	nvarchar	4	0
18	GLPOS_C_GL_CT	GLPOS_C_CT G/L Line Items	74	BWKEY	Valuation Area	nvarchar	4	0
19	GLPOS_C_VEN_CT	GLPOS_C_CT Vendor Line Items	74	BWKEY	Valuation Area	nvarchar	4	0
20	GLPOS_N_CT	New General Ledger: Line Item with Currency Type	74	BWKEY	Valuation Area	nvarchar	4	0
21	GLPOS_N_GL_CT	New General Ledger: Line Item with Currency Type	74	BWKEY	Valuation Area	nvarchar	4	0
22	MYMBEW_BUKRS	Index Table for Material Company Code	4	BWKEY	Valuation Area	nvarchar	4	0
23	TCKM2	Valuation Area Control Table	2	BWKEY	Valuation Area	nvarchar	4	0
24	TCO10	Valuation variant for order costing	2	BWKEY	Valuation Area	nvarchar	4	0
25	TKA3C	Automatic Acct. Assignment: Specific Assignments	4	BWKEY	Valuation Area	nvarchar	4	0
26	USRMM	User settings: material master	10	BWKEY	Valuation Area	nvarchar	4	0
27	YVIM_1ITEM	Document Item	90	BWKEY	Valuation Area	nvarchar	4	0
TOPAccounting - General
28	TFC_ALL_ORG	Extracted Master Data	8	BWKEY	Valuation Area	nvarchar	4	0
29	TFC_INST_ALL_OR	Extracted Master Data	10	BWKEY	Valuation Area	nvarchar	4	0
30	TFC_TEMPL_ALL_OR	Extracted Master Data	10	BWKEY	Valuation Area	nvarchar	4	0
TOPAccounting Interface
31	GLE_FI_ITEM_MODF	ECS: Modified FI Line Items (Header/Item/Currency Data)	204	BWKEY	Valuation Area	nvarchar	4	0
32	GLE_FI_ITEM_ORIG	ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)	204	BWKEY	Valuation Area	nvarchar	4	0
TOPActual CostingMaterial Ledger
33	CKMI1	Index for Accounting Documents for Material	13	BWKEY	Valuation Area	nvarchar	4	0
34	CKML2	Material Ledger Header Record (Release 3.xx)	4	BWKEY	Valuation Area	nvarchar	4	0
35	CKMLAB02	Material Update Structure (Assignment to Valuation Area)	2	BWKEY	Valuation Area	nvarchar	4	0
36	CKMLCT	Currency Types and Valuation Types in a Valuation Area	2	BWKEY	Valuation Area	nvarchar	4	0
37	CKMLHD	Material Ledger: Header Record	9	BWKEY	Valuation Area	nvarchar	4	0
38	CKMLHD_AGGR	Material Ledger: Header Record	9	BWKEY	Valuation Area	nvarchar	4	0
39	CKMLKEV	Material Ledger: Cost Component Split (Control Record)	2	BWKEY	Valuation Area	nvarchar	4	0
40	CKMLMV001	Procurement alternatives	4	BWKEY	Valuation Area	nvarchar	4	0
41	CKMLMV002	Assignments material / procurement alternatives	6	BWKEY	Valuation Area	nvarchar	4	0
42	CKMLMV003	Process model: Receipts / mixing strategies	13	BWKEY	Valuation Area	nvarchar	4	0
43	CKMLMV004	Process model: Withdrawals	10	BWKEY	Valuation Area	nvarchar	4	0
44	CKMLMV005	Consumption alternatives	4	BWKEY	Valuation Area	nvarchar	4	0
45	CKMLMV011	Costing run: Object list	5	BWKEY	Valuation Area	nvarchar	4	0
46	CKMLMV011F	Costing Run: Filter Table for Object List	5	BWKEY	Valuation Area	nvarchar	4	0
47	CKMLMV015	Naming rule assignment for materials (header)	4	BWKEY	Valuation Area	nvarchar	4	0
48	CKMLMV_AUX_KALNR	Cost Estimate Numbers for Valuated Objects in QST	4	BWKEY	Valuation Area	nvarchar	4	0
49	CKMLO	Material Ledger: Organizational Jobs	2	BWKEY	Valuation Area	nvarchar	4	0
50	CKMLRUNPLANT	Organizational units in a material ledger costing run	8	BWKEY	Valuation Area	nvarchar	4	0
51	CKMLRUNTYPEBWKEY	Obsolete From Release 4.6A	3	BWKEY	Valuation Area	nvarchar	4	0
52	CKMLV	Material Ledger Control Records	2	BWKEY	Valuation Area	nvarchar	4	0
53	CKMLW	Material Ledger Currencies in Valuation Area	2	BWKEY	Valuation Area	nvarchar	4	0
54	CKML_PRICE_SEND	Customizing Material Price Dispatch	2	BWKEY	Valuation Area	nvarchar	4	0
55	CKMVFM_BSEG_OUT	Display of FI Documents, Transaction CKMVFM, SAP Note 912984	4	BWKEY	Valuation Area	nvarchar	4	0
56	CKMVFM_EXTRACT	Transaction CKMVFM, Extracts, see SAP Note 912984	11	BWKEY	Valuation Area	nvarchar	4	0
57	CKMVFM_OUT	Output for the Value_Flow_Monitor, see SAP Note 912984	12	BWKEY	Valuation Area	nvarchar	4	0
58	FCML_ALT	Alternatives	3	BWKEY	Valuation Area (Alternative)	nvarchar	4	0
59	FCML_MAT	ML Characteristics for Material (Selection Criteria)	6	BWKEY	Valuation Area	nvarchar	4	0
60	FCML_PROC	Business Processes	3	BWKEY	Valuation Area (Process)	nvarchar	4	0
61	MLARC_IDX	Index for ML Document	4	BWKEY	Valuation Area	nvarchar	4	0
62	MLIT	Material Ledger Document: Items	8	BWKEY	Valuation Area	nvarchar	4	0
63	TCKMLBNKSZ	Assignment of Delivery Costs Structure	4	BWKEY	Valuation Area	nvarchar	4	0
64	TMLCCSCR	Act.Cost Comp. Split: Data Range in Valuation Area (Curr)	2	BWKEY	Valuation Area	nvarchar	4	0
65	TMLCCSHD	Act.Cost Comp. Split: Data Range in Valuation Area (General)	2	BWKEY	Valuation Area	nvarchar	4	0
TOPAlternative Valuation Run
66	CKMLAVRDOCIT	Lines for Cumulation Posting Document	13	BWKEY	Valuation Area	nvarchar	4	0
TOPBalance Sheet Valuation Procedures
67	MYLAUFIT	Object Table for Delta Run Using MRN9	9	BWKEY	Valuation Area	nvarchar	4	0
68	TNIW5W	Lowest Value: Devaluatn by Range of Cov. for Each Val. Area	2	BWKEY	Valuation Area	nvarchar	4	0
69	TNIW6W	Lowest Value: Devaluation for Slow/Non-movement by Val.Area	2	BWKEY	Valuation Area	nvarchar	4	0
70	TNIW9	Reduction of Sales Prices (Lowest Value)	2	BWKEY	Valuation Area	nvarchar	4	0
TOPBatches
71	WBEW	Active Ingredient Valuation	3	BWKEY	Valuation Area	nvarchar	4	0
TOPElectronic Bank Statement
72	FEB_ACCNT_SAVE	Saving of Posting Lines for Postprocessing (Account Assign.)	40	BWKEY	Valuation Area	nvarchar	4	0
73	FEB_ACT	Acct Assignment Templates	40	BWKEY	Valuation Area	nvarchar	4	0
TOPFinancial Accounting
74	/OPT/VIM_1ITEM	Document Item	90	BWKEY	Valuation Area	nvarchar	4	0
75	ACCTIT	Compressed Data from FI/CO Document	76	BWKEY	Valuation Area	nvarchar	4	0
76	J_1GZSPVAT	Accounts substitutions for VAT report	3	BWKEY	Valuation Area	nvarchar	4	0
77	VBSEGS	Document Segment for Document Parking - G/L Account Database	61	BWKEY	Valuation Area	nvarchar	4	0
TOPFunds Management-Specific Postings
78	FMFUNDTRANSYEAR	Additional Documents for Funds Transfer to Diff. Years	60	BWKEY	Valuation Area	nvarchar	4	0
79	PSOSEGS	Recurring Request Document Segment, G/L Accounts	59	BWKEY	Valuation Area	nvarchar	4	0
TOPGeneral Ledger Accounting
80	BSEG_ADD	Entry View of Accounting Document for Additional Ledgers	111	BWKEY	Valuation Area	nvarchar	4	0
TOPGL Account Posting
81	TCJ_POSITIONS	Cash Journal Document Items	47	BWKEY	Valuation Area	nvarchar	4	0
TOPIndustry Solution Catch Weight Management
82	/CWM/MIG_MBEWMUT	MBEW Master Segments	3	BWKEY	Valuation Area	nvarchar	4	0
TOPInventory Management
83	MMINKON	Worklist for Inconsistent Materials	2	BWKEY	Valuation Area	nvarchar	4	0
84	MMINKON_UP	Corrections due to Technical Problems with Stock	7	BWKEY	Valuation Area	nvarchar	4	0
85	MWXVM07M	Fields: Update Control of Module Pool SAPMM07M	32	BWKEY	Valuation Area	nvarchar	4	0
86	MWZVM07M	Fields: Update Control of Module Pool SAPMM07M	32	BWKEY	Valuation Area	nvarchar	4	0
87	ORIG_PR_MBEW	Sales Price Origin of Last Total Revaluation at Retail	3	BWKEY	Valuation Area	nvarchar	4	0
88	T134H	Organiz. Unit: Business Area Determ. - MM View	2	BWKEY	Valuation Area	nvarchar	4	0
89	T134M	Control of Qty/Value Update	2	BWKEY	Valuation Area	nvarchar	4	0
90	TASSIGN_MM_T001W	Aux. Table for Status Info SD Maintenance View: Key VKORG	2	BWKEY	Valuation Area	nvarchar	4	0
91	USEG	Retail Revaluation Document: Revaluation Segment	7	BWKEY	Valuation Area	nvarchar	4	0
TOPInvoice Verification
92	BSIM	Secondary Index, Documents for Material	3	BWKEY	Valuation Area	nvarchar	4	0
93	RBMA	Document Item: Incoming Invoice for Material	8	BWKEY	Valuation Area	nvarchar	4	0
94	RSEG	Document Item: Incoming Invoice	9	BWKEY	Valuation Area	nvarchar	4	0
TOPJoint Venture und Production Sharing Accounting
95	T8JD	Valuation type with JV-information	2	BWKEY	Valuation Area	nvarchar	4	0
TOPLocal Currency Changeover
96	EWUCKMLW	EMU: Currencies for material ledger	3	BWKEY	Valuation Area	nvarchar	4	0
TOPLocalization
97	J_1AINFINV	Inflation: Invoices for Replacement Value Determination	8	BWKEY	Valuation Area	nvarchar	4	0
98	J_1AINFMBW	Material Master - Inflation	3	BWKEY	Valuation Area	nvarchar	4	0
99	J_1AINFT16	Warehouse report ( data of previous fiscal years )	3	BWKEY	Valuation Area	nvarchar	4	0
100	J_1BLPP	Average Tax Rates for Reimbursement	3	BWKEY	Valuation Area	nvarchar	4	0
101	J_1BNFLIN	Nota Fiscal line items	5	BWKEY	Valuation Area	nvarchar	4	0
TOPLogistics Basic Data
102	DMF_D_T001W	Transferred Sites	4	BWKEY	Valuation Area	nvarchar	4	0
TOPMaterial Master
103	EBEW	Sales Order Stock Valuation	3	BWKEY	Valuation Area	nvarchar	4	0
104	EBEWH	Valuation of Sales Order Stock: History	3	BWKEY	Valuation Area	nvarchar	4	0
105	MABW	Management of Differently Maintained Material Data in Retail	10	BWKEY	Valuation Area	nvarchar	4	0
106	MBEW	Material Valuation	3	BWKEY	Valuation Area	nvarchar	4	0
107	MBEWH	Material Valuation: History	3	BWKEY	Valuation Area	nvarchar	4	0
108	MBEW_TMP	File for Incorrect Data in Direct Input	6	BWKEY	Valuation Area	nvarchar	4	0
109	MOFF	Outstanding Material Master Records	8	BWKEY	Valuation Area	nvarchar	4	0
110	MSTA	Material Master Status	15	BWKEY	Valuation Area	nvarchar	4	0
111	MVEW	Material Valuation	3	BWKEY	Valuation Area	nvarchar	4	0
112	MVEWH	Material Valuation: History	3	BWKEY	Valuation Area	nvarchar	4	0
113	OBEW	Valuated Stock with Subcontractor	3	BWKEY	Valuation Area	nvarchar	4	0
114	OBEWH	Valuated Stock with Subcontractor: History	3	BWKEY	Valuation Area	nvarchar	4	0
115	QBEW	Project Stock Valuation	3	BWKEY	Valuation Area	nvarchar	4	0
116	QBEWH	Valuation of Project Stock: History	3	BWKEY	Valuation Area	nvarchar	4	0
117	T149	Valuation type/valuation class	2	BWKEY	Valuation Area	nvarchar	4	0
118	T149A	Valuation types for valuation area	2	BWKEY	Valuation Area	nvarchar	4	0
119	T149B	Valuation Category/Valuation type	2	BWKEY	Valuation Area	nvarchar	4	0
120	USRM1	Material Master User Settings: Organizational Levels	11	BWKEY	Valuation Area	nvarchar	4	0
TOPMaterials Management
121	/SAPNEA/J_SC_ACT	Activate Subcontracting with Chargeable Components	2	BWKEY	Valuation Area	nvarchar	4	0
122	J_1GVL_WHB015	FI reposting settings	2	BWKEY	Valuation Area	nvarchar	4	0
TOPOverhead Cost Controlling
123	PFFLD	Period-End Partner: Organizational Log Information	13	BWKEY	Valuation Area	nvarchar	4	0
TOPPlant Master
124	T001K	Valuation area	2	BWKEY	Valuation Area	nvarchar	4	0
125	T001W	Plants/Branches	4	BWKEY	Valuation Area	nvarchar	4	0
TOPProduct Cost Planning
126	KEKO	Product Costing - Header Data	11	BWKEY	Valuation Area	nvarchar	4	0
127	KNOB	Assignment of Cost Est. Number to Config. Object	3	BWKEY	Valuation Area	nvarchar	4	0
128	TCK14	Overhead Groups	2	BWKEY	Valuation Area	nvarchar	4	0
129	TCK15	Descriptions for Overhead Groups	3	BWKEY	Valuation Area	nvarchar	4	0
130	TCK33	Assignment of Condition Types to Origin Group	8	BWKEY	Valuation Area	nvarchar	4	0
TOPProfit Center Accounting
131	GLPCA	EC-PCA: Actual Line Items	59	BWKEY	Valuation Area	nvarchar	4	0
132	GLPCP	EC-PCA: Plan Line Items	120	BWKEY	Valuation Area	nvarchar	4	0
TOPReal Estate Management
133	VIAKBSEG	Document Line Item from SCS for Interface	38	BWKEY	Valuation Area	nvarchar	4	0
TOPRemaining Beverage - Obsolete Objects
134	/BEV3/CH1030BSG1	Document Segment CH Event Ledger Part1	174	BWKEY	Valuation Area	nvarchar	4	0
TOPSAP Healthcare - Industry-Specific Components for Hospitals
135	NWCHGALDAT	IS-H CH: Zuordnung Materialnummer->Pharmacode (GalDat)	10	BWKEY	Area valorizzazione	nvarchar	4	0
TOPTariffs, Duties and Permits
136	OIH_TAX_REV	Excise Duty Revaluation Documents	9	BWKEY	Valuation Area	nvarchar	4	0
TOPVehicle Management System
137	VLCBATCHACT	VELO : Variant for Action Execution in Batch	5	BWKEY	Valuation Area	nvarchar	4	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

137 columns | ERP 6.0 | BWKEY