How to correlate lips table and ekpo table?

[xinjiang_li]

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.

[Former Member]

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

[xinjiang_li]

Hi,

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

[Former Member]

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

[Former Member]

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

[Former Member]

try this ..

EKPO-EBELN = LIPS-VGBEL

EKPO-EBELP = LIPS-VGPOS

-roger

[Former Member]

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]

EKPO-EBELN = EKES-EBELN

EKES-VBELN = LIPS-VBELN

Regards,

Joan