	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

123 columns | ERP 6.0 | APLZL

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/SMERP/KBED_EX	Exchange Table - Capacity Requirements	5	APLZL	General counter for order	nvarchar	8	0
2	/SYCLO/AUFPL_EX	Syclo Exchange Table - Maintenance Work Order	5	APLZL	General counter for order	nvarchar	8	0
3	AUAA	Settlement Document: Receiver Segment	28	APLZL	Internal counter	nvarchar	8	0
4	BSAD_BAK	Accounting: Secondary index for customers (cleared items)	99	APLZL	Internal counter	nvarchar	8	0
5	BSAK_BAK	Accounting: Secondary Index for Vendors (Cleared Items)	103	APLZL	Internal counter	nvarchar	8	0
6	BSEG	Accounting Document Segment	225	APLZL	General counter for order	nvarchar	8	0
7	BSID_BAK	Accounting: Secondary Index for Customers	99	APLZL	Internal counter	nvarchar	8	0
8	BSIK_BAK	Accounting: Secondary index for vendors	103	APLZL	Internal counter	nvarchar	8	0
9	BSSEG	Accounting Document Segment	214	APLZL	General counter for order	nvarchar	8	0
10	FUDT_VDOCBSEG	Verification Document Item with Additional Info	214	APLZL	General counter for order	nvarchar	8	0
11	FUDT_VDOCBSEGEV	Verification Document Item in the Entry View	214	APLZL	General counter for order	nvarchar	8	0
12	FUDT_VDOCBSEGH	Verification Document Segment with Additional Info(History)	214	APLZL	General counter for order	nvarchar	8	0
13	GLPOS_C_CT	FI Document: Entry View	44	APLZL	General counter for order	nvarchar	8	0
14	GLPOS_C_DEB_CT	GLPOS_C_CT Customer Line Items	44	APLZL	General counter for order	nvarchar	8	0
15	GLPOS_C_GL_CT	GLPOS_C_CT G/L Line Items	44	APLZL	General counter for order	nvarchar	8	0
16	GLPOS_C_VEN_CT	GLPOS_C_CT Vendor Line Items	44	APLZL	General counter for order	nvarchar	8	0
17	GLPOS_N_CT	New General Ledger: Line Item with Currency Type	44	APLZL	General counter for order	nvarchar	8	0
18	GLPOS_N_GL_CT	New General Ledger: Line Item with Currency Type	44	APLZL	General counter for order	nvarchar	8	0
19	ODTF_IDOC_LOG_NA	Travel on Demand: Log f. Netw. Activity Replication via IDOC	3	APLZL	General counter for order	nvarchar	8	0
20	QAOPERATION	Relation between Keyfields of PP and QM	3	APLZL	General counter for order	nvarchar	8	0
21	REGUP	Processed items from payment program	101	APLZL	Internal counter	nvarchar	8	0
22	ZPS22F	Project system: Text symbol assign. Standard network seq.	4	APLZL	Internal counter	nvarchar	8	0
23	ZPS23	Project System: Text Symbol Assignment - Activities	4	APLZL	General counter for order	nvarchar	8	0
TOPAccounting Interface
24	GLE_FI_ITEM_MODF	ECS: Modified FI Line Items (Header/Item/Currency Data)	178	APLZL	Internal counter	nvarchar	8	0
25	GLE_FI_ITEM_ORIG	ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)	178	APLZL	Internal counter	nvarchar	8	0
TOPActual CostingMaterial Ledger
26	CKMLDUVCO	Usage Differences for Each Account Assignment Object	23	APLZL	General counter for order	nvarchar	8	0
TOPAlternative Valuation Run
27	CKMLAVRDOCIT	Lines for Cumulation Posting Document	48	APLZL	Internal counter	nvarchar	8	0
TOPBasic Functions
28	FPLA	Billing Plan	23	APLZL	General counter for order	nvarchar	8	0
29	FPLAPO	Billing Plan	23	APLZL	General counter for order	nvarchar	8	0
30	VFPLA	Billing Plan	23	APLZL	General counter for order	nvarchar	8	0
TOPBilling
31	VBRP	Billing Document: Item Data	202	APLZL	Internal counter	nvarchar	8	0
TOPCapacity Evaluations
32	CYOPR_MOVE	Order-/operation data	3	APLZL	General counter for order	nvarchar	8	0
TOPCapacity Leveling
33	ISTBED	Actual requirements records	8	APLZL	General counter for order	nvarchar	8	0
TOPConfirmations
34	AFFW	Goods Movements with Errors from Confirmations	36	APLZL	Internal counter	nvarchar	8	0
35	AFRU	Order Confirmations	67	APLZL	General counter for order	nvarchar	8	0
TOPCost Object
36	FCO_DOC_HEAD	Failure Cost Document Header	17	APLZL	Internal counter	nvarchar	8	0
TOPCross-Application Components
37	BBSID	Accounting: Secondary index for customers	99	APLZL	Internal counter	nvarchar	8	0
38	ONROS	Object number index for order sequence	4	APLZL	Internal counter	nvarchar	8	0
39	ONROV	Object number index for order process	4	APLZL	Internal counter	nvarchar	8	0
TOPDistribution of Usage Variances
40	CKMLDUVACTCO	Distribution Acty Differences: Diff. Per Acct Assgnmt object	22	APLZL	General counter for order	nvarchar	8	0
41	CKMLDUVNCO	Usage Differences for Each Account Assignment Object	23	APLZL	General counter for order	nvarchar	8	0
42	DUVMSEG_EXTRACT	duv mseg extract for performance	19	APLZL	Internal counter	nvarchar	8	0
TOPExternal Services
43	ESKN	Account Assignment in Service Package	31	APLZL	Internal counter	nvarchar	8	0
TOPFinancial Accounting
44	ACCTIT	Compressed Data from FI/CO Document	141	APLZL	Internal counter	nvarchar	8	0
45	BSAD	Accounting: Secondary Index for Customers (Cleared Items)	99	APLZL	Internal counter	nvarchar	8	0
46	BSAK	Accounting: Secondary Index for Vendors (Cleared Items)	103	APLZL	Internal counter	nvarchar	8	0
47	BSID	Accounting: Secondary Index for Customers	99	APLZL	Internal counter	nvarchar	8	0
48	BSIK	Accounting: Secondary Index for Vendors	103	APLZL	Internal counter	nvarchar	8	0
TOPFreight Processing
49	VFKN	Account Determination in Shipment Costs Item	30	APLZL	Internal counter	nvarchar	8	0
TOPFunds Management
50	KBLP	Document Item: Manual Document Entry	36	APLZL	General counter for order	nvarchar	8	0
TOPGeneral Ledger Accounting
51	BSEG_ADD	Entry View of Accounting Document for Additional Ledgers	47	APLZL	General counter for order	nvarchar	8	0
52	FAGL_SPLINFO	Splittling Information of Open Items	25	APLZL	Internal counter	nvarchar	8	0
TOPGeneral Ledger Reorganization
53	FAGL_R_SPL	Reorganization: Splitting Information of the Open Items	20	APLZL	Internal counter	nvarchar	8	0
TOPInformation System
54	MCAFVGV	Versions: Order Procedure	6	APLZL	Internal counter	nvarchar	8	0
55	MCSFIS	R/2 SFIS Data: Old	69	APLZL	Internal counter	nvarchar	8	0
TOPInterest
56	TZIN1	Document Header Data from Source Document (PS Int.Calc.)	18	APLZL	Internal counter	nvarchar	8	0
TOPInterface to External Project Software
57	NVGUID	GUIDs for Network Activity	4	APLZL	General counter for order	nvarchar	8	0
TOPInventory Management
58	MSEG	Document Segment: Material	116	APLZL	Internal counter	nvarchar	8	0
59	MWXMSEG	ZMSEG: Interface for Posting of Value	116	APLZL	Internal counter	nvarchar	8	0
60	MWZMSEG	ZMSEG:Interface for Posting of Value	116	APLZL	Internal counter	nvarchar	8	0
61	RESB	Reservation/dependent requirements	100	APLZL	Internal counter	nvarchar	8	0
62	RKPF	Document Header: Reservation	33	APLZL	Internal counter	nvarchar	8	0
TOPInvoice Verification
63	RBCO	Document Item, Incoming Invoice, Account Assignment	9	APLZL	Routing number of operations in the order	nvarchar	10	0
TOPJoint Venture und Production Sharing Accounting
64	JVCO1	JV Object Table 2 for JVTO1	6	APLZL	General counter for order	nvarchar	8	0
65	JVPO1	JVA: Plan Line Items	33	APLZL	General counter for order	nvarchar	8	0
66	JVPSC01O	Object table 1	19	APLZL	General counter for order	nvarchar	8	0
67	JVSO1	JV LI Table with Objects for JVTO1	33	APLZL	General counter for order	nvarchar	8	0
68	JVTO1	JV Summary Table with Objects	31	APLZL	General counter for order	nvarchar	8	0
TOPLocal Currency Changeover
69	EWUFI_SCA	EMU conversion: Table of the clearings to be adjusted	22	APLZL	General counter for order	nvarchar	8	0
TOPMaintenance History
70	HIVG	PM order history - operations	6	APLZL	General counter for order	nvarchar	8	0
TOPMaintenance Notifications
71	OPROL	AVO Link to Object List Entry	3	APLZL	General counter for order	nvarchar	8	0
TOPMaintenance Orders
72	/MRSS/D_DEM_PS	Rejected and/or deleted requirements	3	APLZL	General counter for order	nvarchar	8	0
73	AUFM	Goods movements for order	39	APLZL	Internal counter	nvarchar	8	0
TOPMaster Data
74	MDSM	Simulative dependent requirements	83	APLZL	Internal counter	nvarchar	8	0
TOPNetwork and Activity
75	MLST	Milestone	19	APLZL	Internal counter	nvarchar	8	0
TOPOverhead Cost Orders
76	COBRB	Distribution Rules Settlement Rule Order Settlement	43	APLZL	Internal counter	nvarchar	8	0
TOPPlant Maintenance
77	Z9I_STK_IF_NPV	PM/PS-Schnittstelle: Netzplanvorgänge	29	APLZL	Interner Zähler	nvarchar	8	0
78	Z9I_STK_IF_NPV_W	PM/PS-Schnittstelle: Netzplanvorgänge Werkstattsicht	36	APLZL	Interner Zähler	nvarchar	8	0
79	Z9I_STK_VORGANG	Terminkontrolle Stillstandsplanung: Relevante Vorgänge	17	APLZL	Allgemeiner Zähler des Auftrags	nvarchar	8	0
TOPProcess Order
80	AFFT	Order - Process Instructions	3	APLZL	General counter for order	nvarchar	8	0
81	AFFV	Order - Process Instruction Values	3	APLZL	General counter for order	nvarchar	8	0
82	COCR_CMX_DB_CS	Context Data for XSteps	5	APLZL	General counter for order	nvarchar	8	0
83	OPDEV	Order Operation - Schedule Deviations	3	APLZL	General counter for order	nvarchar	8	0
TOPProduct Cost Planning
84	CKIS	Items Unit Costing/Itemization Product Costing	88	APLZL	Continuous Counter for Differentiating Database Entries	nvarchar	8	0
TOPProduct Lifecycle Management
85	DIWPS_NOTI_PCOMP	Table for Partically Completed Notifications	9	APLZL	General counter for order	nvarchar	8	0
TOPProduction Orders
86	AFFL	Work order sequence	3	APLZL	Internal counter	nvarchar	8	0
87	AFSPOPR	Split Operations in an Order Split	3	APLZL	General counter for order	nvarchar	8	0
88	AFVC	Operation within an order	3	APLZL	General counter for order	nvarchar	8	0
89	AFVU	DB structure of the user fields of the operation	3	APLZL	General counter for order	nvarchar	8	0
90	AFVV	DB structure of the quantities/dates/values in the operation	3	APLZL	General counter for order	nvarchar	8	0
91	COWIPB_CHVW	WIP Batches with Where-Used List	26	APLZL	General counter for order	nvarchar	8	0
92	ORDCOM	Communication control Operation download	3	APLZL	General counter for order	nvarchar	8	0
TOPProduction ResourcesTools
93	AFFH	PRT assignment data for the work order	17	APLZL	Internal counter	nvarchar	8	0
TOPProject System
94	PSHLPDB_HIER_TMP	Table to store temporary hierarchy data	14	APLZL	General counter for order	nvarchar	8	0
95	PSHLP_HIER_DB	Local cache:Project/Independent Network hierarchy	14	APLZL	General counter for order	nvarchar	8	0
TOPPurchasing
96	EBKN	Purchase Requisition Account Assignment	33	APLZL	Internal counter	nvarchar	8	0
97	EKKN	Account Assignment in Purchasing Document	36	APLZL	Internal counter	nvarchar	8	0
TOPQuality Inspection
98	QALS	Inspection lot record	189	APLZL	Internal counter	nvarchar	8	0
TOPQuality Notifications
99	TQ8CO	Assignment of reference orders to notification type	11	APLZL	Internal counter	nvarchar	8	0
TOPRemaining Beverage - Obsolete Objects
100	/BEV3/CH1030BSG1	Document Segment CH Event Ledger Part1	216	APLZL	General counter for order	nvarchar	8	0
TOPRepetitive Manufacturing
101	COMPMOVE	Goods Movement of Components	155	APLZL	General counter for order	nvarchar	8	0
TOPScheduling
102	KBED	Capacity Requirements Records	35	APLZL	General counter for order	nvarchar	8	0
TOPSelf-Service Procurement
103	/SRMERP/D_ACC_IT	Account assignment item	30	APLZL	Internal counter	nvarchar	8	0
TOPSimulation
104	VSAFFH_CN	Version: PRT allocation to work order	18	APLZL	Internal counter	nvarchar	8	0
105	VSAFFL_CN	Version: Order sequences PP orders	4	APLZL	Internal counter	nvarchar	8	0
106	VSAFVC_CN	Version: Operation in order	4	APLZL	General counter for order	nvarchar	8	0
107	VSAFVU_CN	Version: User fields in operation in order	4	APLZL	General counter for order	nvarchar	8	0
108	VSAFVV_CN	Version: Quantities/Dates/Values in order operation	4	APLZL	General counter for order	nvarchar	8	0
109	VSEBKN_CN	Version: Purchase requisition account assignment	34	APLZL	Internal counter	nvarchar	8	0
110	VSFPLA_CN	Version: Billing schedule	24	APLZL	General counter for order	nvarchar	8	0
111	VSHIST_NV	Tranfer history for network activity	3	APLZL	General counter for order	nvarchar	8	0
112	VSHIST_OV	Transfer history activity	3	APLZL	General counter for order	nvarchar	8	0
113	VSKBED_CN	Version: Capacity requirement records	36	APLZL	General counter for order	nvarchar	8	0
114	VSMLST_CN	Version: Milestone	20	APLZL	Internal counter	nvarchar	8	0
115	VSRESB_CN	Version: Reservation/Dependent requirements	101	APLZL	Internal counter	nvarchar	8	0
TOPStructures
116	PSHLP_ACT_PM_DT	Table for tracking whether acty dates are determined by pmcs	3	APLZL	General counter for order	nvarchar	8	0
TOPTechnical Application Support
117	CNV_20425_SCA	EMU conversion: Table of the clearings to be adjusted	19	APLZL	General counter for order	nvarchar	8	0
TOPWork Clearance Management
118	WCAE	WCM: Order Operation <-> Approval Group	3	APLZL	General counter for order	nvarchar	8	0
119	WCAEQ	WCM: Log (Order Operation <-> Approval Group)	3	APLZL	General counter for order	nvarchar	8	0
120	WCAF	WCM: Order Operation <-> Work Clearance Document	3	APLZL	General counter for order	nvarchar	8	0
121	WCAFQ	WCM: Log (Order Operation <-> Work Clearance Document)	3	APLZL	General counter for order	nvarchar	8	0
122	WCAS	WCM: Application <-> Order Operation	4	APLZL	General counter for order	nvarchar	8	0
123	WCASQ	WCM: Log (Application <-> Order Operation)	4	APLZL	General counter for order	nvarchar	8	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

123 columns | ERP 6.0 | APLZL