Find Sales Order Number for teh combination of material and serial number

[Former Member]

HI Friends,

Can you please tell me how do i find out the sammes order number for a combination of material number and serial number. I need to make technical specs for this. Can you guys help me give soem idea !

Thanks in advance for your help !

[vishwajit_wattamwar]

I believe once the actual delivery is done lot of data is updated to the sales order .Can you please navigate the table VBAP and find if sr .no is updated there?Fields are

SERAIL

ANZSN

[former_member330517]

Hello Mike

If i'm not wrong , as per my understanding you can't find the combination at sales order level , as serial no will come into picture in delivery level only .

so plz find some other way ,

hope this will give you some input

Regards

Venkat

[cong_yu2]

Hi,

in serial number history (can see in IQ03), you can find the latest SO number. this link should work.

Thanks!

[Former Member]

you can try joining tables VBFA and LIPS.

from VBFA you will get the Sales Document and delivery Domuent of the Material

In LIPS table you will get Delivery Document and the Serial number of the Material.

Hope this helps

Sai

Edited by: Sai on Feb 25, 2010 3:03 PM