MATERIAL DOES NOT EXISTS OR NOT ACTIVATED

[Former Member]

Dear Experts,

I want to change Material Master data. I have downloaded the material list from data base table MARC plant data for materials.

i want to extend the material master view. but system is issuing the error message - Material dose not exists or not activated. Also it is not showing the material in MM03 & MM60.

But in data base table MARC it is showing the material code with details.

[Former Member · Accepted solution]

hi

MARA is the main table for material master.

[Former Member · Accepted solution]

Thats correct AP,

But material master code exits in MARC and it does not exist in the data base table MARA.

thats what my querry is, at which level material master data maintenance is remaining.

thanks

[Former Member · Accepted solution]

Hi Kiran,

All materials will have an entry in MARA as Basic Data -1 view will be created, so please check if there is any table inconsistency and also let us know which material type is it that your not able to see?

Regards,

Vivek

[Former Member · Accepted solution]

Hi Vivek,

Its trading material type

[mauro_bianchi · Accepted solution]

Hi Kiran,

If there are entries in MARC, but NOT in table MARA this is an inconsistency. I dont know any way how this situation could be created in Standard. How you created this material ? with MM01 or with your own program ?

Anyway, the way to remove the inconsistency would be to reconstruct a new MARA-entry, then archive and delete the materials on hand by standard archiving object MM_MATNR.

Regards,

Mauro

[Former Member · Accepted solution]

Hi Kiran,

The material type must be HAWA, well you would be able to get this info, if an entry in MARA exists. So from where are you getting the material type?

Anyways just check this, enter the material nos. in MM01 & select Basic Data 1 & click create, check what message you get, should provide you the clues. Also check how this material was created. It could be possible that it was created via some custom program.

Creat the view & then you will be able to resolve the issue. Check the above & revert if you face any issues.

Regards,

Vivek

[Former Member]

Hi Kiran

i want to add simple input..

however i m happy wid other reply..

use Tcodse OMS9 and MMAM

thanks

Mahesh