on 07-08-2011 7:54 AM
Hi Experts,
I need a extract out of the data base for all materials send to the critical countries (Sudan, Iran, Syria, Cuba)in the last 12 month for some customers.
For the following i need to extract to excel sheet.
material
material description
plant
division
country of origin
For creating new query what are all the tables i should to take to match this requirement.
Help me regarding this.
Raghu
Hi,
Consider the following tables:
MARA (for material number and division)
MAKT (description)
MARC (plant data and country)
Regards,
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try to update the forum properly when you got the solution. You were habitually closing the threads without properly updating which is not fair on your part.
thanks
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can get all this Data from Table VBRP & Table VBRK ( If I am correct , you are looking for the Materials which are sold).
Best Regards,
Ankur
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Raghu,
Hi Raghu,
You will need to following tables:
LIKP & LIPS for date range in the last 12 years
KNA1 & ADRC tables for Ship to Party (destination country)
MARA for material number
MAKT for description
MARC plant data and country of Origin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Raghu,
You will require the following tables
MARA MATNR Material Number
MAKT MAKTX Material description
MARC WERKS plant
MARA SPART division
MARC HERKL country of origin
Join the tables using the query and get your required output.
The same can be downloaded into Excel.
Please find my reply in the following thread for creating such a query.
Please check and revert back whether your issue is solved.
Thanks & Regards,
Hegal K Charles
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
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.