01-08-2009 4:40 AM
HI Experts,
I need to get a SO no. based to a DO no. Currently i am using the table vbfa to link the DO with SO.
But the programme performance is getting very very slow.
DO you have a better table or FM or BAPI can be used.
Please guide me and thanks in advances.
regards,
mrsara27....
<LOCKED BY MODERATOR - USE APPROPRIATE TITLES>
Edited by: Alvaro Tejada Galindo on Jan 8, 2009 4:14 PM
01-08-2009 8:00 AM
Hi,
No need to use so many tables......
get VGBEL from LIPS.. (Document number of the reference document)....
In this case refernce document is the sales order..
Now compare this to VBAP-VBELN
here you'll get all the Sales Order Numbers....
Regards.
01-08-2009 4:45 AM
01-08-2009 5:21 AM
01-08-2009 5:44 AM
Hi,
try out the combination of vbrp and vbak table instead of vbfa.
hope it will improove the performance.
Regards
Rajesh Kumar
01-08-2009 8:00 AM
Hi,
No need to use so many tables......
get VGBEL from LIPS.. (Document number of the reference document)....
In this case refernce document is the sales order..
Now compare this to VBAP-VBELN
here you'll get all the Sales Order Numbers....
Regards.
01-08-2009 8:06 AM
hi Anubhav Duttagupta ,
Your answer really helps a lot.
I am going to a think logic with your answer.
Thanks and keep the good work.
regards,
s.saravannan
01-08-2009 8:11 AM