SQVI Query Creating

[Former Member]

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

[Former Member · Accepted solution]

Hi,

Consider the following tables:

MARA (for material number and division)

MAKT (description)

MARC (plant data and country)

Regards,

Amit

[Lakshmipathi]

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

[Former Member]

Hi Experts.

I have successfully created the query by using the tables MARA, MARC and MAKT.

Thanks a lot for your support.

Raghu

[Former Member]

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

[Former Member]

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

[former_member209761]

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