	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

157 columns | ERP 6.0 | ROUTE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/1RA/0SD010MI	Items for Class SD01 - Raw Data	107	ROUTE	Route	nvarchar	6	0
2	/BIC/B0000177000	PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item	49	ROUTE		nvarchar	6	0
3	/BIC/B0000178000	PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item	90	ROUTE		nvarchar	6	0
4	/BIC/B0000179000	PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule	81	ROUTE		nvarchar	6	0
5	/BIC/B0000180000	PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch.	59	ROUTE		nvarchar	6	0
6	/BIC/B0000182000	PSA for 2LIS_12_VCHDR T90CLNT090 Delivery Header Data	33	ROUTE		nvarchar	6	0
7	/BIC/B0000183000	PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item	27	ROUTE		nvarchar	6	0
8	CE1PR22	Périm. résultat IDES	95	ROUTE	Itinéraire	nvarchar	6	0
9	CE2PR22	Périm. résultat IDES	79	ROUTE	Itinéraire	nvarchar	6	0
10	CE4PR22	Périm. résultat IDES	64	ROUTE	Itinéraire	nvarchar	6	0
11	CE4PR22_ACCT	Périm. résultat IDES	65	ROUTE	Itinéraire	nvarchar	6	0
12	CE4PR22_FLAG	Périm. résultat IDES	61	ROUTE	Flag : caract. imputée manuellement ou via TKEZU	nvarchar	1	0
13	CE4PR22_KENC	Périm. résultat IDES	63	ROUTE	Itinéraire	nvarchar	6	0
14	CNVCMIS_M_VMVLA	CMIS: Temp. Generated Structure for MC-Id	4	ROUTE	Route	nvarchar	6	0
15	CNVCMIS_M_VMVLB	CMIS: Generated Pooltable for Matchcode ID VMVL -B	4	ROUTE	Route	nvarchar	6	0
16	CNVCMIS_M_VMVLC	CMIS: Temp. Generated Structure for MC-Id	5	ROUTE	Route	nvarchar	6	0
17	KOTP511	Material/Plant/Route/Ship-to pt/Ship.type/Stor. Loc./Door	6	ROUTE	Route	nvarchar	6	0
18	MSPT_OIGS	TD Shipment Header to store deleted records	59	ROUTE	Route	nvarchar	6	0
19	SMOI_WS_RFCLOGON	Connection details for RFC-Logon to and from remote systems	8	ROUTE	SAProuter String (for the CSMREG User)	nvarchar	255	0
20	T630L	Shipping Determination: Loading Times	3	ROUTE	Route	nvarchar	6	0
21	T630R	Delivery Scheduling: Pick/Pack Time for Materials	3	ROUTE	Route	nvarchar	6	0
22	TROLZI	Routes: Determination in Inbound Deliveries	5	ROUTE	Actual delivery route	nvarchar	6	0
23	ZEIM_VBAP	Sales Document: Item Data	72	ROUTE	Route	nvarchar	6	0
TOPAdvertising Management
24	JJTBEBVT	IS-M/AM: Booking Unit Elements (Distribution)	7	ROUTE	Truck Route - Media	nvarchar	6	0
25	JJTBEPART	IS-M/AM: Booking Unit Elements (AI)	4	ROUTE	Truck Route - Media	nvarchar	6	0
TOPAllocation
26	AUVDI	Worklist for Deliveries (Follow-on Doc. Generation)	5	ROUTE	Route	nvarchar	6	0
27	AUVT	Shipping-Specific Data of Plants for Delivery Generation	8	ROUTE	Route	nvarchar	6	0
TOPBasic Functions
28	TROAL	Routes: Allowed Actual Routes for Delivery	2	ROUTE	Proposed delivery route	nvarchar	6	0
29	TROAZ	Routes: Determination in Sales Documents	8	ROUTE	Proposed delivery route	nvarchar	6	0
30	VETVG	Delivery Due Index for Stock Transfer	5	ROUTE	Route	nvarchar	6	0
TOPConditions
31	B010	Shipping Point/Route	5	ROUTE	Route	nvarchar	6	0
TOPCross-Application Components
32	VVBAP	Sales Document: Item Data	72	ROUTE	Route	nvarchar	6	0
TOPDangerous Goods Management
33	TDGT1	DG: Alloc. route, dep. country, dest. country a. RoRo ind.	2	ROUTE	Route	nvarchar	6	0
34	TDGT2	DG: Transit countries, leg indicator, indicator sea/air	2	ROUTE	Route	nvarchar	6	0
TOPData Collection
35	S005	SIS: Shipping Point/Route/Forwarding Agent/Receiving Country	9	ROUTE	Route	nvarchar	6	0
36	S005BIW1	S005BIW1 * SIS: Ship.Pnt/Route/Forw.Agent/Recipient Country	4	ROUTE	Route	nvarchar	6	0
37	S005BIW2	S005BIW2 * SIS: Ship.Pnt/Route/Forw.Agent/Recipient Country	4	ROUTE	Route	nvarchar	6	0
38	S005E	S005 - Structural Information	4	ROUTE	Route	nvarchar	6	0
39	S051	Shipment routes	10	ROUTE	Shipment route	nvarchar	6	0
40	S051E	S051 - Structural Information	5	ROUTE	Shipment route	nvarchar	6	0
41	S052	Means of transportation	11	ROUTE	Shipment route	nvarchar	6	0
42	S052E	S052 - Structural Information	6	ROUTE	Shipment route	nvarchar	6	0
43	S159	W&S: Picking Waves	39	ROUTE	Route	nvarchar	6	0
44	S260	SD - Sales order	43	ROUTE	Route	nvarchar	6	0
45	S260BIW1	SD - Sales order	43	ROUTE	Route	nvarchar	6	0
46	S260BIW2	SD - Sales order	43	ROUTE	Route	nvarchar	6	0
47	S261	SD - Delivery note	15	ROUTE	Route	nvarchar	6	0
48	S261BIW1	SD - Delivery note	15	ROUTE	Route	nvarchar	6	0
49	S261BIW2	SD - Delivery note	15	ROUTE	Route	nvarchar	6	0
50	S263	SD - Sales order/delivery note	39	ROUTE	Route	nvarchar	6	0
51	S263BIW1	SD - Sales order/delivery note	39	ROUTE	Route	nvarchar	6	0
52	S263BIW2	SD - Sales order/delivery note	39	ROUTE	Route	nvarchar	6	0
53	S264	SD- Offer	45	ROUTE	Route	nvarchar	6	0
54	S264BIW1	S264BIW1 * SD - Quotation	45	ROUTE	Route	nvarchar	6	0
55	S264BIW2	S264BIW2 * SD - Quotation	45	ROUTE	Route	nvarchar	6	0
TOPDSD Connector
56	/DSD/ME_TOUR_HD	DSD CN: Tour Header Data	10	ROUTE	DSD Connector: Route ID	nvarchar	6	0
TOPFSCM In-House Cash
57	IHC_DB_ROUTE	IHC: Assignment of Route to a Clearing Unit	3	ROUTE	IHC: Route	nvarchar	6	0
58	IHC_DB_ROUTE_T	IHC: Text Table for Route	3	ROUTE	IHC: Route	nvarchar	6	0
59	TBCA_ROUTE	Routing Definitions	3	ROUTE	Route	nvarchar	6	0
60	TBCA_ROUTEDET	Route Determination	7	ROUTE	Route	nvarchar	6	0
TOPGoods Receipt Process
61	BORRTTS	Route schedule header (new)	4	ROUTE	Route	nvarchar	6	0
TOPInterfaces
62	VXSISR	Small Parcel Carrier: Route -> Service Code	3	ROUTE	Route	nvarchar	6	0
TOPLogistics - General
63	OIFSPBL	Physical Location - Master Data	43	ROUTE	Shipment route	nvarchar	6	0
TOPMaster Data
64	JSTROUPVA	IS-M/SD: Truck Route-Publication/Edition Assignment	3	ROUTE	Truck Route - Media	nvarchar	6	0
TOPMedia Product Sales and Distribution
65	JKSDUNSOLDITEM	IS-M: Item Data on Unsold Copies/Credit Memos	34	ROUTE	Route	nvarchar	6	0
66	JKSECONTRINDEX	Index Table for IS-M Contracts	21	ROUTE	Route	nvarchar	6	0
67	JVSDTRSPPLAN	IS-M: Transportation Plan	4	ROUTE	Route	nvarchar	6	0
68	JVSDTRSPPLANCONT	IS-M: Transportation Plan - Contracts in Truck Route	4	ROUTE	Route	nvarchar	6	0
69	JVSDTRSPPLANORD	IS-M: Transportation Plan - Order Items (Pull) in Truck Rte	4	ROUTE	Route	nvarchar	6	0
70	JVSDTRSPPLISSUES	IS-M: Transportation Plan - Assigned Media Issues	4	ROUTE	Route	nvarchar	6	0
TOPMonitoring
71	CSMNIPINGCFG	CCMS : Configuration Table for NI PING Availability	4	ROUTE	SAProuter string to domain	nvarchar	255	0
TOPPatient Management
72	NRSF	IS-H: Patient Risk Factors	16	ROUTE	IS-H: Drug Allergy - Route of Administration	nvarchar	2	0
73	TN17E	IS-H: Drug Allergies - Routes of Administration	2	ROUTE	IS-H: Drug Allergy - Route of Administration	nvarchar	2	0
74	TN17Q	IS-H: Drug allergy - texts for routes of administration	3	ROUTE	IS-H: Drug Allergy - Route of Administration	nvarchar	2	0
TOPPeriodical Sales and Distribution
75	JDTSTVOPA	IS-M: Bundling Rule	13	ROUTE	Truck Route - Media	nvarchar	6	0
76	JDTWGHVOPA	IS-M/SD: Bundling Rule - Weight Scale	13	ROUTE	Truck Route - Media	nvarchar	6	0
77	JRTABLG	IS-M: Drop-Off	14	ROUTE	Truck Route - Media	nvarchar	6	0
78	JRTABLRGL	IS-M/SD: Unloading Rule (no longer used)	3	ROUTE	Truck Route - Media	nvarchar	6	0
79	JRTROUBEA	IS-M/SD: Truck Route Unloading Point Sequence	2	ROUTE	Truck Route - Media	nvarchar	6	0
80	JRTROURUN	IS-M/SD: Truck Routes Delivery Rounds	2	ROUTE	Truck Route - Media	nvarchar	6	0
81	JRTROUTE	IS-M/SD: Truck Route Master Data	2	ROUTE	Truck Route - Media	nvarchar	6	0
82	JRTRVPOS	IS-M/SD: Item in Truck Route Contract	4	ROUTE	Truck Route - Media	nvarchar	6	0
83	JRTTROUTE	IS-M/SD: Daily Truck Routes	2	ROUTE	Truck Route - Media	nvarchar	6	0
84	JVTFAHRM	IS-M: Driver Notification (Shipping Documents)	3	ROUTE	Truck Route - Media	nvarchar	6	0
85	JVTFEHLER	IS-M: Distribution Error Message	20	ROUTE	Daily Route	nvarchar	6	0
86	JVTPRDGR01	IS-M/SD: Elements of Production Group	15	ROUTE	Truck Route - Media	nvarchar	6	0
87	JVTPRDGR02	IS-M/SD: Elements of a Production Group	5	ROUTE	Truck Route - Media	nvarchar	6	0
88	JVTVSPDIR	IS-M/SD: Shipping Document Directory	5	ROUTE	Truck Route - Media	nvarchar	6	0
89	JVTZUSTM	IS-M/SD: Carrier Notification (Shipping Documents)	7	ROUTE	Truck Route - Media	nvarchar	6	0
90	RJD01_RTE	IS-M: Structure Truck Route for Generation Rule	2	ROUTE	IS-M: Structure for truck route generation rule	nvarchar	4	0
91	TJMSD2SD	IS-M/SD: Customizing Settings for LES Interface	3	ROUTE	Truck Route - Media	nvarchar	6	0
92	TJV41	IS-M/SD: Type of Shipping Problem Message	20	ROUTE	IS-M: Relevancy of Truck Route	nvarchar	1	0
93	TJV53	IS-M/SD: Destination Determination for Shipping Documents	4	ROUTE	Truck Route - Media	nvarchar	6	0
TOPPOS Interface
94	WVFB	DRS Interface, Intermediate Buffer, Order Item FM	53	ROUTE	Route	nvarchar	6	0
TOPProcessing
95	EWA_WDOC_WA_RT	Selection Data from Work Area for Route	3	ROUTE	Planned Waste Disposal Order Route	nvarchar	10	0
TOPProfitability Analysis
96	CE1IDEA	Op. Concern BR World	95	ROUTE	Route	nvarchar	6	0
97	CE1IDES	Ergebnisbereich IDES	95	ROUTE	Route	nvarchar	6	0
98	CE2IDEA	Op. Concern BR World	79	ROUTE	Route	nvarchar	6	0
99	CE2IDES	Ergebnisbereich IDES	79	ROUTE	Route	nvarchar	6	0
100	CE4IDEA	Op. Concern BR World	64	ROUTE	Route	nvarchar	6	0
101	CE4IDEA_ACCT	Op. Concern BR World	65	ROUTE	Route	nvarchar	6	0
102	CE4IDEA_FLAG	Op. Concern BR World	61	ROUTE	Flag: Characteristic Assigned Manually or Using TKEZU	nvarchar	1	0
103	CE4IDEA_KENC	Op. Concern BR World	63	ROUTE	Route	nvarchar	6	0
104	CE4IDES	Ergebnisbereich IDES	64	ROUTE	Route	nvarchar	6	0
105	CE4IDES_ACCT	Ergebnisbereich IDES	65	ROUTE	Route	nvarchar	6	0
106	CE4IDES_FLAG	Ergebnisbereich IDES	61	ROUTE	Flag: Merkmal manuell oder über TKEZU kontiert	nvarchar	1	0
107	CE4IDES_KENC	Ergebnisbereich IDES	63	ROUTE	Route	nvarchar	6	0
TOPPurchasing
108	EKPV	Shipping Data For Stock Transfer of Purchasing Document Item	6	ROUTE	Route	nvarchar	6	0
TOPRegional structure
109	EADRCITYROUTE	Routes for City	4	ROUTE	Planned Waste Disposal Order Route	nvarchar	10	0
110	EADRSTRTROUTE	Route Number for Street Section	9	ROUTE	Planned Waste Disposal Order Route	nvarchar	10	0
TOPRemaining Beverage - Obsolete Objects
111	/BEV1/RBVBAP	Sales Document: Item Data	72	ROUTE	Route	nvarchar	6	0
112	/BEV1/RPTO	Route Master (Route Planning)	2	ROUTE	Shipment route	nvarchar	6	0
TOPSales
113	VBAP	Sales Document: Item Data	72	ROUTE	Route	nvarchar	6	0
114	VEPVG	Delivery Due Index	5	ROUTE	Route	nvarchar	6	0
TOPShipping
115	LIKP	SD Document: Delivery Header Data	21	ROUTE	Route	nvarchar	6	0
116	SHP_IDX_GDSI	Outbound Deliveries: Not Posted for Goods Issue	4	ROUTE	Route	nvarchar	6	0
117	SHP_IDX_PICK	Outbound Deliveries: Not Picked	5	ROUTE	Route	nvarchar	6	0
118	VALW	Delivery Plan: Definition of Route Schedule	3	ROUTE	Route	nvarchar	6	0
119	VBLK	SD Document: Delivery Note Header	11	ROUTE	Proposed delivery route	nvarchar	6	0
TOPSimulation
120	VSVBAP_CN	Version: Sales document: Item data	73	ROUTE	Route	nvarchar	6	0
TOPStock Visibility
121	/DSD/SV_LC_HD	DSD LC: Loading Confirmation Header	7	ROUTE	Route	nvarchar	6	0
TOPStructures Workbench
122	/ISDFPS/MATSPPLN	Materials Planned for Force Element	48	ROUTE	Route	nvarchar	6	0
123	HRT1981	Table Section Infotype 1981	10	ROUTE	Route	nvarchar	6	0
TOPTraders and Schedulers Workbench
124	OIGSV	TD Vehicles in Transport/Shipment	20	ROUTE	TD-F vehicle route	nvarchar	6	0
125	OIGV	TD Vehicle Header	18	ROUTE	TD-F vehicle route	nvarchar	6	0
126	OIJNOMH	Nomination Header	38	ROUTE	Route	nvarchar	6	0
127	OIJNOMHVERS	Nomination Header Version Table	40	ROUTE	Route	nvarchar	6	0
128	OIJNOM_FIELDST	Nomination field status locking	10	ROUTE	Boolean Variable (X=True, -=False, Space=Unknown)	nvarchar	1	0
129	OIJ_EL_CP_LAYT	Charter party and laytime and demurrage agreement	15	ROUTE	Route agreed in charter contract	nvarchar	6	0
130	OIJ_SCHED	Planned Schedule Lines	46	ROUTE	Route	nvarchar	6	0
131	OIJ_STAGES	TSW (&TD) Shipment Stages	14	ROUTE	Route for shipment stage	nvarchar	6	0
TOPTransportation
132	TROLZ	Routes: Determination in Deliveries	9	ROUTE	Actual delivery route	nvarchar	6	0
133	TVRAB	Route Stages	2	ROUTE	Route	nvarchar	6	0
134	TVRO	Routes	2	ROUTE	Route	nvarchar	6	0
135	TVROT	Routes: Texts	3	ROUTE	Route	nvarchar	6	0
136	TVRSZ	Routes: Legs for each Route	2	ROUTE	Route	nvarchar	6	0
137	VTPRG	Transport. planng system cumulation proc. for delivery item	3	ROUTE	Route	nvarchar	6	0
138	VTPRL	Transportation Planning System Route Limitations	3	ROUTE	Route	nvarchar	6	0
139	VTRDI	Shipment Planning Index	8	ROUTE	Route	nvarchar	6	0
140	VTTK	Shipment Header	21	ROUTE	Shipment route	nvarchar	6	0
141	VTTS	Stage of Shipment	13	ROUTE	Route for shipment stage	nvarchar	6	0
TOPTransportation and Distribution
142	OIGS	TD Shipment Header	59	ROUTE	Route	nvarchar	6	0
143	OIGSS	TD Shipment Stages	14	ROUTE	Route for shipment stage	nvarchar	6	0
TOPTransportation Planning
144	/DSD/RP_TOH	Tour Master, Header Data	2	ROUTE	Shipment route	nvarchar	6	0
145	/DSD/RP_TOP	Tour Master, Item Data	2	ROUTE	Shipment route	nvarchar	6	0
TOPVisit Control
146	/DSD/VC_VLH	DSD: Visit List - Header Data	15	ROUTE	Route	nvarchar	6	0
147	/DSD/VC_VPH	DSD: Visit Schedule - Header Data	21	ROUTE	Route	nvarchar	6	0
TOPWaste Management
148	EEWA_CAPAB_ROUTE	IS-U Waste: Capacity Planning - Routes	3	ROUTE	Planned Waste Disposal Order Route	nvarchar	10	0
149	EWADEVSERV	Service Order for Container Delivery	10	ROUTE	Planned Waste Disposal Order Route	nvarchar	10	0
150	EWAOBJH	Service Frequency -> Services (History for EWAOBJ)	13	ROUTE	Planned Waste Disposal Order Route	nvarchar	10	0
151	EWAROUTE	Header table of route	2	ROUTE	Planned Waste Disposal Order Route	nvarchar	10	0
152	EWA_ORDER_HEAD	Header Table for Waste Disposal Order	7	ROUTE	Planned Waste Disposal Order Route	nvarchar	10	0
153	EWA_ROUTE_BULK	Bulk Refuse Objects for Route	2	ROUTE	Planned Waste Disposal Order Route	nvarchar	10	0
154	EWA_ROUTE_CAL	Maintenance of non-work days for route	2	ROUTE	Planned Waste Disposal Order Route	nvarchar	10	0
155	EWA_ROUTE_WDPLNT	Waste Disposal Facilities for Route	2	ROUTE	Planned Waste Disposal Order Route	nvarchar	10	0
156	TEWASERVGRPTMPL	Default Values for Service Grouping	11	ROUTE	Planned Waste Disposal Order Route	nvarchar	10	0
157	TEWASERVICETMPL	Default Values for Service Type for Service Product	11	ROUTE	Planned Waste Disposal Order Route	nvarchar	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

157 columns | ERP 6.0 | ROUTE