Material Master Plant view

[Former Member]

Hello Gurus,

I have created a Material master and by mistake extended to 3 plants.

I want to extend it to only one plant.

My goal is to remove the 2 plant view for which i have by mistake extended the material.

Regards

Prashant

[Former Member · Accepted solution]

Hi Prashant,

You may no be able to delete the views but if you intention is to restrict the material from being used in any documents for the plants other than the one you should have maintained it can be done.

In material master Basic View there is a field- ' X-plant matl status ' i.e. cross-plant matl status and in MRP 1 view there is a field ' Plant-sp.matl status '. By selecting the appropriate status in these fields the material can be blocked for any processing.

The customisation for the status is done in the following IMG path -Logistics - General---> Material Master ->Settings for Key Fields->Define Material Statuses

Regards,

Karthik.

[Former Member · Accepted solution]

No, My intension is not restricting the material.

for some of the technical reason i want to remove the plant views for which i have extended the material.

is there any standard program through which i can do?

is it possible to delete these views at table level?

regards

Prashant

[Former Member · Accepted solution]

Hi,

The below link will definitely give you an idea:

[FORUM - HELP|;

Regards

[Former Member · Accepted solution]

Hi Prashant,

Mark the relevant material data segment for deletion and run the data archiving program.

If the master data is not used anywhere, then the archiving program will delete the MARC entries at the database level.

This is the standard way that guarantees database coherence.

Best Regards,

Franck Lumpe

Freelance SAP Logistics Consultant

[Former Member · Accepted solution]

Hello Franck,

Thank you for your response.

Can you please let me know which is the data archiving program i have to run.

Regards

Prashant

[Former Member · Accepted solution]

Hello Prashant,

Transaction code is SARA.

Check http://www.sap-basis-abap.com/sapta009.htm for more information.

Best Regards,

Franck