Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Link between shipment number(tknum) and (ebeln) PO..URGENTLY REQ

Go to solution
Former Member

‎10-07-2007 1:29 PM

0 Kudos

Hi,

I had create a shipment number using VT02N, now i have shipment number(tknum) and i need to fetch the our reference field (UNSEZ) from EKKO table. so can i anyone help to fetch this particlar data.

Thanx in advance

Message was edited by:

vamshi krishna

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎10-07-2007 2:00 PM

0 Kudos

Hi

Take the VBELN (delivery No) from VTTP table

And goto LIPS table with that VBELN and search in the VGBEL field

whether it has got the PO number.

If the delivery is created against the PO it will be there.

Take that EBELN from LIPS-VGBEL and fetch the field from EKKO

Regards

Anji

1 REPLY 1

Go to solution
Former Member

‎10-07-2007 2:00 PM

0 Kudos

Hi

Take the VBELN (delivery No) from VTTP table

And goto LIPS table with that VBELN and search in the VGBEL field

whether it has got the PO number.

If the delivery is created against the PO it will be there.

Take that EBELN from LIPS-VGBEL and fetch the field from EKKO

Regards

Anji