	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

149 columns | ERP 6.0 | VORNR

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/BIC/B0000103000	PSA for /CPD/PFP_DS_AFVC T90CLNT090 DataSource for NWA	5	VORNR		nvarchar	4	0
2	/BIC/B0000103001	PSA for /CPD/PFP_DS_AFVC T90CLNT090 DataSource for NWA	5	VORNR		nvarchar	4	0
3	/BIC/B0000111000	Error Stack DTP_00O2TFWN1YKGA5W5VMZCQUQ9C 0001	4	VORNR		nvarchar	4	0
4	/OPT/VIM_1ITEM_S	Document Item	57	VORNR	Operation/Activity Number	nvarchar	4	0
5	/OPT/VIM_TITEM	Document Item	57	VORNR	Operation/Activity Number	nvarchar	4	0
6	/SYCLO/AUFNR_M1	Syclo - Work Order Mobile Data Header	3	VORNR	Operation/Activity Number	nvarchar	4	0
7	P2B2_C1	HCM Declustering B2 - Cost Distribution Table C1	16	VORNR	Operation/Activity Number	nvarchar	4	0
8	P2B2_CWST	HCM Declustering B2 - PDC Time Tickets	104	VORNR	Operation/Activity Number	nvarchar	4	0
9	P2B2_WST	HCM Declustering B2 - PDC Time Tickets	104	VORNR	Operation/Activity Number	nvarchar	4	0
10	P2PL_RETROADJ	Payroll Result PL: Retro, originals and changes	26	VORNR	Operation/Activity Number	nvarchar	4	0
11	P2PL_RETRODIF	Payroll Result PL: Retro, originals and changes	26	VORNR	Operation/Activity Number	nvarchar	4	0
12	P2PL_RETROMEM	Payroll Result PL: Retro, originals and changes	26	VORNR	Operation/Activity Number	nvarchar	4	0
13	P2RG_COSTS	Distribution of Employer's Cost (Payroll Function XDEC)	33	VORNR	Operation/Activity Number	nvarchar	4	0
14	P2RT_CZDAV	P18_03	17	VORNR	Operation/Activity Number	nvarchar	4	0
15	P2RU_COSTS	Distribution of Employer's Cost (Payroll Function XDEC)	33	VORNR	Operation/Activity Number	nvarchar	4	0
16	P2RX_C1	Cost Distribution Table C1	14	VORNR	Operation/Activity Number	nvarchar	4	0
17	P2RX_FUND	Accounting Structure for Funds Management	26	VORNR	Operation/Activity Number	nvarchar	4	0
18	S981	OF ARTICLES POSTES	9	VORNR	Numéro d'opération	nvarchar	4	0
19	S981E	S981 - Info structurelles	4	VORNR	Numéro d'opération	nvarchar	4	0
20	S983	SUIVI ATELIER	10	VORNR	Numéro d'opération	nvarchar	4	0
21	S983E	S983 - Info structurelles	5	VORNR	Numéro d'opération	nvarchar	4	0
22	YVIM_1ITEM	Document Item	57	VORNR	Operation/Activity Number	nvarchar	4	0
23	ZMES_RES_PO	MES: Rescheduled Production Order	3	VORNR	Operation/Activity Number	nvarchar	4	0
24	ZQUALITY_PARMS	Inspection Lot Parameters for material quality task lists	4	VORNR	Operation/Activity Number	nvarchar	4	0
TOPABAP List-Based PI Sheet
25	COFTP	PI Sheet: Process Instructions	7	VORNR	Operation/Activity Number	nvarchar	4	0
TOPAccounting Interface
26	GLE_FI_ITEM_MODF	ECS: Modified FI Line Items (Header/Item/Currency Data)	399	VORNR	Operation/Activity Number	nvarchar	4	0
27	GLE_FI_ITEM_ORIG	ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)	399	VORNR	Operation/Activity Number	nvarchar	4	0
TOPActive Quality Control
28	QDQL	Quality level	14	VORNR	Operation Number in the Quality Level	nvarchar	4	0
TOPAttendancesAbsences
29	CATSHR	Cross-Application Time Sheet (CATS): Transfer to HR	34	VORNR	Operation/Activity Number	nvarchar	4	0
TOPConfirmations
30	AFRD	Default values for collective confirmation	62	VORNR	Operation/Activity Number	nvarchar	4	0
31	AFRP0	Table of planned changes for confirmation (PDC)	14	VORNR	Operation/Activity Number	nvarchar	4	0
32	AFRU	Order Confirmations	70	VORNR	Operation/Activity Number	nvarchar	4	0
33	AFRV	Confirmation pool	24	VORNR	Operation/Activity Number	nvarchar	4	0
34	AFRV_DEL	Backup Copy for Confirmation Pool	24	VORNR	Operation/Activity Number	nvarchar	4	0
TOPConstruction Industry
35	T5DB4	HR Construction Site File	8	VORNR	Operation/Activity Number	nvarchar	4	0
36	T5DB8	Construction Sector: Team Assignment to Work Site	30	VORNR	Operation/Activity Number	nvarchar	4	0
37	T5DBV	Construction Pay: Cost Assignment: Hostels	13	VORNR	Operation/Activity Number	nvarchar	4	0
38	T5DBX	Construction Pay: Incentive Wage Connection	13	VORNR	Operation/Activity Number	nvarchar	4	0
TOPCost Object
39	FCO_DOC_HEAD	Failure Cost Document Header	18	VORNR	Operation/Activity Number	nvarchar	4	0
TOPCross-Application Components
40	PLLPO	Task list - operation/activity	16	VORNR	Operation/Activity Number	nvarchar	4	0
TOPData Collection
41	S022	SFIS: Order Operation Data for Work Center	16	VORNR	Operation/Activity Number	nvarchar	4	0
42	S022E	S022 - Structural information	7	VORNR	Operation/Activity Number	nvarchar	4	0
43	S028	Reporting Point Statistics	15	VORNR	Reporting Point	nvarchar	4	0
44	S028E	S028 - Structural Information	10	VORNR	Reporting Point	nvarchar	4	0
45	S161	Inspection Results: General	28	VORNR	QMIS Operation Number	nvarchar	4	0
46	S162	Quantitative Inspection Results	30	VORNR	QMIS Operation Number	nvarchar	4	0
47	S163	Quantitative Inspection Result: Vendor	29	VORNR	QMIS Operation Number	nvarchar	4	0
48	S164	Quantitative Inspection Result: Vendor	31	VORNR	QMIS Operation Number	nvarchar	4	0
49	S165	Inspection Results (General): Customers	30	VORNR	QMIS Operation Number	nvarchar	4	0
50	S166	Quantitative Inspection Results: Customer	31	VORNR	QMIS Operation Number	nvarchar	4	0
TOPData Transfer
51	PPDIT	Transfer to Accounting: Lines in HR IDOCs	22	VORNR	Operation/Activity Number	nvarchar	4	0
52	PPDST	Transfer to Accounting: Substituted Acc. Assig. Object	11	VORNR	Operation/Activity Number	nvarchar	4	0
53	PPKIX	Transfer FI/CO: Index of Account Assignment Combinations	13	VORNR	Operation/Activity Number	nvarchar	4	0
TOPElectronic Bank Statement
54	FEB_ACCNT_SAVE	Saving of Posting Lines for Postprocessing (Account Assign.)	33	VORNR	Operation/Activity Number	nvarchar	4	0
55	FEB_ACT	Acct Assignment Templates	33	VORNR	Operation/Activity Number	nvarchar	4	0
TOPESS Based on WD ABAP
56	HRESS_D_CATS_FAV	CATS Favorites: database table	125	VORNR	Operation/Activity Number	nvarchar	4	0
TOPFinancial Accounting
57	/OPT/VIM_1ITEM	Document Item	57	VORNR	Operation/Activity Number	nvarchar	4	0
58	KMZEI	FI: Account Assignment Model Item Information	79	VORNR	Operation/Activity Number	nvarchar	4	0
59	KOMU	Account Assignment Templates for G/L Account Items	79	VORNR	Operation/Activity Number	nvarchar	4	0
60	VBSEGA	Document Segment for Document Parking - Asset Database	51	VORNR	Operation/Activity Number	nvarchar	4	0
61	VBSEGS	Document Segment for Document Parking - G/L Account Database	102	VORNR	Operation/Activity Number	nvarchar	4	0
TOPFreight Processing
62	VFKN	Account Determination in Shipment Costs Item	27	VORNR	Operation/Activity Number	nvarchar	4	0
TOPFunds Management
63	KBLP	Document Item: Manual Document Entry	105	VORNR	Operation/Activity Number	nvarchar	4	0
TOPFunds Management-Specific Postings
64	FMFUNDTRANSYEAR	Additional Documents for Funds Transfer to Diff. Years	101	VORNR	Operation/Activity Number	nvarchar	4	0
65	PSOSEGS	Recurring Request Document Segment, G/L Accounts	101	VORNR	Operation/Activity Number	nvarchar	4	0
TOPGeneral Ledger Reorganization
66	FAGL_R_SPL	Reorganization: Splitting Information of the Open Items	18	VORNR	Operation/Activity Number	nvarchar	4	0
TOPGL Account Posting
67	TCJ_POSITIONS	Cash Journal Document Items	40	VORNR	Operation/Activity Number	nvarchar	4	0
TOPInformation System
68	MCAFVGV	Versions: Order Procedure	9	VORNR	Operation/Activity Number	nvarchar	4	0
69	MCSFIS	R/2 SFIS Data: Old	72	VORNR	Operation/Activity Number	nvarchar	4	0
TOPInterface to External Project Software
70	NVGUID	GUIDs for Network Activity	6	VORNR	Operation/Activity Number	nvarchar	4	0
TOPInventory Management
71	RESB	Reservation/dependent requirements	99	VORNR	Operation/Activity Number	nvarchar	4	0
TOPInvoice Verification
72	RBCO	Document Item, Incoming Invoice, Account Assignment	65	VORNR	Operation/Activity Number	nvarchar	4	0
TOPJapan
73	T7JPSK_CONTT	Shukko Contract Template	13	VORNR	Operation/Activity Number	nvarchar	4	0
TOPJoint Venture und Production Sharing Accounting
74	JVCO1	JV Object Table 2 for JVTO1	4	VORNR	Operation/Activity Number	nvarchar	4	0
75	JVPO1	JVA: Plan Line Items	34	VORNR	Operation/Activity Number	nvarchar	4	0
76	JVSO1	JV LI Table with Objects for JVTO1	34	VORNR	Operation/Activity Number	nvarchar	4	0
77	JVTO1	JV Summary Table with Objects	29	VORNR	Operation/Activity Number	nvarchar	4	0
TOPLogbook
78	DIACL_DIS_SIG	DS : Order operation within Logbook (For Distribution)	4	VORNR	Operation/Activity Number	nvarchar	4	0
TOPLogistics Information System LIS
79	S281	Order Operation, BW	9	VORNR	Operation/Activity Number	nvarchar	4	0
80	S281BIW1	S281BIW1 * Order Process, BW	9	VORNR	Operation/Activity Number	nvarchar	4	0
81	S281BIW2	S281BIW2 * Order Process, BW	9	VORNR	Operation/Activity Number	nvarchar	4	0
TOPMaintenance History
82	AFVC_DIS_SIG	Digital Signature of Order Operation for Distribution	4	VORNR	Operation/Activity Number	nvarchar	4	0
83	HIMA	PM order history - materials	3	VORNR	Operation/Activity Number	nvarchar	4	0
84	HIVG	PM order history - operations	3	VORNR	Operation/Activity Number	nvarchar	4	0
TOPMaintenance Orders
85	/CUM/ACTIONM	CU: Example Action-Task List Operation Mapping Table	3	VORNR	Operation/Activity Number	nvarchar	4	0
TOPMaster Data
86	MDSM	Simulative dependent requirements	82	VORNR	Operation/Activity Number	nvarchar	4	0
TOPMaster Data Distribution
87	/ISDFPS/TL1	Task List - Operation/Activity	16	VORNR	Operation/Activity Number	nvarchar	4	0
TOPMaterial Identification and Reconciliation
88	BEREIT	Material identification: staging data	7	VORNR	Operation/Activity Number	nvarchar	4	0
89	MISTATUS	Status Table for Material Identification on Mat./Batch Level	7	VORNR	Operation/Activity Number	nvarchar	4	0
TOPPayroll
90	T5TPSC1SPLIT	Rozdelení nákladu	24	VORNR	Císlo operace	nvarchar	4	0
TOPPermits
91	IHSG	Object-Related Permits in Plant Maintenance	17	VORNR	Operation/Activity Number	nvarchar	4	0
TOPPersonnel Time Events
92	TPTCOR_LOGISTIC	Logistics Orders (Correction Scenario)	23	VORNR	Operation number	nvarchar	4	0
TOPPersonnel Time Management
93	ASSOB	Assignment Objects	12	VORNR	Operation/Activity Number	nvarchar	4	0
94	CC1ERP	Incorrect Time Events from CC1, Postings	37	VORNR	Operation number	nvarchar	4	0
95	CC1TEV	Temporary Buffer for Time Events from CC1	29	VORNR	Operation/Activity Number	nvarchar	4	0
96	COIFT	Interface to Activity Allocation	44	VORNR	Operation/Activity Number	nvarchar	4	0
97	PTEX2000	Interface Table for Attendances/Absences Infotype(2001/2002)	54	VORNR	Operation/Activity Number	nvarchar	4	0
98	PTEX2003GEN	Interface Table for IT 2003: General Information	53	VORNR	Operation/Activity Number	nvarchar	4	0
99	PTEX2003SPEC	Interface Table for IT 2003: Interval Information	29	VORNR	Operation/Activity Number	nvarchar	4	0
100	PTEX2010	Interface Table for EE Remuneration Info. Infotype (2010)	53	VORNR	Operation/Activity Number	nvarchar	4	0
101	TEVEN_MORE	Additional Data for Time Events	36	VORNR	Operation number	nvarchar	4	0
TOPPlant Data Collection
102	RUECK	Temp. storage for subsystem confirmations	19	VORNR	Operation/Activity Number	nvarchar	4	0
TOPPlant Maintenance
103	Z9I_STK_IF_NPV	PM/PS-Schnittstelle: Netzplanvorgänge	7	VORNR	Vorgangsnummer	nvarchar	4	0
104	Z9I_STK_IF_NPV_W	PM/PS-Schnittstelle: Netzplanvorgänge Werkstattsicht	7	VORNR	Vorgangsnummer	nvarchar	4	0
105	Z9I_STK_VORGANG	Terminkontrolle Stillstandsplanung: Relevante Vorgänge	14	VORNR	Vorgangsnummer	nvarchar	4	0
106	Z9MIANF	Stillstanndsplanung - Daten für Anfragen	12	VORNR	Vorgangsnummer	nvarchar	4	0
TOPPosition Budgeting and Control
107	HRFPM_DIFFERENCE	HRFPM: Personnel Costs Savings/ Overrun	35	VORNR	Operation/Activity Number	nvarchar	4	0
108	HRFPM_FM_POS	HRFPM: FM Documents - Items	19	VORNR	Operation/Activity Number	nvarchar	4	0
109	HRFPM_FM_POS_BU	HRFPM: FM Documents - Items for Budget	20	VORNR	Operation/Activity Number	nvarchar	4	0
110	HRFPM_FPM_POS	HRFPM: FPM Documents - Items	33	VORNR	Operation/Activity Number	nvarchar	4	0
111	HRFPM_FPM_POS_BU	HRFPM: FPM Documents - Items for Budget	34	VORNR	Operation/Activity Number	nvarchar	4	0
112	HRFPM_OBJECTS	HRFPM: Object table of the commitment engine	29	VORNR	Operation/Activity Number	nvarchar	4	0
TOPProcess Management
113	COCQ	PPPI/QM Integration: Buffer Table for Reporting Results	4	VORNR	Operation/Activity Number	nvarchar	4	0
114	COFT	Process Management: Process Instructions in Control Recipe	5	VORNR	Operation/Activity Number	nvarchar	4	0
115	COMQ	Temporary Storage for Material Production Messages for QM	7	VORNR	Operation/Activity Number	nvarchar	4	0
TOPProduct Cost Planning
116	CKIS	Items Unit Costing/Itemization Product Costing	89	VORNR	Operation/Activity Number	nvarchar	4	0
TOPProduction Orders
117	AFVC	Operation within an order	11	VORNR	Operation/Activity Number	nvarchar	4	0
118	COWIPB_CHVW	WIP Batches with Where-Used List	28	VORNR	Operation/Activity Number	nvarchar	4	0
119	ORDCOM	Communication control Operation download	8	VORNR	Operation/Activity Number	nvarchar	4	0
120	ORDLY	Table of delays for production order	5	VORNR	Operation/Activity Number	nvarchar	4	0
TOPProject System
121	PSHLPDB_HIER_TMP	Table to store temporary hierarchy data	11	VORNR	Operation/Activity Number	nvarchar	4	0
122	PSHLP_HIER_DB	Local cache:Project/Independent Network hierarchy	11	VORNR	Operation/Activity Number	nvarchar	4	0
TOPPurchasing
123	EKCPA	Purchasing Contract Commitment Plan Account Assignment Data	16	VORNR	Operation/Activity Number	nvarchar	4	0
TOPQuality Inspection
124	TQ30	Inspection types	16	VORNR	Operation/Activity Number	nvarchar	4	0
TOPRemote Logistics Management
125	OIO_RT_RTDOC_MT	Returns document - material items	18	VORNR	Operation/Activity Number	nvarchar	4	0
TOPRepetitive Manufacturing
126	COMPMOVE	Goods Movement of Components	120	VORNR	Operation/Activity Number	nvarchar	4	0
127	RMRP	HR Data of Repetitive Manufacturing Backflush	6	VORNR	Operation/Activity Number	nvarchar	4	0
TOPResults Recording
128	QEWL	QM Handheld: Worklist for Transfer	6	VORNR	Operation/Activity Number	nvarchar	4	0
129	QIWL	Transfer table for QM subsystems	5	VORNR	Operation/Activity Number	nvarchar	4	0
TOPRouting
130	PLPO	Task list - operation/activity	16	VORNR	Operation/Activity Number	nvarchar	4	0
TOPSamples and SPC
131	QASH	Quality control chart	34	VORNR	Operation/Activity Number	nvarchar	4	0
TOPScheduling
132	KBED	Capacity Requirements Records	48	VORNR	Operation/Activity Number	nvarchar	4	0
TOPSelf-Service Procurement
133	/SRMERP/D_ACC_IT	Account assignment item	45	VORNR	Operation/Activity Number	nvarchar	4	0
TOPSimulation
134	VSAFVC_CN	Version: Operation in order	12	VORNR	Operation/Activity Number	nvarchar	4	0
135	VSKBED_CN	Version: Capacity requirement records	49	VORNR	Operation/Activity Number	nvarchar	4	0
136	VSRESB_CN	Version: Reservation/Dependent requirements	100	VORNR	Operation/Activity Number	nvarchar	4	0
TOPSocial Insurance
137	T5D3P	HR Technical Assignments for Workers' Compensation Assoc.	8	VORNR	Operation/Activity Number	nvarchar	4	0
TOPStructures
138	PSPR_GRP_IND_PR	Grouping Indicators and purchase requisition numbers	5	VORNR	Operation/Activity Number	nvarchar	4	0
139	PSPR_GR_IND_REL	Assignment of group indicator data	5	VORNR	Operation/Activity Number	nvarchar	4	0
140	PSSKF_RATES_TAB	Save the SKF rates for the calculation of the work duration.	11	VORNR	Operation/Activity Number	nvarchar	4	0
TOPTime Sheet
141	CATS_TEMP	CATS: Database Table for Templates	75	VORNR	Operation/Activity Number	nvarchar	4	0
TOPTime Tickets
142	EVHR	HR Order Confirmations (Times/Time Events)	36	VORNR	Operation number	nvarchar	4	0
143	LSHR	HR Order Confirmations (Durations/Time Tickets)	36	VORNR	Operation number	nvarchar	4	0
TOPTravel Expenses
144	PTRV_DOC_IT	Transfer Travel -> FI/CO: Lines of TRV interm. document	21	VORNR	Operation/Activity Number	nvarchar	4	0
TOPTravel Planning
145	FTPT_REQ_ACCOUNT	Travel Request Cost Assignment	16	VORNR	Operation/Activity Number	nvarchar	4	0
TOPVehicle Management System
146	VLCSMORDNOT	VELO : Link Between Service Notif. and Service Order	6	VORNR	Operation/Activity Number	nvarchar	4	0
TOPWork Clearance Management
147	WCAAP	WCM: Application	38	VORNR	Activity number replaced by sub-network	nvarchar	4	0
148	WCAHE	WCM: Work Clearance Document (Header)	38	VORNR	Activity number replaced by sub-network	nvarchar	4	0
149	WCAW	WCM: Work Approval	36	VORNR	Activity number replaced by sub-network	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

149 columns | ERP 6.0 | VORNR