Trying to link EIPO foreign trade data to VBAK,LIPS,LIKP,KNA1,TVROT

[Former Member]

Hi

I am trying to link table EIKO - Foreign Trade data on delivery item data to my existing Quickview which has the following tables,

VBAK - Sales Doc header

LIPS - Delivery item

LIKP - Delivery header

TVROT - Route

KNA1 - general data in customer master

But when added SAP says 'no relationship Found'

Do i need to add another table as a common link ?- if so which one?

Many thanks for your help and advise

Tony

[Shiva_Ram]

You can find route details from LIKP table itself, then why you need TVROT table? You can remove it and check. Also foreign trade data is available in table EIKP. Add this in the query and test.

Regards,

[Former Member]

Hi

the field i am after from EIPO is EXPRF - Export procedure for Foreign trade

This does not seem to be on EIKP

please advise

thanks

Tony

[eduardo_hinojosa]

Hi

I'm not sure what you want to do. But the link is in EIKP-REFNR. With this field you can link to PO, deliv, invoice and so on.

I hope this helps you

Regards

Eduardo