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



I flagged a particular material for deletion in MM06. Can anyone guide me the further steps in MM70,MM71,MM72.

Thank You

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 06:39 AM

    Archiving (transaction SARA)

    Data archiving removes bulk data which is no longer required in the System, but which must be retained accessibly, from the database. Data in the R/3 database can only be archived via archiving objects, which describe the data structure. Financial accounting documents, for example are archived via the archiving object FI_DOCUMNT, which comprises the document header, company-code-dependent postings, change documents, SAPscript texts and other elements. The application archiving objects are pre-defined in the system. The archiving programs are scheduled as background jobs, but can run during on-line processing. The system need not be shutdown.

    The archiving procedure comprises two main steps:

    Create archive files: the data to be archived are first written sequentially into a newly created file. The data then exist twice in the database. These archive files can, e.g. be passed to an archive system, via ArchiveLink.

    Execute delete program: the data in the archive files are removed from the database by the delete program.

    You can check how the archive filenames and archive destination are setup in transaction FILE

    Always remembers to check the setting before any archiving. The settings will determine things like whether the delete programs will start automatically. (it is not advisable to start your delete programs automatically).

    You can configure all the customizing settings with transaction AOBJ - Archive Objects.

    MM_MATBEL - Archive material document

    OMB9 - Archiving - Material document retention period.

    The default documents life is 200 days. You need to maintain the documents life for each Plant in your company before you can start archiving. If you did not maintain, you will get a list with 'Valid.period not maintained for tr./ev. type of doc.'.

    MM_ACCTIT - Archive accounting interface tables

    The documents store in the table are for applications which are to be supplied with the posting data at a later date of MM Inventory Management and MM Invoice Verification.

    If you are using 3.x, this archiving object might not be found. You need to import it from sapservX. Read note 89324, 99388, 83076.

    Take a look at OSS note 48009 for the detail explanation of which data is updated in the ACCT* tables.

    PP_ORDER - Archive production order

    OPJH - Production Order retention period. Maintain Retention 1 and 2.

    If your set your retention 1 and 2 as 10, that means that after 10 days of setting the delete flag then you can set the deletion indicator. After 10 days of setting the deletion indicator then you can start archiving. Therefore, to archive immediately, you can leave retention 1 and 2 as space. Please take note that retention 1 and 2 act as a safety net if you happened to archive the wrong record. You will have to decide whether to have the retention time gap or not.

    FI_DOCUMNT - Archive Financial Accounting Documents

    Maintain the account life - transaction OBR7

    Maintain the documents life - transaction OBR8

    SD_VBRK - Archive Billing Documents

    There are no posting date or fiscal year/period selection. You can only specify the billing documents date. In order that you do not archive the wrong record, you have to write a ABAP query or report to print out the various billing documents number ranges you want to archive. You can extract the data from table VBRK - Billing: Header Data.

    VN01 - Check all the number ranges for Billing Documents.

    Click Overview buttom or Hold the Shift key and press F7.

    RV_LIKP - Archiving Deliveries

    VORL - Maintain the retention period. Number of days which must have elapsed since the delivery was created, before the

    delivery can be archived.

    VLAL - Archive deliveries

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 06:47 AM


    Archiving the Material Master

    Transaction SARA contains all the SAP archiving objects for all the SAP R/3 applications modules. All the SAP archive functions are shown in SARA. Choose the corresponding SAP archive object, hit enter and the archive administration menu will be shown. Provided here will be an example on how to archive the SAP Material Master.

    Archive a Material Master Record

    When a material is no longer required in a company or plant, you can archive and delete the material master record.

    You have to Flag the material master record for deletion. This is known as logical deletion.

    Before a material master record can be archived and deleted, other objects (such as purchasing documents) that refer to this material must themselves be archived. You can see which objects these are and the dependencies between them in the network graphic.

    If a material master record cannot be archived and deleted at a given organizational level, the reason is given in the log (for example, a purchase order exists for the material). The log also contains technical data such as the number of material master records read and the number deleted.

    Some of the archive error log message :-

    • Costing data exists

    • Use in routing

    • Use in sales and distribution

    • Use in bill of material

    • Delivery exists

    • Costing data exists

    • Info record exists

    • Purchase order exists

    The Archiving steps :-

    Archiving object MM_MATNR for archiving material master records.

    You can display the archived data, but not reload it.

    To archive the material master, first goto transaction MM71.

    Type in a variant name and click Maintain. (Tick the Test Mode for archive simulation).

    Save the variant.

    Maintain the Start date and Spool parameters and click execute.

    Click Goto Job Overview to check the archive status.

    To do a permanent delete, goto transaction SARA and click Delete button.

    Maintain the Archive Selection, Start date and Spool parameters.

    Click Test Session for testing or click execute to start the deletion program.

    Click Goto Job Overview to check the delete status.

    Now, if you goto MM02/MM03, you will not be able to find the record in the material master.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 06:27 AM


    And do tell me how do we use tcode SARA

    Thank You

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 07:08 AM

    Hi All,

    How can we block or delete any material from material master?

    When engineering marks a finished goods material master for deletion, it does not prevent customer service from booking an order against it. However, MRP ignores it and would not suggest a planned order or a purchase requistion(for buy-outs).

    Where in configuration can I block customer service from booking an order for deleted material master? Currently, there is a pop up window to tell the order entry personnel that the material master is marked for deletion but that person can still process the order.

    We can obsolete a matl master at Sale Data 1 which will prevent order entry but very often, our document control or engineer forgets and head straight to marking an item for deletion and not archiving it after that.

    The best way is to keep the materail status with deleted or blocked for puchase / sales and need to maintain in the materail master.

    You cannot delete the material from material master until archiving but you can block that material for any procurement

    Goto Basic data 1

    X-plant matl status -

    01 Blocked for procment/whse

    02 Blocked for task list/BOM

    10 Blocked for MRP

    Select any one.

    Valid from -

    Here you enter valid date from which the material should be blocked.

    So from this your material will be blocked for any PR/PO/any transactions related to Procurement


    How can we delete materials permanently from Material master?

    A: Use transaction MM70 - Material Master->Other->Reorganization->Material->Choose.

    Build variant with selection range of material master records to be selected for deletion and maintain run parameters. Execute.

    Use transaction MM71 - Material Master-> other-> Reorganization->Material->Reorganization

    Build a second variant

    Maintain run parameters and execute.

    It is also important to remove the records manually from info record, POs, PRs, reservation etc for successful deletion of the material.


    Delete a material master - MM module

    If you created an material by error and you want to delete that material from the data base you can do it in this simple 4 steps. The only condition is that this material has to have no material movement recorded.

    These are the steps:1

    1) Flag material for deletion. transaction MM06

    2) Run report MMREO001 - Selection of materials flagged for deletion and select the material

    3) Run report MMREO050 Archive Materials to archive the material (some customisig settings might be required)

    4) Run report MMREO110 Deletion Program for Archiving Materials to delete the material from the database.

    These reports are called by the SARA transaction too.

    Reward if useful.



    Message was edited by:

    Pherasath Padmanaban

    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.