Data Extraction

[#1]

I Want to extract All the materials From the system which are not assigned to any plants. So how can we do it ? Is there any way ?

[Dominik_Tylczynski · Accepted solution]

Hello vinu3838

General material data is stored in the MARA table. Whereas plant specific data, in the MARC table. So you need to get all the materials from MARA and substract materials from MARC.

Best regards

Dominik Tylczynski

[former_member785367 · Accepted solution]

Thanks Dominik.

[former_member1355739]

There are a few ways you could go about doing this, depending on what system you're using. If you have access to the database, you could write a SQL query to retrieve all materials that don't have a plant assigned to them. If you're using a software platform, there may be built-in reporting or exporting functionality that would allow you to extract this data. Without more information about your system, it's hard to give more specific advice. But since I already started this thread, you can try doing it through a similar platform https://www.nannostomus.com/. It's a powerful resource, but exactly how you can apply it you better read on your own.