	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

109 columns | ERP 6.0 | MATERIAL

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/AIF/T_CIFPP_IDX	Standard Index Table for CIF Postprocessing	36	MATERIAL	External Product Identifier	nvarchar	40	0
2	/BIC/B0000190000	PSA for 0MM_PUR_PURCH_DATA T90CLNT090 Purchasing Data	14	MATERIAL		nvarchar	18	0
3	/CIDEON/PRD	Table	9	MATERIAL	Material Number	nvarchar	18	0
4	/OEE/MPH_KPITARG	Plant Hierarchy KPI Target Details	5	MATERIAL	Material Number	nvarchar	18	0
5	/OEE/MPH_MRKDWN	Plant Hierarchy Node Mark Parent Down	7	MATERIAL	Material Number	nvarchar	18	0
6	/OEE/MPH_NODESTR	Plant Hierarchy Node Standard Rate	7	MATERIAL	Material Number	nvarchar	18	0
7	/OPT/AT_APPR_HIS	Approval History for Level Based Approvals	36	MATERIAL	Material Number	nvarchar	18	0
8	/OPT/AT_LBA_LOG	Approval History for Level Based Approvals	37	MATERIAL	Material Number	nvarchar	18	0
9	/PLMB/RCA_BALITM	Balancing Item Assignments	5	MATERIAL	Material Number	nvarchar	18	0
10	/PLMI/GSS_R2B_AB	Split Points for Additional BOMs in R2B Synchronization	6	MATERIAL	Material Number	nvarchar	18	0
11	/PLMI/PPE_C_TMPL	Template table	4	MATERIAL	Material Number	nvarchar	18	0
12	/SAPQUERY/T211	Single Container Flight Booking	12	MATERIAL	Material number	nvarchar	18	0
13	/XLSO/ADVERTISE	Advertisements	12	MATERIAL	Material Number	nvarchar	18	0
14	EHPRCD_WL_CA_E	Compl. Assmnt. Worklist - Worklist entry	9	MATERIAL	Material	nvarchar	18	0
15	J_1ILOCGOODS	EXIM : Letter of Credit Good	7	MATERIAL	Material Description (Short Text)	nvarchar	40	0
16	MRP_ACC_SHORTAGE	All shortages that are accepted	9	MATERIAL	Material Number	nvarchar	18	0
17	MRP_BUFFER_RUN03	Buffer Run Lock table	4	MATERIAL	Material Number	nvarchar	18	0
18	MRP_BUF_DEM_ITEM	Supply demand items and uncovered demand items	3	MATERIAL	Material Number	nvarchar	18	0
19	MRP_BUF_MATERIAL	Buffer Table Material	2	MATERIAL	Material Number	nvarchar	18	0
20	MRP_BUF_PLAN_SG1	Buffer Table Planning Segment	3	MATERIAL	Material Number	nvarchar	18	0
21	MRP_BUF_SDIV_TOT	Supply Demand Items View Totals	3	MATERIAL	Material Number	nvarchar	18	0
22	MRP_BUF_SHORT_ST	Buffer Table Shortage Statistics	3	MATERIAL	Material Number	nvarchar	18	0
23	MRP_BUF_SUPPLIER	Buffer Table Supplier	3	MATERIAL	Material Number	nvarchar	18	0
24	PPH_CACHE_ITEM	Supply demand items and uncovered demand items	3	MATERIAL	Material Number	nvarchar	18	0
25	PPH_CACHE_MAT	Cache Table Material	2	MATERIAL	Material Number	nvarchar	18	0
26	PPH_CACHE_PLSEG	Cache Table Planning Segment	3	MATERIAL	Material Number	nvarchar	18	0
27	PPH_CACHE_SDIVTO	Supply Demand Items View Totals	3	MATERIAL	Material Number	nvarchar	18	0
28	PPH_CACHE_SHRTST	Cache Table Shortage Statistics	3	MATERIAL	Material Number	nvarchar	18	0
29	PPH_CACHE_SUPPL	Cache Table Supplier	3	MATERIAL	Material Number	nvarchar	18	0
30	QAMC_MAT_SYS	Material and Logical System	2	MATERIAL	Material	nvarchar	40	0
31	QAM_L_BCV_A	QIM: Temporary Storage Activities f. Business Context Viewer	22	MATERIAL	Material	nvarchar	40	0
32	QAM_L_BCV_I	QIM: Temporary Storage Issues for Business Context Viewer	9	MATERIAL	Material	nvarchar	40	0
33	REQLINE	Administrative Line Data: Requirement Coverage Request	10	MATERIAL	Material Number	nvarchar	18	0
34	REQLINEMA	Temporary Line Data: Requirement Coverage Request(MRO Lines)	11	MATERIAL	Material Number	nvarchar	18	0
35	SESI_DEMO_MAT	SESI DEMO: Material	1	MATERIAL	SRT FT Tests: Single Material Item	nvarchar	20	0
36	ZPRJDET	Project details	8	MATERIAL	Material Number	nvarchar	18	0
37	ZRDB_DEL_DIR	16.09.2009: Delete DIR	70	MATERIAL	Materialnummer	nvarchar	18	0
38	ZTEST_MDGM_PLM	Mapping table between PLM and MDGM	4	MATERIAL	Material Number	nvarchar	18	0
TOPBrowser-Based PI Sheet Cockpit
39	POC_DB_ARC_CONN	Optical Archiving: Link Data (ArchiveLink)	17	MATERIAL	Material Number for Order	nvarchar	18	0
TOPBudgeting and Availability Control
40	GMBDGTLINE	Budget Document Line	26	MATERIAL	Material Number	nvarchar	18	0
41	GMHBDGTLINE	Budget Line: Held Documents	27	MATERIAL	Material Number	nvarchar	18	0
TOPComplaints and Returns
42	/SPE/INSPECRESH	Inspection Outcome: Header	13	MATERIAL	Material Number	nvarchar	18	0
TOPCross-Application Component CA Enhancements
43	/SAPMP/MIG_T005	Migration CS -> DIMP: Object Status Production Version	2	MATERIAL	Material Number	nvarchar	18	0
TOPCross-Application Components
44	/OPT/S_GR_LIN	VSS Stageing Table: GR Line	10	MATERIAL	Material Number	nvarchar	18	0
45	/OPT/S_INV_LIN	VSS Staging Table: Invoice lines	10	MATERIAL	Material Number	nvarchar	18	0
46	/OPT/S_PO_LIN	VSS Staging Table: PO Line items	7	MATERIAL	Material Number	nvarchar	18	0
TOPDealer Portal
47	/SAPDII/CIMGMANT	Image Maintenance	3	MATERIAL	Material Number	nvarchar	18	0
48	/SAPDII/DLRSTOCK	Maintain dealer stock	3	MATERIAL	Material Number	nvarchar	18	0
49	/SAPDII/SPP_MATE	Materials table	3	MATERIAL	Field length 18	nvarchar	18	0
TOPDistributor-Reseller-Management
50	/SAPHT/DRMAGRWL	DRM - worklist table for agreement negotiation	6	MATERIAL	Material Number	nvarchar	18	0
51	/SAPHT/DRMBUDL	Bill Up Due List	9	MATERIAL	Material Number	nvarchar	18	0
52	/SAPHT/DRMCONEXT	DRM Ship and debit agreement extracts	8	MATERIAL	Material Number	nvarchar	18	0
53	/SAPHT/DRMDETL	DRM Audit Trail	51	MATERIAL	Material Number	nvarchar	18	0
54	/SAPHT/DRMFIFINV	DRM Inventory Reconciliation FIFO Inventory	19	MATERIAL	Material Number	nvarchar	18	0
55	/SAPHT/DRMHEAD	DRM FIFO Header	5	MATERIAL	Material Number	nvarchar	18	0
56	/SAPHT/DRMPPDL	Price Protection Due List	5	MATERIAL	Material Number	nvarchar	18	0
57	/SAPHT/DRMR3XN	DRM relevant ERP Transactions	35	MATERIAL	Material Number	nvarchar	18	0
58	/SAPHT/DRMSDDL	Ship and Debit Due List	16	MATERIAL	Material Number	nvarchar	18	0
59	/SAPHT/DRMSLSRPT	DRM 867 Outbound processing table	3	MATERIAL	Material Number	nvarchar	18	0
60	/SAPHT/DRMSTAG	DRM Staging Area	19	MATERIAL	Material Number	nvarchar	18	0
61	KOTW002	Sales org./Distr. chl/Division/Material	7	MATERIAL	Material Number	nvarchar	18	0
62	KOTW501	Material	4	MATERIAL	Material Number	nvarchar	18	0
TOPEnvironment, Health and Safety
63	/TDAG/RCSA_CAPOS	Campaign position data	4	MATERIAL	Material Number	nvarchar	18	0
TOPGrantee Management
64	GMIA	Actual Line Item Table	52	MATERIAL	Material Number	nvarchar	18	0
TOPGrants Management - Specific Postings
65	GMBRSD	SD OBJECTS for a GRANT	5	MATERIAL	Material Number	nvarchar	18	0
TOPIntegration Customer Relationship Management
66	EPDESC	IS-U MD template description: header entries	8	MATERIAL	Material Number	nvarchar	18	0
67	ESALES_UTILPROD	Utility products	3	MATERIAL	Material Number	nvarchar	18	0
TOPInvoice Verification
68	TCULIV	Customizing: Direct Posting in Log. Invoice Verification	3	MATERIAL	Posting to Material Is Active	nvarchar	1	0
TOPManagement of Internal Controls
69	FOPCDEFICSEL	MIC: Selection Conditions for Deficiency Analysis	7	MATERIAL	Misstatement Magnitude Is Material (%)	decimal	5	2
TOPMarketing, Accounting and Pricing
70	OICQOIL	F&A Oil Table for Repository Default	5	MATERIAL	Material Number	nvarchar	18	0
71	OIC_FORM_ATTRIB	Attributes of Business Context for F&A Formula	16	MATERIAL	Material Number	nvarchar	18	0
TOPMaster Data
72	EPDPROD	IS-U Master Data Generator: Master Data Template	13	MATERIAL	Material Number	nvarchar	18	0
TOPNetWeaver Enterprise Search
73	ESH_TST_EH_RTI	Real Time Indexing Test Data	3	MATERIAL	Char 20	nvarchar	20	0
TOPNetwork Operations
74	GHO_PP_PTABLE_IT	Item Table for Results of GHO Planning Table	8	MATERIAL	Material Relevant for Allocation	nvarchar	18	0
TOPPegging, Grouping, and Distribution
75	TBLP_COST_ITEM	TBLP temporary store of costs for accurate payback	12	MATERIAL	Material Number	nvarchar	18	0
TOPPeriodical Sales and Distribution
76	JLHDEXTINTERFACE	IS-M: External Interface for Home Delivery Settlement	7	MATERIAL	Material Number	nvarchar	18	0
77	TJL42	IS-M/SD: Master Data for External Contract Arrangement Det.	7	MATERIAL	Material Number	nvarchar	18	0
78	TJL44	IS-M/SD: Master Data for External Contract Arrangement Det.	7	MATERIAL	Material Number	nvarchar	18	0
TOPProcess Controls
79	GRPCDEFICSEL	PC: Selection Conditions for Deficiency Analysis	7	MATERIAL	Misstatement Magnitude Is Material (%)	decimal	5	2
TOPProduct Data Management
80	CONV_FILE	Clipboard for Objects to Convert	20	MATERIAL	Material Number	nvarchar	18	0
TOPProduction Allocation
81	GHO_ALLOCRES_I	Allocation results Item	10	MATERIAL	Material Relevant for Allocation	nvarchar	18	0
82	GHO_ALLOCRES_IF	Allocation results Item with Final Indicator	10	MATERIAL	Material Relevant for Allocation	nvarchar	18	0
83	GHO_ALLOC_FIN_I	OBSOLETE - Table to store final itemized allocation results	10	MATERIAL	Material Relevant for Allocation	nvarchar	18	0
84	GHO_ALLOC_FIN_PP	Table to hold PP related final allocation results	9	MATERIAL	Material Relevant for Allocation	nvarchar	18	0
85	GHO_ALLOC_RES_I	OBSOLETE - Table to store the itemized allocation results	10	MATERIAL	Material Relevant for Allocation	nvarchar	18	0
86	GHO_ALLOC_RES_PP	Table to hold PP related allocation results	9	MATERIAL	Material Relevant for Allocation	nvarchar	18	0
TOPRecipe Development
87	/PLMB/RFO_FRMITM	Formula items	8	MATERIAL	Material Number	nvarchar	18	0
88	/PLMI/GSS_R2B_SU	Sync Units for Recipe to BOM	18	MATERIAL	Material Number	nvarchar	18	0
TOPRemote Logistics Management
89	OIO_CM_DOC_FLOW	RLM document flow index	7	MATERIAL	Material number	nvarchar	18	0
TOPResourcen Management
90	FRMLT_MOD_DATA	Modeling Items	6	MATERIAL	Material Number of an Item	nvarchar	18	0
TOPSales and Distribution
91	ZZDEA_QTY	DEA quantity limits per customer and material	3	MATERIAL	Material Number	nvarchar	18	0
TOPSAP NetWeaver Mobile - Use subcomponents
92	MEREP_TEST_CUST	MI Test Tool - Customize Tables with Values	8	MATERIAL	General Flag	nvarchar	1	0
93	MEREP_TMATLIST	MI Testtool - Material List for BoM	4	MATERIAL	MI:Testcases - Material	nvarchar	18	0
TOPSAP Retail Store
94	WGMP_SRS	Items for SRS PDC Goodsmovement	6	MATERIAL	Material Number	nvarchar	18	0
95	WSGM_ITEM_DB_TMP	SRS GM: Temporary Persistence for Item Data	4	MATERIAL	Material Number	nvarchar	18	0
96	WSGR_ITEM_DB_TMP	SRS GR: Temporary Persistence for Item Data	4	MATERIAL	Material Number	nvarchar	18	0
97	WSTI_DB_TMP_ITEM	SAP Retail Store temporary persistence item table	8	MATERIAL	Material Number	nvarchar	18	0
TOPSCM Basis
98	CIFBALSEL	Application Log: CIF Extension for Log Selection	7	MATERIAL	Material Number	nvarchar	18	0
99	CIFERRLOG	Error Recording in Enhanced CIF Error Handling	30	MATERIAL	Material Number	nvarchar	40	0
TOPSerial Numbers
100	T377X	Documents Allowed for Serial Number Management	14	MATERIAL	Optionality of Parameter Transfer	nvarchar	1	0
TOPStructures
101	PSHLP_CUST_DPROF	Data Selection Profile	23	MATERIAL		nvarchar	1	0
TOPTax Reporting
102	OIUX1_PDCD_XREF	Cross Reference Between State Agency and PRA Material	5	MATERIAL	Material Number	nvarchar	18	0
TOPTraders and Schedulers Workbench
103	OIJ03_LOVGLREF	TSW Gain loss/LOV Reference table	7	MATERIAL	Loaded/Discharged Material	nvarchar	18	0
TOPTransportation and Distribution
104	OIGRMM	TD Rack Meter / Material Assignment	3	MATERIAL	Material Number	nvarchar	18	0
TOPVehicle Management System
105	CVLC24	VELO : Assign Vehicle Model to VMS Roles	3	MATERIAL	Vehicle Model	nvarchar	18	0
TOPWaste Management
106	EWA_ORDER_HD_CO	Header Table for Waste Disposal Order (CO Data)	28	MATERIAL	Receiving Material	nvarchar	18	0
107	EWA_ORDER_OBJ_CO	Item Table in Waste Disposal Order (CO Data)	29	MATERIAL	Receiving Material	nvarchar	18	0
108	EWA_ORDER_WGH_CO	Weighing Data Table for Waste Disposal Order (CO Data)	29	MATERIAL	Receiving Material	nvarchar	18	0
109	EWA_WA_WPROC_CO	Weighing Transaction (CO Data)	28	MATERIAL	Receiving Material	nvarchar	18	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

109 columns | ERP 6.0 | MATERIAL