cancel
Showing results for 
Search instead for 
Did you mean: 

Extract of Country of Origin

Former Member
0 Kudos

Hi Gurus,

How can I extract the list of country of origin for all the materials from MIGO documents posted for the month?

User want the list of materials received for the month with Country of Origin. We have Material no (different line item) and plant at MSEG table but the Country of Origin in EIPO table and posting date taken from MKPF

If in case we create a query what would be the compatible fields to join?

Please suggest possible solutions

Regards

Shashi

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello,

You may join MSEG table with EINA for fields MATNR, LIFNR and WERKS (if required). Country of origin is at EINA-URZLA.

Thanks,

Venu

Former Member
0 Kudos

Hi,

The problem is we do not use Info records in most of the cases. So the option of linking EINA and MSEG is ruled out.

Shashi

Former Member
0 Kudos

Try Making a Query using SQVI trxn..

take Material,Posting date & Plant as input fileds

and in the out put choose Material Number,Material document,Country of Origin,Posting Date & Plant