Skip to Content
author's profile photo Former Member
Former Member

Deletion of master data

Hi guys,

I have come to crucial point.

I need to delete all those materials from the master tables

which no PO ,Material Document and no STOCK is there and some

other criteria.

Kindly somebody give me some light for this query.

If its not advisable how to approch for it and what

will be strategy?

Thanks a million.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 04:35 AM

    Hi,

    For deleting the material use the BAPI BAPI_MATERIAL_SAVEDATA...

    In the parameter HEADDATA-MATERIAL pass the material number.

    In the parameter CLIENTDATA-DEL_FLAG = 'X'

    In the parameter CLIENTDATAX-DEL_FLAG = 'X'.

    Then give COMMIT WORK..

    Thanks,

    Naren

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      HI NAREN,

      Thanks !!

      But this bapi is used for creating and changing the materials.

      Not for DELETION.

      If you are having any solution to delete the materials kindly suggest me.

      Create and Change Material Master Data

      BAPI_MATERIAL_SAVEDATA

      I ll be really thankful to your solution.

      Jyoti

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 05:08 AM

    Hi,

    The BAPI will work for deletion also..

    Deleting means not physically deleting from the database tables..

    The field MARA-LVORM will be set to 'X'.

    Please check my previous for details..

    Thanks,

    Naren

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 05:14 AM

    Jyothi,

    we should not delete any data once its created in SAP, we should set the deletion flag on, so that, it will be considered as deleted entry. the other way is archiving.

    Sujatha.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 05:37 AM

    Hi ,

    My objective not to display those material in MM03 (Transaction )

    whose material deletion flag is checked thru the transacion MM06.

    Any solution please suggest me.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.