Data Extraction

[Former Member]

Dear All,

I want to extract Material Master data related to plant or country specific by giving a date range. Please let me know how to do this.

Regards

Srikkanth

[former_member433442]

Hi,

Goto SE16N, ente the table name MARA, select fields material and created on. Give date on the created on field.

You wil get the list of materials created on the date rage.

Import the list into excel sheet. Again in SE16N, use table MARC, select the fields mateial ad plant.

Enter the list of materials that you extracted and give the plat. Execute it.

Now you will get the requied report.

Regards,

Prabu

[Former Member]

Hi

In MARA I can give date range, but cannot get the list of materials related to a particular plant or country.

The data volume is very high. I cannot execute MARD or MARC by giving the plant as inputs as there is no created on date range in these tables.

Hope u understand.

Regards

Srikkanth

[former_member433442]

Hi,

First extract the report by giving date range in MARA. Then give those materials in MARC and give plant.

Regards,

Prabu