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
Showing results for 
Search instead for 
Did you mean: 

How to correlate lips table and ekpo table?

xinjiang_li
Active Participant
0 Kudos
1,856

Hi,gurus:

How to correlate lips table and ekpo table? We want to find the purchase order no. in the delivery table.

Thanks in advance.

1 ACCEPTED SOLUTION

Former Member
0 Kudos
358

you can get the PO no for the delivery by going to EKBE table.

Field XBLNR in EKBE holds the delivery no.

You cna enter the delivery no here and get the PO no from EKBE-EBELN.

This should definitely help u

7 REPLIES 7

Former Member
0 Kudos
358

you can get the so of this delivery from field lips-KDAUF

Then using this ..you can get the po no from vbak-BSTNK

please let me know if this helps

0 Kudos
358

Hi,

If our delivery is based on purchase no. directly, without SO (is it possible?).How to link between DN and PO?

0 Kudos
358

Hi xinjiang

You can try using VBFA table. give input as VBELN = deliver no.,POSNN = item no.and VBTYP_N = 'J' and VBTYP_V = 'V'. Then VBELV,POSNV will give you the purchase order no. or else you can get all the preceding documents of delivery like sales order and then input sales order and get purchase order from VBFA

0 Kudos
358

EKPO-EBELN = EKES-EBELN after EKES-VBELN = LIPS-VBELN

Former Member
0 Kudos
358

try this ..

EKPO-EBELN = LIPS-VGBEL

EKPO-EBELP = LIPS-VGPOS

-roger

Former Member
0 Kudos
359

you can get the PO no for the delivery by going to EKBE table.

Field XBLNR in EKBE holds the delivery no.

You cna enter the delivery no here and get the PO no from EKBE-EBELN.

This should definitely help u

Former Member
0 Kudos
358

EKPO-EBELN = EKES-EBELN

EKES-VBELN = LIPS-VBELN

Regards,

Joan