Tables related query

[KarthikeyanN]

Hi All,  I am new to SAP ABAP.my question is " I have production order Number with me and i need to find sales order Number (vbeln) for the same. In which table we can use production order No. and get vbeln?? ". i request you to help me.

[Former Member]

Hi,

If you are talking about purchase order number as an production order,

the nyou ca nfind SO number in LIKP or LIPS table putting order no. in

VGBEL VGPOS fields...

if not, pl specify which order number you are referring to.

Thanks,

[KarthikeyanN]

Thanks for ur respone. I dont know actually the given production order no. Is for purchase or not. Evening i founded one method to get sales order no. From production Orde no.. The method is using the given PO no. I went to AFPO table ( order item table ) and by given the AUFNR ( PO no. ) got the KDAUF ( SO no. ).

The doubt is whether this ( KDAUF ) SO No. And VBELN in vbak table are same numbers? Kindly reply as soon as possible.

Once again Thanks for anish for his reply

[naresh_kabar]

This message was moderated.

[KarthikeyanN]

thanks i got it.