Link from VBAK to EKKO?

[Former Member]

I do not believe that there is any way to link VBAK to EKKO but I thought I would ask. Basically what I need is to display the PO/Sales Order number if a delivery was created off a STO verses a Sales Order. The only place that I can think to get the PO number is EKKO. However how would I grab EBELN (PO number) for a certain delivery number?

Regards,

Davis

[RichHeilman]

How about going to EKKN, this gives you EBELN and VBELN.

Regards,

Rich Heilman

[Former Member]

Sorry, did not work, I thought it did.

Message was edited by:

Davis

[ferry_lianto]

Hi Davis,

Please try table EKBE with field VGABE = '8'.

From here you can link PO (EBELN) and Delivery (BELNR).

Regards,

Ferry Lianto

Message was edited by:

Ferry Lianto

[Former Member]

Ferry,

Thank you so much! I wish I had noticed your reply earlier; it worked like a charm!

Davis

[Former Member]

Field VBAK-BSTNK gives you Customer purchase order number..

But its not necessary that u find this PO number in ur system bacause this will exist at ur customer's end..

This is simply a reference number & stored in VBAK.

For the concerned delivery, get the sales order & get BSTNK value for customer po number

[Former Member]

Rich, I tried to do what you suggested and I do not get any values returned for the Delivery number. I am not sure how to link it up without using the delivery number.

Regards,

Davis

[Former Member]

Hi Davis,

Check with VBFA table... give the Follow on Document as the deviver number and Prec.doc.categ. as 'V' this is for purchase order..

Thanks,

Mahesh

[Former Member]

Mahesh, thanks for the reply. It looks like that is going to work but I can't tell for sure because the example test case that I have was not created correctly. It only has a Q instead of a V.

Regards,

Davis

[ferry_lianto]

Hi Davis,

Did you try my previous reply?

Regards,

Ferry Lianto

[Former Member]

Ferry, I just saw it and I am trying that now.

Davis