QUERY: tables EIPO and EKPO

[Former Member]

i would like to make a query for thew tables EIPO and EKPO, but there is no link/relationship according to SAP, how can I make this happen?

[Former Member · Accepted solution]

HI ,

The Tables

EIPO - Foreign Trade: Export/Import: Item Data

*EKKO - Purchasing Document Header *

EKPO - Purchasing Document Item

The Link between EIPO & EKPO is in for Detailed ITEM LEVEL TAB INFORMATION

Thanks & Regards,

Senthil.

[Former Member · Accepted solution]

Make the quey with link as EIPO-EXNUM = EKKO-exnum and EKKO-EBELN = EKPO-EBELN. You have to link EIPO TO EKKO AND EKKO TO EKPO.

[Former Member · Accepted solution]

I also encountered these tables.

but, what is then the best way to link EKKO EKPO EIPO EIKP

I want to see the (for example) country of origin per purchase order oper item

?

Edited by: O. Ozpinar on Apr 20, 2009 2:17 PM

[Former Member · Accepted solution]

Do the link as EKPO-EBELN = EKKO-EBELN , EKKO-EXNUM = EIKP-EXNUM, EIKP-EXNUM = EIPO-EXNUM.

[former_member199502]

Hi,

Yes SAP will give error because there is no common field in EIPO and EKPO.there should be one common field to develop a query .

Make use of EKKO ,EKPO and EIPO,then ur query will work out