Skip to Content
0
Former Member
Oct 21, 2009 at 07:34 PM

Getting a Sales Order Number based off a Customer PO Number

373 Views

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?

Thanks,

Curtis

Moderator message - Moved to the correct forum

Edited by: Rob Burbank on Oct 21, 2009 3:41 PM