I have a program that runs nightly that created orders based off files from another program. I use the order numbers from the other program as the Customer PO Number in the SAP order. This works fine. Now I'm trying to write a report where the user can put in that PO Number (the order number from the other program) and get the order details. Currently I'm doing a select on VBAK, but it goes really slow. It takes about 3-5mins a search. Are there any other tables or ways you all can think of to speed this up?
Moderator message - Moved to the correct forum
Edited by: Rob Burbank on Oct 21, 2009 3:41 PM