SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

76 columns | Print definition?ERP 6.0  | TOUR_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPDirect Store Delivery
1/DSD/DX_HDDEX Stream Header (backend)4TOUR_IDDSD Route Settlement: Tour IDnvarchar320
2/DSD/DX_ITDEX Stream Segments (backend)4TOUR_IDDSD Route Settlement: Tour IDnvarchar320
TOPDownloadUpload
3/DSD/HH_RACADDSD Route Settlement: Customer Address Data (One-Time Only)2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
4/DSD/HH_RACLDSD Route Settlement: Clearing2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
5/DSD/HH_RACOCICIDSD Route Settlement: Check-Out/Check-In - Money Item2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
6/DSD/HH_RACOCIESDSD RA: Check-In/Out Signatures2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
7/DSD/HH_RACOCIHDDSD Route Settlement: Check-Out / Check-In - Header data2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
8/DSD/HH_RACOCIMIDSD Route Settlement: Check-Out Check-In - Items2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
9/DSD/HH_RACTRDSD Route Settlement: Transmission Control2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
10/DSD/HH_RACVHDDSD Route Settlement: Customer Visit - Header2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
11/DSD/HH_RADELCDDSD Route Settlement: Delivery Execution Conditions2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
12/DSD/HH_RADELCNDDSD Route Settlement: Delivery Execution Conditions2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
13/DSD/HH_RADELESDSD RA: Delivery/Order Signatures2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
14/DSD/HH_RADELHDDSD Route Settlement: Delivery Execution - Header2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
15/DSD/HH_RADELITDSD Route Settlement: Delivery Execution Items2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
16/DSD/HH_RADSDSD Route Settlement: Tour Distance Sheet2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
17/DSD/HH_RADXHDDSD Route Accounting: DEX Header Data2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
18/DSD/HH_RADXITDSD Route Accounting: DEX Item Data4TOUR_IDDSD Route Settlement: Tour IDnvarchar320
19/DSD/HH_RAECDSD Route Settlement: Receipts/Expenditures2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
20/DSD/HH_RAECADS Route Settlement: Collection Settlement2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
21/DSD/HH_RAERRIDXDSD - RA: Error Index Table2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
22/DSD/HH_RAHDDSD Route Settlement: Tour Header Data2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
23/DSD/HH_RAIVCDDSD Route Settlement: HH Invoice Header Conditions2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
24/DSD/HH_RAIVCNDDSD Route Settlement: HH Invoice Header Conditions2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
25/DSD/HH_RAIVESDSD RA: Invoice Signatures2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
26/DSD/HH_RAIVHDDSD Route Settlement: HH Billing Document Header2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
27/DSD/HH_RAIVITDSD Route Settlement: HH Billing Document Items2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
28/DSD/HH_RAIVPRTDSD Route Settlement: HH Billing Document Print2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
29/DSD/HH_RALOCKHDDSD - RA: Change Management Tour2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
30/DSD/HH_RATSDSD Route Settlement: Tour Time Sheet2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
TOPDSD Connector
31/DSD/ME_CLR_HDDSD CN: Clearing header data2TOUR_IDDSD Connecter: Tour IDnvarchar110
32/DSD/ME_CNDLEDSD Connector: Table Listing/Exclusion Conditions2TOUR_IDDSD Connecter: Tour IDnvarchar110
33/DSD/ME_COCI_HDDSD CN: Check-out Check-in Header Data2TOUR_IDDSD Connecter: Tour IDnvarchar110
34/DSD/ME_COCI_ITMDSD CN: Check-Out Check-In Items2TOUR_IDDSD Connecter: Tour IDnvarchar110
35/DSD/ME_COCI_PAYDSD CN: Check-Out Check-In Payments2TOUR_IDDSD Connecter: Tour IDnvarchar110
36/DSD/ME_CUST_CPDDSD CN: One-time Customer2TOUR_IDDSD Connecter: Tour IDnvarchar110
37/DSD/ME_DEL_CNDPricing: Manual discount condition for deliveries2TOUR_IDDSD Connecter: Tour IDnvarchar110
38/DSD/ME_DEL_HDDSD CN: Delivery Header Data3TOUR_IDDSD Connecter: Tour IDnvarchar110
39/DSD/ME_DEL_ITMDSD CN: Delivery Items4TOUR_IDDSD Connecter: Tour IDnvarchar110
40/DSD/ME_DX_HDDSD CN: DEX Header Interface structure2TOUR_IDDSD Connecter: Tour IDnvarchar110
41/DSD/ME_DX_ITMDSD CN: DEX Item Interface structure4TOUR_IDDSD Connecter: Tour IDnvarchar110
42/DSD/ME_ES_HDDSD CN: Signatures Header Data2TOUR_IDDSD Connecter: Tour IDnvarchar110
43/DSD/ME_ES_ITMDSD CN: Signatures Item Data2TOUR_IDDSD Connecter: Tour IDnvarchar110
44/DSD/ME_EXPS_HDDSD CN: Driver Expenditure2TOUR_IDDSD Connecter: Tour IDnvarchar110
45/DSD/ME_INVT_HDDSD CN: Stock header data2TOUR_IDDSD Connecter: Tour IDnvarchar110
46/DSD/ME_INV_HDDSD CN: Billing Doc. Header Data2TOUR_IDDSD Connecter: Tour IDnvarchar110
47/DSD/ME_INV_ITMDSD CN: Billing Doc. Items2TOUR_IDDSD Connecter: Tour IDnvarchar110
48/DSD/ME_MSG_HDDSD CN: Message header data9TOUR_IDDSD Connecter: Tour IDnvarchar110
49/DSD/ME_ORD_CNDPricing: Manual discount condition for orders2TOUR_IDDSD Connecter: Tour IDnvarchar110
50/DSD/ME_ORD_HDDSD CN: Order Header Data3TOUR_IDDSD Connecter: Tour IDnvarchar110
51/DSD/ME_ORD_ITMDSD Connector: Order Items4TOUR_IDDSD Connecter: Tour IDnvarchar110
52/DSD/ME_PAYM_HDDSD CN: Payments or Cash Collection received from Customer2TOUR_IDDSD Connecter: Tour IDnvarchar110
53/DSD/ME_PRO_FBAMMDSD Promotions - Feedback Amounts in Connector2TOUR_IDDSD Connecter: Tour IDnvarchar110
54/DSD/ME_PRO_FBFGMDSD Promotions - Feedback Free Goods in Connector2TOUR_IDDSD Connecter: Tour IDnvarchar110
55/DSD/ME_REVN_HDDSD CN: Payments or Cash Collection received from Customer2TOUR_IDDSD Connecter: Tour IDnvarchar110
56/DSD/ME_TOUR_HDDSD CN: Tour Header Data2TOUR_IDDSD Connecter: Tour IDnvarchar110
57/DSD/ME_VIST_ACTDSD CN: Activities during the Customer Visit2TOUR_IDDSD Connecter: Tour IDnvarchar110
58/DSD/ME_VIST_HDDSD CN: Customer Visit Header2TOUR_IDDSD Connecter: Tour IDnvarchar110
TOPGeneric Statistical Data
59/DSD/GS_ADM_HDSD: Generic Statistical Data Header2TOUR_IDTour IDnvarchar120
60/DSD/GS_GENDAT_IDSD: Generic Data Container2TOUR_IDTour IDnvarchar120
61/DSD/GS_LAYOUT_IDSD: Layout of Generic Data Container2TOUR_IDTour IDnvarchar120
TOPHandheld Connectivity
62/DSD/PR_FBAMMDSD Promotions - Feedback Amounts7TOUR_IDDSD Route Settlement: Tour IDnvarchar320
63/DSD/PR_FBFGMDSD Promotions - Feedback Free Goods7TOUR_IDDSD Route Settlement: Tour IDnvarchar320
TOPRemaining Beverage - Obsolete Objects
64/DSD/ME_CHANNELSDSD Connector: Channel Tour Assignment3TOUR_IDDSD Connecter: Tour IDnvarchar110
65/DSD/ME_TOUR_STIDSD Connector: Tour Status - Detail Administration2TOUR_IDDSD Connecter: Tour IDnvarchar110
TOPRoute Settlement
66/DSD/SL_SLD_DOCSSettlement: Merging of Back-End Documents2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
67/DSD/SL_SLD_FLOWSettlement: Document Flow8TOUR_IDDSD Route Settlement: Tour IDnvarchar320
68/DSD/SL_SLD_ITEMSettlement Document Item3TOUR_IDDSD Route Settlement: Tour IDnvarchar320
TOPStock Visibility
69/DSD/SV_ERROR_HDDSD SV Error Table Movement Header5TOUR_IDTour IDnvarchar120
70/DSD/SV_MM_DOCDSD SV Stock Transfer Documents per Tour2TOUR_IDTour IDnvarchar120
71/DSD/SV_MM_HDDSD SV Material Movement Header5TOUR_IDTour IDnvarchar120
72/DSD/SV_QUANTDSD SV Truck Stock9TOUR_IDTour IDnvarchar120
73/DSD/SV_RACOCICIDSD SV: Check-Out / Check-In - Money Item2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
74/DSD/SV_RACOCIHDDSD SV: Check-Out/Check-In - Header Data2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
75/DSD/SV_RACOCIMIDSD SV: Check-Out / Check-In - Items2TOUR_IDDSD Route Settlement: Tour IDnvarchar320
76/DSD/SV_RLDSD SV Final Unloading Documents3TOUR_IDTour IDnvarchar120