	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

85 columns | ERP 6.0 | PLNAL

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/PLMI/GSS_R2M_SU	GSS Recipe -> Master Recipe: Sync Units Table	13	PLNAL	Group Counter	nvarchar	2	0
2	SGT_PLKOS	Task list - header - Segmentation	4	PLNAL	Group Counter	nvarchar	2	0
3	ZPS12	Project system: Text symbol assign. Standard netw/Routing	5	PLNAL	Group Counter	nvarchar	2	0
4	ZPS12F	Project system: Text symbol assign. Standard netw/Routing	5	PLNAL	Group Counter	nvarchar	2	0
TOPActive Quality Control
5	QDQL	Quality level	6	PLNAL	Group Counter	nvarchar	2	0
TOPActual CostingMaterial Ledger
6	CKMLMV013	Assignment table: Process for production order	21	PLNAL	Group Counter	nvarchar	2	0
7	FCML_ALT	Alternatives	12	PLNAL	Group Counter	nvarchar	2	0
8	FCML_PROC	Business Processes	14	PLNAL	Group Counter	nvarchar	2	0
TOPCapacity Leveling
9	PIBA	Process planning interface: Production requirements	16	PLNAL	Group Counter	nvarchar	2	0
10	TCYTM	Transition matrix	17	PLNAL	Group Counter	nvarchar	2	0
TOPControl Plan
11	QPCPD_ITEM	Item of Control Plan	12	PLNAL	Group Counter	nvarchar	2	0
TOPCross-Application Components
12	MMAPL	Allocation of task lists to materials	6	PLNAL	Group Counter	nvarchar	2	0
TOPData Collection
13	S161	Inspection Results: General	29	PLNAL	Group Counter	nvarchar	2	0
14	S162	Quantitative Inspection Results	29	PLNAL	Group Counter	nvarchar	2	0
15	S163	Quantitative Inspection Result: Vendor	30	PLNAL	Group Counter	nvarchar	2	0
16	S164	Quantitative Inspection Result: Vendor	30	PLNAL	Group Counter	nvarchar	2	0
17	S165	Inspection Results (General): Customers	29	PLNAL	Group Counter	nvarchar	2	0
18	S166	Quantitative Inspection Results: Customer	30	PLNAL	Group Counter	nvarchar	2	0
TOPDistribution Requirements Planning
19	PLPLAN_PARAM	BOM-dependent planning parameter	12	PLNAL	Group Counter	nvarchar	2	0
TOPEnvironment, Health and Safety
20	EHQMT_IP_MEMORY	EH&S-QM: Memorize Created Inspection Plans	3	PLNAL	Group Counter	nvarchar	2	0
TOPFlow Manufacturing
21	LDLBP	Line balance items	12	PLNAL	Group Counter	nvarchar	2	0
TOPInspection Planning
22	PLMW	MAPL-Dependent Charac. Specifications (Inspection Plan)	13	PLNAL	Group Counter	nvarchar	2	0
23	QMIPD_SPECIP_MAT	Mapping Table Between Inspection Plan and EHS Specification	6	PLNAL	Group Counter	nvarchar	2	0
24	QMIPD_SPECMATLOG	Status of Synchr. Between Inspection Plan and Specification	6	PLNAL	Group Counter	nvarchar	2	0
TOPIntegrated Product and Process Engineering
25	CMIG_MAPPING	Mapping Table (Classic PP and iPPE Objekt Key)	11	PLNAL	Group Counter	nvarchar	2	0
TOPLogbook
26	ADFSH_PRTDET	Flight Scheduling: PRT Detail	11	PLNAL	Group Counter	nvarchar	2	0
27	ADFSH_PRTMAS	Flight Scheduling: PRT Master	11	PLNAL	Group Counter	nvarchar	2	0
TOPMaintenance History
28	HIKO	Order master data history	26	PLNAL	Group Counter	nvarchar	2	0
TOPMaintenance Notifications
29	QMIH	Quality message - maintenance data excerpt	36	PLNAL	Group Counter	nvarchar	2	0
TOPMaintenance Orders
30	/CUM/AFCU	CU: CU Instances	4	PLNAL	CU: Group Counter for Plant in Task List	nvarchar	2	0
31	/CUM/CUNITWERK	CU: TL selection: group center for plant, virtual CUI deter.	3	PLNAL	CU: Group Counter for Plant in Task List	nvarchar	2	0
TOPMaintenance Program Definition
32	MPDITEM	Maintenance Plan Items	16	PLNAL	Group Counter	nvarchar	2	0
33	MPDPSD	MPD: MPD and MP header data	36	PLNAL	Group Counter	nvarchar	2	0
TOPMaintenance Task Lists
34	EAPL	Allocation of task lists to pieces of equipment	5	PLNAL	Group Counter	nvarchar	2	0
35	MPOS	Maintenance item	17	PLNAL	Group Counter	nvarchar	2	0
36	PLWP	Allocation of maintenance packages to task list operations	4	PLNAL	Group Counter	nvarchar	2	0
37	TAPL	Allocation of task lists to functional locations	5	PLNAL	Group Counter	nvarchar	2	0
TOPMaster Data
38	PLAF	Planned Order	62	PLNAL	Group Counter	nvarchar	2	0
TOPMaster Recipe
39	CPC_CMX_DB_COR	Master Recipe: Context Table for Recipe Header	5	PLNAL	Group Counter	nvarchar	2	0
40	CPC_CMX_DB_R_COR	Routing: Context Table for Plan Header	5	PLNAL	Group Counter	nvarchar	2	0
TOPNetwork and Activity
41	MLST	Milestone	15	PLNAL	Alternative to a standard network	nvarchar	2	0
42	PLAB	Relationships	4	PLNAL	Group Counter	nvarchar	2	0
TOPNetwork Objects
43	GHO_IFLOT_EXT	Function location extension table	17	PLNAL	Group Counter	nvarchar	2	0
TOPPermits
44	IHSG	Object-Related Permits in Plant Maintenance	27	PLNAL	Group Counter	nvarchar	2	0
TOPPlant Maintenance
45	S180	APO: Long-Term Planning	4	PLNAL	Group Counter	nvarchar	2	0
46	S180E	S180 - Structure Information	4	PLNAL	Group Counter	nvarchar	2	0
47	Z9I_STK_VORGANG	Terminkontrolle Stillstandsplanung: Relevante Vorgänge	9	PLNAL	Plangruppenzähler	nvarchar	2	0
48	Z9MIANF	Stillstanndsplanung - Daten für Anfragen	8	PLNAL	Plangruppenzähler	nvarchar	2	0
49	Z9MISTP	Stillstandsplanung	6	PLNAL	Plangruppenzähler	nvarchar	2	0
TOPProduct Cost by Period
50	CHZP	Reporting Points - Change History	24	PLNAL	Group Counter	nvarchar	2	0
51	CKPE	CO-PC Cost Object Hierarchy: Individual Objects	8	PLNAL	Group Counter	nvarchar	2	0
TOPProduct Cost Planning
52	KALM	Costing Run: Costing Objects	24	PLNAL	Group Counter	nvarchar	2	0
53	KALO	Costing Run: Costing Objects (KVMK)	18	PLNAL	Group Counter	nvarchar	2	0
54	KEKO	Product Costing - Header Data	28	PLNAL	Group Counter	nvarchar	2	0
TOPProduct Lifecycle Management
55	DIWPS_CR	Work Package Cross-Reference Notification	11	PLNAL	Group Counter	nvarchar	2	0
56	DIWPS_NOTI_PCOMP	Table for Partically Completed Notifications	5	PLNAL	Group Counter	nvarchar	2	0
57	DIWPS_RV_CR	Revision: Cross-Reference Notification	8	PLNAL	Group Counter	nvarchar	2	0
TOPProduction Campaign
58	PCMO3	Pegged production campaign: recipe	10	PLNAL	Group Counter	nvarchar	2	0
TOPProduction Orders
59	AFFL	Work order sequence	6	PLNAL	Group Counter	nvarchar	2	0
60	AFKO	Order Header Data PP Orders	21	PLNAL	Group Counter	nvarchar	2	0
61	AFVC	Operation within an order	6	PLNAL	Group Counter	nvarchar	2	0
TOPQuality Inspection
62	QALS	Inspection lot record	70	PLNAL	Group Counter	nvarchar	2	0
TOPResourcen Management
63	MRTRST_HDR	RMS-MRTRS : MR Transformation Header	23	PLNAL	Group Counter	nvarchar	2	0
64	RMXTT_Q11	Building Blocks for Stability Study: Planning Data	15	PLNAL	Group Counter	nvarchar	2	0
65	RMXTT_TRIAL_QMPL	Trial: Assigned Inspection Plans for Post-Process Control	4	PLNAL	Group Counter	nvarchar	2	0
TOPRouting
66	MAPL	Assignment of Task Lists to Materials	6	PLNAL	Group Counter	nvarchar	2	0
67	PLAS	Task list - selection of operations/activities	4	PLNAL	Group Counter	nvarchar	2	0
68	PLFH	Task list - production resources/tools	18	PLNAL	Group Counter	nvarchar	2	0
69	PLFL	Task list - sequences	4	PLNAL	Group Counter	nvarchar	2	0
70	PLKO	Task list - header	4	PLNAL	Group Counter	nvarchar	2	0
71	PLKZ	Task list: main header	4	PLNAL	Group Counter	nvarchar	2	0
72	PLMZ	Allocation of bill of material items to operations	11	PLNAL	Group Counter	nvarchar	2	0
73	PLSR	Scheduling results	7	PLNAL	Group Counter	nvarchar	2	0
TOPRouting EBOM Assignment
74	/PLMI/RTGRCALNKH	Routing Component Assignment Link	9	PLNAL	Group Counter	nvarchar	2	0
TOPSales Plan
75	P445E	Planning Object Index for Rough-Cut Planning Profiles	7	PLNAL	Group Counter	nvarchar	2	0
TOPSamples and SPC
76	QASH	Quality control chart	8	PLNAL	Group Counter	nvarchar	2	0
TOPScheduling
77	KBED	Capacity Requirements Records	39	PLNAL	Group Counter	nvarchar	2	0
78	KBKO	Header Record for Capacity Requirements	9	PLNAL	Group Counter	nvarchar	2	0
TOPSimulation
79	VSAFFL_CN	Version: Order sequences PP orders	7	PLNAL	Group Counter	nvarchar	2	0
80	VSAFKO_CN	Version: Order header data for PP orders	22	PLNAL	Group Counter	nvarchar	2	0
81	VSAFVC_CN	Version: Operation in order	7	PLNAL	Group Counter	nvarchar	2	0
82	VSKBED_CN	Version: Capacity requirement records	40	PLNAL	Group Counter	nvarchar	2	0
83	VSKBKO_CN	Version: Capacity requirements header for an order	10	PLNAL	Group Counter	nvarchar	2	0
84	VSMLST_CN	Version: Milestone	16	PLNAL	Alternative to a standard network	nvarchar	2	0
85	VSPLAF_CN	Version: Planned order	62	PLNAL	Group Counter	nvarchar	2	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

85 columns | ERP 6.0 | PLNAL