Material Masters not linked to contracts

[former_member1359228]

Hi - I need a simple way of generating a report of all material masters not linked to a contract. are there any step by step guides available?

[former_member763929]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with Community Q&A , as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line.

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial Q&A tutorial

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your Profile you encourage readers to respond.

[BijayKumarBarik]

No such direct report but you can try following

1. Get list for materials for contracts with table EKPO with document category K

2. Get list of all materials with MM60 or table MARA

3. Now compare these two list and you can get materials without contract - can use excel!

[Oscar_DC]

It depends on how your data is structured . If you're maintaining your source lists or info records. If I were you, I'd just download the contracts .

Assuming you're in ECC 6.0 - I'd go to ME3M look for all documents without a blank material master record and validity key date of today.

After you get that list, just compare it to your list of material records. You can get this from different transactions, like MM60.

If you're going to be doing this repeatedly, you could create a query for it.