Join LIPS and EKES tables

[Former Member]

Hi,

I hope somebody could help me to complete quickviews, by telling me how to insert the inbound delivery (EKES_VBELN) in a quickview I am creating to list all the deliveries made by a factory to a distribution center:

My goal is to have a report with:

- actual goods issue date (LIKP_WADAST_IST)

- delivery (LIKP_VBELN)

- delivery item (LIPS_POSNR)

- material number (LIPS_MATNR)

- R/3 + S reserve field 1 (VBAP_YYMMRS1)

- actual quantity delivered (LIPS_LFIMG)

Thank you,

Romain

[JL23 · Accepted solution]

if you want to link a delivery (tables LIKP and LIPS) with a purchase order (starting from EKES), then you have to go via the PO history table EKBE.

Means you have to join EKES-EBELN and EKES-EBELP with EKBE-EBELN and EKBE-EBELP. But you must restict the search only on EKBE-VGABE = 8. then the record found will have the delivery number in field EKBE-BELNR.

finally you join EKBE-BELNR with LIKP-VBELN.

the way via document flow table VBFA is more complex.

[JL23]

you probably have to add either the EKBE table (purchase order history) to have a link between your PO and the delivery, or table VBFS (SD document flow) as this document flow links as well PO with delivery.

[Former Member]

Jürgen, could you please be more specific about the elements which can be linked ?

Thank you,

Romain