	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

76 columns | ERP 6.0 | TOUR_ID

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
TOPDirect Store Delivery
1	/DSD/DX_HD	DEX Stream Header (backend)	4	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
2	/DSD/DX_IT	DEX Stream Segments (backend)	4	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
TOPDownloadUpload
3	/DSD/HH_RACAD	DSD Route Settlement: Customer Address Data (One-Time Only)	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
4	/DSD/HH_RACL	DSD Route Settlement: Clearing	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
5	/DSD/HH_RACOCICI	DSD Route Settlement: Check-Out/Check-In - Money Item	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
6	/DSD/HH_RACOCIES	DSD RA: Check-In/Out Signatures	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
7	/DSD/HH_RACOCIHD	DSD Route Settlement: Check-Out / Check-In - Header data	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
8	/DSD/HH_RACOCIMI	DSD Route Settlement: Check-Out Check-In - Items	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
9	/DSD/HH_RACTR	DSD Route Settlement: Transmission Control	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
10	/DSD/HH_RACVHD	DSD Route Settlement: Customer Visit - Header	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
11	/DSD/HH_RADELCD	DSD Route Settlement: Delivery Execution Conditions	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
12	/DSD/HH_RADELCND	DSD Route Settlement: Delivery Execution Conditions	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
13	/DSD/HH_RADELES	DSD RA: Delivery/Order Signatures	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
14	/DSD/HH_RADELHD	DSD Route Settlement: Delivery Execution - Header	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
15	/DSD/HH_RADELIT	DSD Route Settlement: Delivery Execution Items	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
16	/DSD/HH_RADS	DSD Route Settlement: Tour Distance Sheet	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
17	/DSD/HH_RADXHD	DSD Route Accounting: DEX Header Data	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
18	/DSD/HH_RADXIT	DSD Route Accounting: DEX Item Data	4	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
19	/DSD/HH_RAEC	DSD Route Settlement: Receipts/Expenditures	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
20	/DSD/HH_RAECA	DS Route Settlement: Collection Settlement	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
21	/DSD/HH_RAERRIDX	DSD - RA: Error Index Table	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
22	/DSD/HH_RAHD	DSD Route Settlement: Tour Header Data	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
23	/DSD/HH_RAIVCD	DSD Route Settlement: HH Invoice Header Conditions	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
24	/DSD/HH_RAIVCND	DSD Route Settlement: HH Invoice Header Conditions	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
25	/DSD/HH_RAIVES	DSD RA: Invoice Signatures	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
26	/DSD/HH_RAIVHD	DSD Route Settlement: HH Billing Document Header	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
27	/DSD/HH_RAIVIT	DSD Route Settlement: HH Billing Document Items	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
28	/DSD/HH_RAIVPRT	DSD Route Settlement: HH Billing Document Print	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
29	/DSD/HH_RALOCKHD	DSD - RA: Change Management Tour	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
30	/DSD/HH_RATS	DSD Route Settlement: Tour Time Sheet	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
TOPDSD Connector
31	/DSD/ME_CLR_HD	DSD CN: Clearing header data	2	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
32	/DSD/ME_CNDLE	DSD Connector: Table Listing/Exclusion Conditions	2	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
33	/DSD/ME_COCI_HD	DSD CN: Check-out Check-in Header Data	2	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
34	/DSD/ME_COCI_ITM	DSD CN: Check-Out Check-In Items	2	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
35	/DSD/ME_COCI_PAY	DSD CN: Check-Out Check-In Payments	2	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
36	/DSD/ME_CUST_CPD	DSD CN: One-time Customer	2	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
37	/DSD/ME_DEL_CND	Pricing: Manual discount condition for deliveries	2	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
38	/DSD/ME_DEL_HD	DSD CN: Delivery Header Data	3	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
39	/DSD/ME_DEL_ITM	DSD CN: Delivery Items	4	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
40	/DSD/ME_DX_HD	DSD CN: DEX Header Interface structure	2	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
41	/DSD/ME_DX_ITM	DSD CN: DEX Item Interface structure	4	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
42	/DSD/ME_ES_HD	DSD CN: Signatures Header Data	2	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
43	/DSD/ME_ES_ITM	DSD CN: Signatures Item Data	2	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
44	/DSD/ME_EXPS_HD	DSD CN: Driver Expenditure	2	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
45	/DSD/ME_INVT_HD	DSD CN: Stock header data	2	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
46	/DSD/ME_INV_HD	DSD CN: Billing Doc. Header Data	2	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
47	/DSD/ME_INV_ITM	DSD CN: Billing Doc. Items	2	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
48	/DSD/ME_MSG_HD	DSD CN: Message header data	9	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
49	/DSD/ME_ORD_CND	Pricing: Manual discount condition for orders	2	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
50	/DSD/ME_ORD_HD	DSD CN: Order Header Data	3	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
51	/DSD/ME_ORD_ITM	DSD Connector: Order Items	4	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
52	/DSD/ME_PAYM_HD	DSD CN: Payments or Cash Collection received from Customer	2	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
53	/DSD/ME_PRO_FBAM	MDSD Promotions - Feedback Amounts in Connector	2	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
54	/DSD/ME_PRO_FBFG	MDSD Promotions - Feedback Free Goods in Connector	2	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
55	/DSD/ME_REVN_HD	DSD CN: Payments or Cash Collection received from Customer	2	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
56	/DSD/ME_TOUR_HD	DSD CN: Tour Header Data	2	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
57	/DSD/ME_VIST_ACT	DSD CN: Activities during the Customer Visit	2	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
58	/DSD/ME_VIST_HD	DSD CN: Customer Visit Header	2	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
TOPGeneric Statistical Data
59	/DSD/GS_ADM_H	DSD: Generic Statistical Data Header	2	TOUR_ID	Tour ID	nvarchar	12	0
60	/DSD/GS_GENDAT_I	DSD: Generic Data Container	2	TOUR_ID	Tour ID	nvarchar	12	0
61	/DSD/GS_LAYOUT_I	DSD: Layout of Generic Data Container	2	TOUR_ID	Tour ID	nvarchar	12	0
TOPHandheld Connectivity
62	/DSD/PR_FBAM	MDSD Promotions - Feedback Amounts	7	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
63	/DSD/PR_FBFG	MDSD Promotions - Feedback Free Goods	7	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
TOPRemaining Beverage - Obsolete Objects
64	/DSD/ME_CHANNELS	DSD Connector: Channel Tour Assignment	3	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
65	/DSD/ME_TOUR_STI	DSD Connector: Tour Status - Detail Administration	2	TOUR_ID	DSD Connecter: Tour ID	nvarchar	11	0
TOPRoute Settlement
66	/DSD/SL_SLD_DOCS	Settlement: Merging of Back-End Documents	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
67	/DSD/SL_SLD_FLOW	Settlement: Document Flow	8	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
68	/DSD/SL_SLD_ITEM	Settlement Document Item	3	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
TOPStock Visibility
69	/DSD/SV_ERROR_HD	DSD SV Error Table Movement Header	5	TOUR_ID	Tour ID	nvarchar	12	0
70	/DSD/SV_MM_DOC	DSD SV Stock Transfer Documents per Tour	2	TOUR_ID	Tour ID	nvarchar	12	0
71	/DSD/SV_MM_HD	DSD SV Material Movement Header	5	TOUR_ID	Tour ID	nvarchar	12	0
72	/DSD/SV_QUANT	DSD SV Truck Stock	9	TOUR_ID	Tour ID	nvarchar	12	0
73	/DSD/SV_RACOCICI	DSD SV: Check-Out / Check-In - Money Item	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
74	/DSD/SV_RACOCIHD	DSD SV: Check-Out/Check-In - Header Data	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
75	/DSD/SV_RACOCIMI	DSD SV: Check-Out / Check-In - Items	2	TOUR_ID	DSD Route Settlement: Tour ID	nvarchar	32	0
76	/DSD/SV_RL	DSD SV Final Unloading Documents	3	TOUR_ID	Tour ID	nvarchar	12	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

76 columns | ERP 6.0 | TOUR_ID