on 01-29-2009 2:50 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.