	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

136 columns | ERP 6.0 | ZAEHL

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/SMERP/STG_PM006	Data staging - Equip List Set - Classifications - Cmplx Tab	14	ZAEHL	Sort Item	smallint	5	0
2	/SMERP/STG_PM011	Data staging - Func Loc. LSet - Classifications - Cmplx Tab	14	ZAEHL	Sort Item	smallint	5	0
3	KSSK_CONV	Allocation Table: Object to Class	7	ZAEHL	Sort Item	smallint	5	0
4	SGT_PLKOS	Task list - header - Segmentation	5	ZAEHL	Internal counter	nvarchar	8	0
5	T731	Key Figures in Info Library (Transport Table)	12	ZAEHL	Counter of the calls in the Logistics Information Library	nvarchar	8	0
6	T731P	Info Set Assignment in LIL (Transport Table)	3	ZAEHL	Current item	nvarchar	3	0
7	TCLD	Characteristic Data from Standard	4	ZAEHL	Counter for material	nvarchar	2	0
8	TCY16	Variable overview - column definition	3	ZAEHL	Counter for terms in a column definition for the var. overv.	nvarchar	3	0
9	TVGZU	View Control: Special Table Access	4	ZAEHL	Counter in control tables	nvarchar	2	0
10	ZPS12	Project system: Text symbol assign. Standard netw/Routing	6	ZAEHL	Internal counter	nvarchar	8	0
11	ZPS12F	Project system: Text symbol assign. Standard netw/Routing	7	ZAEHL	Internal counter	nvarchar	8	0
12	ZPS13	Proj.system: Text symbol assign. proced. std.netw./wrk ctr	6	ZAEHL	Internal counter	nvarchar	8	0
TOPAdvertising Management
13	JHTAP	IS-M/AM: Settlement Run Log	7	ZAEHL	Counter in control tables	nvarchar	2	0
TOPBasic Data
14	MKAL_AEND	Change History of Production Version (Recipes Only)	5	ZAEHL	Count parameters	nvarchar	4	0
TOPBasic Functions
15	TVGMO	View Control: Exceptions for Move-Corresponding	4	ZAEHL	Counter in control tables	nvarchar	2	0
TOPBatches
16	TCHW2	Units of Measurement for Batch-Specific Units of Measure	5	ZAEHL	Numerator for a ratio	int	10	0
TOPCAD Integration
17	USRCOBJ	Object Filters for Exploding Product Structures	3	ZAEHL	Counter	int	10	0
TOPClasses
18	KSSK	Allocation Table: Object to Class	7	ZAEHL	Sort Item	smallint	5	0
19	TCLAO	Several Objects in one Class Type	10	ZAEHL	Classification: Sort Item	nvarchar	2	0
TOPComputer Aided Process Planning
20	PLPH	CAPP: Sub-operations	6	ZAEHL	Internal counter	nvarchar	8	0
TOPControlling
21	CPZPBACK	Production Reporting Points Periodic Totals Values (Temp)	5	ZAEHL	Counter for Reporting Points	nvarchar	8	0
22	CPZPTEMP	Production Reporting Points Periodic Totals Values (Temp)	5	ZAEHL	Counter for Reporting Points	nvarchar	8	0
23	QRP_CPZP	Reporting Points - Total Values per Date	6	ZAEHL	Counter for Reporting Points	nvarchar	8	0
TOPCost Object
24	PZPE	Line Items for Measuring Point Update	8	ZAEHL	Counter key	nvarchar	4	0
25	PZPP	Production Measuring Points: Period Values	4	ZAEHL	Counter key	nvarchar	4	0
26	PZPS	Production Measuring Point for Totals Record	4	ZAEHL	Counter key	nvarchar	4	0
TOPCross-Application Components
27	MMAPL	Allocation of task lists to materials	8	ZAEHL	Internal counter	nvarchar	8	0
28	PDS_OPER	PDS Data for Operations and Dependent Data	10	ZAEHL	Internal counter	nvarchar	8	0
29	PLLPO	Task list - operation/activity	5	ZAEHL	Internal counter	nvarchar	8	0
TOPDistribution Requirements Planning
30	PLPLAN_PARAM	BOM-dependent planning parameter	5	ZAEHL	Internal counter	nvarchar	8	0
TOPDocument Management System
31	DRAO	Originals for documents	7	ZAEHL	Counter key	nvarchar	4	0
32	DRAOZ	Additional Files for DMS Originals	8	ZAEHL	Counter key	nvarchar	4	0
TOPEarly Warning System
33	MCY1	Objects: Early Warning	4	ZAEHL	Natural Number	int	10	0
34	MCYB	Objects: Early Warning	3	ZAEHL	Natural Number	int	10	0
35	MCYC	Key Figures: Early Warning	3	ZAEHL	Natural Number	int	10	0
36	MCYD	Early Warning: Groups of Exceptions	3	ZAEHL	Natural Number	int	10	0
37	MCYE	Early Warning: Trend Analysis Requirements	3	ZAEHL	Natural Number	int	10	0
38	MCYM	Objects: Early Warning	3	ZAEHL	Natural Number	int	10	0
TOPEnvironment
39	LKSSK	Allocation Table: Object to Class	7	ZAEHL	Sort Item	smallint	5	0
TOPFlow Manufacturing
40	LDLBC	Takts/no. of ind. capacities per line segment line balance	4	ZAEHL	Internal counter	nvarchar	8	0
41	LDLBT	Line hierarchy entry and exit takts	3	ZAEHL	Internal counter	nvarchar	8	0
42	LDLH	Line hierarchy header	3	ZAEHL	Internal counter	nvarchar	8	0
43	LDLP	Line hierarchy items	4	ZAEHL	Internal counter	nvarchar	8	0
44	LDMDR	Line Hierarchy Material-Dependent Rates	4	ZAEHL	Internal counter	nvarchar	8	0
TOPGeneral status management
45	TJ49	Table for Selection Conditions per SELID	3	ZAEHL	Counter used to differentiate between data base entries	nvarchar	4	0
TOPIndustry-Specific Component Automotive
46	MHIS_UNPACKED	Copy of DB table MHIS (Data category INT4 replaced by NUMC)	4	ZAEHL	Maintenance Package Number	nvarchar	2	0
TOPInformation System
47	MCAFVGV	Versions: Order Procedure	7	ZAEHL	Internal counter	nvarchar	8	0
48	MCSFIS	R/2 SFIS Data: Old	70	ZAEHL	Internal counter	nvarchar	8	0
TOPInspection Planning
49	PLMK	Inspection plan characteristics	7	ZAEHL	Internal counter	nvarchar	8	0
50	PLMW	MAPL-Dependent Charac. Specifications (Inspection Plan)	8	ZAEHL	Internal counter	nvarchar	8	0
TOPIntegrated Product and Process Engineering
51	CMIG_MAPPING	Mapping Table (Classic PP and iPPE Objekt Key)	14	ZAEHL	Internal counter	nvarchar	8	0
TOPLogistics Execution
52	/DSD/PE_PHYSICAL	Header structure of SyncBO 'PhysicalUnit' for pricing engi	5	ZAEHL	Numerator for conversion to SI unit	int	10	0
TOPLogistics Information Library
53	MCLI	Key Figures in Information Library	12	ZAEHL	Counter of the calls in the Logistics Information Library	nvarchar	8	0
54	MCLIP	Info Set Assignment in LIL	3	ZAEHL	Current item	nvarchar	3	0
TOPMaintenance History
55	HIKO	Order master data history	27	ZAEHL	Internal counter	nvarchar	8	0
56	HIVG	PM order history - operations	10	ZAEHL	Internal counter	nvarchar	8	0
TOPMaintenance Notifications
57	QMIH	Quality message - maintenance data excerpt	38	ZAEHL	Internal counter	nvarchar	8	0
TOPMaintenance Program Definition
58	MPDCYCLE	MPD: Cycle Data for Maintenance Document Items	28	ZAEHL	Maintenance Package Number	nvarchar	2	0
TOPMaintenance Task Lists
59	EAPL	Allocation of task lists to pieces of equipment	7	ZAEHL	Internal counter	nvarchar	8	0
60	MHIS	Maintenance plan history	4	ZAEHL	Maintenance Package Number	nvarchar	2	0
61	MMPT	Cycle definitions and MeasPoints for MaintPlan	13	ZAEHL	Maintenance Package Number	nvarchar	2	0
62	PLWP	Allocation of maintenance packages to task list operations	8	ZAEHL	Internal counter	nvarchar	8	0
63	T351P	Maintenance packages	3	ZAEHL	Maintenance Package Number	nvarchar	2	0
64	T351P_OLD	Old Version of Maintenance Packages	3	ZAEHL	Maintenance Package Number	nvarchar	2	0
65	TAPL	Allocation of task lists to functional locations	7	ZAEHL	Internal counter	nvarchar	8	0
TOPMaster Data Distribution
66	/ISDFPS/TL1	Task List - Operation/Activity	5	ZAEHL	Internal counter	nvarchar	8	0
TOPMaster Recipe
67	PLFT	Process Instructions	7	ZAEHL	Internal counter	nvarchar	8	0
68	PLFV	PI Characteristics/Sub-Operation Parameter Values	8	ZAEHL	Internal counter	nvarchar	8	0
TOPMaterial Master
69	MERRDAT_TMP	File for Incorrect Data in Direct Input	3	ZAEHL	10 digit number	nvarchar	10	0
70	MFHM_TMP	File for Incorrect Data in Direct Input	9	ZAEHL	Internal counter	nvarchar	8	0
71	MVHM	MRP material version	6	ZAEHL	Internal counter	nvarchar	8	0
TOPNetwork and Activity
72	MLST	Milestone	3	ZAEHL	Internal counter	nvarchar	8	0
73	PLAB	Relationships	11	ZAEHL	Internal counter	nvarchar	8	0
74	TCNTM03	Assignment of date type/milestone to group	5	ZAEHL	Internal counter	nvarchar	8	0
TOPPeriodical Sales and Distribution
75	JFFS	IS-M/SD: Error Log for Collective Billing Doc.Processing	6	ZAEHL	Counter in control tables	nvarchar	6	0
76	JFXJFFSDL	IS-M: Backup Transfer Internal Table XJFFS	8	ZAEHL	Counter in control tables	nvarchar	2	0
77	JLFS	IS-M/SD: Error Log for Collective Settlement Processing	6	ZAEHL	Counter in control tables	nvarchar	6	0
TOPPlant Maintenance
78	Z9I_STK_VORGANG	Terminkontrolle Stillstandsplanung: Relevante Vorgänge	12	ZAEHL	Interner Zähler	nvarchar	8	0
79	Z9MIANF	Stillstanndsplanung - Daten für Anfragen	10	ZAEHL	Interner Zähler	nvarchar	8	0
80	Z9MISTP	Stillstandsplanung	7	ZAEHL	Interner Zähler	nvarchar	8	0
TOPProcess Order
81	AFFT	Order - Process Instructions	11	ZAEHL	Internal counter	nvarchar	8	0
82	AFFV	Order - Process Instruction Values	13	ZAEHL	Internal counter	nvarchar	8	0
TOPProduct Cost by Period
83	CEZP	Reporting Points Line Items	9	ZAEHL	Counter for Reporting Points	nvarchar	8	0
84	CHZP	Reporting Points - Change History	7	ZAEHL	Counter for Reporting Points	nvarchar	8	0
85	CPZP	Reporting Points - Periodic Totals Values	5	ZAEHL	Counter for Reporting Points	nvarchar	8	0
TOPProduct Cost Planning
86	KEKO	Product Costing - Header Data	67	ZAEHL	Internal counter	nvarchar	8	0
TOPProduct Lifecycle Management
87	DIWPS_CR	Work Package Cross-Reference Notification	12	ZAEHL	Internal counter	nvarchar	8	0
88	DIWPS_RV_CR	Revision: Cross-Reference Notification	9	ZAEHL	Internal counter	nvarchar	8	0
TOPProduction Campaign
89	PCMO1	Pegged production campaign: material	3	ZAEHL	Internal counter	nvarchar	8	0
90	PCMO2	Pegged production campaign: requirements	3	ZAEHL	Internal counter	nvarchar	8	0
91	PCMO3	Pegged production campaign: recipe	3	ZAEHL	Internal counter	nvarchar	8	0
92	PCMO4	Production campaign pegged reqmt resource network	3	ZAEHL	Internal counter	nvarchar	8	0
93	PCMP	Production campaign item	3	ZAEHL	Internal counter	nvarchar	8	0
TOPProduction Orders
94	AFFL	Work order sequence	8	ZAEHL	Internal counter	nvarchar	8	0
95	AFKO	Order Header Data PP Orders	60	ZAEHL	Internal counter	nvarchar	8	0
96	AFVC	Operation within an order	10	ZAEHL	Internal counter	nvarchar	8	0
TOPProduction ResourcesTools
97	CRFH	CIM production resource/tool master data	4	ZAEHL	Internal counter	nvarchar	8	0
TOPQM Control in Procurement
98	QINF	QM-info record for material and vendor	3	ZAEHL	Internal Counter for DB Objects	nvarchar	6	0
TOPQuality Inspection
99	QALS	Inspection lot record	71	ZAEHL	Internal counter	nvarchar	8	0
TOPRemaining Beverage - Obsolete Objects
100	/BEV3/CHCIVBFS	Error Log Collective Run CH Docs. Using Create Invoice	8	ZAEHL	Counter in control tables	nvarchar	2	0
TOPRepetitive Manufacturing
101	T437U	Control Table for Further Processing of Goods Receipts	5	ZAEHL	Help counter	nvarchar	3	0
TOPReporting
102	MCKZSF	Key figures for key figure view	4	ZAEHL	Sequence Number	nvarchar	2	0
103	MCRMK	LIS selection versions: Characteristics	3	ZAEHL	Sequence Number	nvarchar	2	0
104	MCRSV_USR	Selection version: Assigned distribution lists or users	3	ZAEHL	Sequence Number	nvarchar	2	0
TOPResourcen Management
105	MRTRST_HDR	RMS-MRTRS : MR Transformation Header	24	ZAEHL	Internal counter	nvarchar	8	0
106	MRTRST_POP_REL	RMS-MRTRS : General Recipe Operation to Master Recipe Phase	5	ZAEHL	Internal counter	nvarchar	8	0
107	MRTRST_PST_REL	RMS-MRTRS: General Recipe Stage to Master Recipe Operation	5	ZAEHL	Internal counter	nvarchar	8	0
108	MRTRST_QM_REL	RMS-MRTRS : QM of GR Element to QM of MR Element	7	ZAEHL	Internal counter	nvarchar	8	0
109	MRTRST_SEC_REL	RMS-MRTRS: Equipment Requirement to Secondary Resource	5	ZAEHL	Internal counter	nvarchar	8	0
TOPResults Recording
110	QAMV	Characteristic specifications for inspection processing	120	ZAEHL	Internal counter	nvarchar	8	0
TOPRouting
111	MAPL	Assignment of Task Lists to Materials	8	ZAEHL	Internal counter	nvarchar	8	0
112	PLAS	Task list - selection of operations/activities	7	ZAEHL	Internal counter	nvarchar	8	0
113	PLFH	Task list - production resources/tools	5	ZAEHL	Internal counter	nvarchar	8	0
114	PLFL	Task list - sequences	6	ZAEHL	Internal counter	nvarchar	8	0
115	PLKO	Task list - header	5	ZAEHL	Internal counter	nvarchar	8	0
116	PLMZ	Allocation of bill of material items to operations	5	ZAEHL	Internal counter	nvarchar	8	0
117	PLPO	Task list - operation/activity	5	ZAEHL	Internal counter	nvarchar	8	0
TOPScheduling
118	KBED	Capacity Requirements Records	40	ZAEHL	Internal counter	nvarchar	8	0
TOPShipping
119	VBFS	Error Log for Collective Processing	6	ZAEHL	Counter in control tables	nvarchar	2	0
TOPSimulation
120	VSAFFL_CN	Version: Order sequences PP orders	9	ZAEHL	Internal counter	nvarchar	8	0
121	VSAFKO_CN	Version: Order header data for PP orders	61	ZAEHL	Internal counter	nvarchar	8	0
122	VSAFVC_CN	Version: Operation in order	11	ZAEHL	Internal counter	nvarchar	8	0
123	VSHIST_NP	Tranfer history for network	3	ZAEHL	Counter: Transfer objects	nvarchar	8	0
124	VSHIST_NV	Tranfer history for network activity	4	ZAEHL	Counter: Transfer objects	nvarchar	8	0
125	VSHIST_OK	Transfer history material components	5	ZAEHL	Counter: Transfer objects	nvarchar	8	0
126	VSHIST_OR	Transfer history order	3	ZAEHL	Counter: Transfer objects	nvarchar	8	0
127	VSHIST_OV	Transfer history activity	4	ZAEHL	Counter: Transfer objects	nvarchar	8	0
128	VSHIST_PD	Transfer history project definition	3	ZAEHL	Counter: Transfer objects	nvarchar	8	0
129	VSHIST_PR	Transfer history WBS element	3	ZAEHL	Counter: Transfer objects	nvarchar	8	0
130	VSKBED_CN	Version: Capacity requirement records	41	ZAEHL	Internal counter	nvarchar	8	0
131	VSMLST_CN	Version: Milestone	4	ZAEHL	Internal counter	nvarchar	8	0
TOPUnits of Measurement
132	T006	Units of Measurement	11	ZAEHL	Numerator for conversion to SI unit	int	10	0
TOPVariant Configuration
133	CUCO	Additional Data for Configurable Objects	4	ZAEHL	Internal counter	nvarchar	4	0
134	IBVALUEC	CBASE: Redundant Object Doc. on Value Changes for Instance	4	ZAEHL	Numerator for conversion to SI unit	int	10	0
135	KRIF	Richie Riffle	3	ZAEHL	Internal counter for alternative access path	nvarchar	4	0
TOPWork Center
136	KAPE	Capacity unit of measure allocation	5	ZAEHL	Numerator for conversion to SI unit	int	10	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

136 columns | ERP 6.0 | ZAEHL