Return only null values in MM17

[pdyke]

I need to populate fields that are currently null for product hierarchy and the only mass change tool I have right now is MM17. Until I get SE16N, is there a way to only show null values in MARA table? The hierarchies are all different so I can't just update with the same one across all plants. Thanks for the help!

[former_member27]

Hi pdyke,

Thank you for visiting SAP Community to get answers to your questions.

As you're looking to get the most out of your community membership, please consider including a profile picture to increase user engagement & additional resources to your reference that can really benefit you:

Profile https://developers.sap.com/tutorials/community-profile.html

Tips for Questions: https://community.sap.com/resources/questions-and-answers

Consider taking our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html.

I hope you find this advice useful, and we're happy to have you as part of the SAP Community!

All the best,

Dedi

[former_member27]

Hello again, pdyke,

I'm glad to see you got an answer to your question! If it helps you, please make sure to accept (you'll see the "accept" option beneath the question) -- so members with similar issues will be able to find a solution to their problems too.

If it doesn't help, you can always leave a comment providing more details that can guide members who wish to assist you.

I hope that this guidance is useful -- and we look forward to your next question for the community!

All the best,

Dedi

[DominikTylczyn]

Hello pdyke

Assuming you are asking about product hierarchy in the MARA table, i.e. the MARA-PRDHA field, you can select in MM17 all materials without a product hierarchy assigned in the following way:

Execute and you will get a list of materials with product hierarchy in the MARA table.

Best regards

Dominik Tylczynski

[pdyke]

So it's as easy as changing Product Hierarchy to "Not equal to" and leaving it blank, and that will show me everything that does not have a product hierarchy loaded?

[DominikTylczyn]

pdyke yes, it's that easy indeed :))

[sanan123]

Please accept the answer and close the question if u got the solution.

Thanks,