Oct 07

Changing SAP IDOCs Status In Mass / Mass Deletion Of IDOCs

Mass Change of SAP IDOC Status

From time to time it becomes necessary to change the status of SAP IDOCs in SAP. The most common scenario is the requirement to mark SAP IDOCs for deletion. There is no good way to mass mark IDOCs for deletion via the standard IDOC processing transaction BD87. However there is a program that will let you change status.

RC1_IDOC_SET_STATUS

CAUTION: This program should be used with great care and consideration. Improper use of this program can result in data consistency issues. Make sure you know what you are deleting, why you are deleting it, and what is required to correctly update you system after deleting.

Example: Marking IDOCs for Deletion In Mass

It is pretty typical for support users to set the deletion flag on IDOCs that have been incorrectly created and have errored. When there are a small number of IDOCs this is possible via transaction BD87.

An inbound IDOC in error will have the status 51, when it is marked for deletion it has a status of 68.

A view of the IDOCs to be deleted in WE05.

200910051528.jpg

To mass delete IDOCs run the following program via SE38: RC1_IDOC_SET_STATUS via the SAP Transaction: SE38

200910051501.jpg

There are only a few parameters on the selection screen for this program. It is most important that you correctly restrict the IDOCs you select with this program. The program automatically defaults to marking inbound IDOCs in error for deletion.

To mass select IDOCs to be marked for deletion select: 200910051504.jpg

200910051522.jpg

There are many options for selecting and restricting the IDOCs to Mass process. Select by single value or range. Restrict by single value or range.

The 200910051506.jpg allows you to upload a list of IDOCs from a text file.

The 200910051514.jpg allows you to apply a list from your clipboard.

200910051531.jpg

Execute the program 200910051529.jpg

200910051529.jpg

Check the status of the 3 IDOCs in WE05

200910051534.jpg

Example: Changing IDOCs Status To Repost

It is also possible to use this program to reset an IDOC so that it can be reprocessed.

200910051549.jpg

With the following selection we are going to reset the IDOCs with status 68 marked for deletion back to status 64 to try and reprocess them.

Execute the program 200910051529.jpg

200910051529.jpg

200910051548.jpg

As you can see, program RC1_IDOC_SET_STATUS is very helpful, but please be careful when you use it!

About The Author

Tim has over 25 years of business experience with the last 20 focused on SAP systems architecture and program delivery. He has a broad range of experience with a pragmatic, get the job done approach to engagements. Tim specializes in development of SAP technical strategies and services for clients having successfully lead multiple programs and projects. His extensive SAP technical and functional background has enabled him to thrive in environments of all sizes and complexities.

8 Comments

  1. Avatar
    Jose Carlos
    February 1, 2012 at 12:33 pm · Reply

    Hi,
    Your reading provide me the solution. Thanks!
    However, I did not have SE38 or SA38 authorization in production system.
    I indeed look for transaction assigned to program( se16 and look in table TSTC) and I had authorization to it.
    Just might help other people (my transacction assigned was Z…)
    Cheers

  2. Avatar
    Anjeel Babbar
    February 23, 2012 at 2:25 am · Reply

    Thanks found it useful. While WE11 leans out EDIDC table but a large portion of data also lies in EDIDS, both of these tables related to IDOCs. Is there a way to lean out EDIDS ? Any suggestion welcome. Thanks in advance.

  3. Avatar
    Benjamin Bloch
    May 11, 2012 at 10:34 am · Reply

    Hi Tim Yates,

    thank you very much!!!!

    BB

  4. […] http://www.dataxstream.com/2009/10/mass-status-change-sap-idoc/ Share this:TwitterFacebookLike this:LikeBe the first to like this. This entry was posted in About idocs. Bookmark the permalink. […]

  5. Avatar
    PascalB.
    January 29, 2013 at 9:12 am · Reply

    Thanks very much for this article! I found it pretty usefull for our ECC systems.

    I am trying to do the same in a BW 7.3.1 system, but I couldn’t find the report RC1_IDOC_SET_STATUS. Any ideas if this report could be copied to BW systems or is there another way of managing mass iDocs in thsi product?

  6. Avatar
    Prashant jhanwar
    February 17, 2014 at 2:34 am · Reply

    I agree that the RC1_IDOC_SET_STATUS could be used to change the status but as Tim mentioned that this program must be used with very cautions. Reason being that SAP does not provide any checks and balances in this program and hence any status can be changed to any status using this program. You can even change status 51 to status 03 I.e. An inbound status to an outbound status.

    To mitigate this issue as well as to take care of number of other critical issues in IDOc management, we have developed a SAP product – Error Message Manager ( EMM ). Details can be found on web site http://www.omksolutions.com under OMKAR LAB tab. To help EDI IDOC community, we are willing to demo it’s functionalities. If any one is interested, please send an email to emm@omksolutions.com

  7. Avatar
    Prashant Jhanwar
    February 18, 2014 at 6:19 pm · Reply

    If your objective is to Mass change IDoc status then the SAP standard program RC1_IDOC_SET_STATUS could be used. Few issues with it:
    1. You need SE38 or SA38 access to execute the program
    2. Program does not have any checks and balances in it. So you can incorrectly change an Inbound IDOC status to outbound status. Program does not restrict the user for making this mistake.
    3. If you have number of IDocs for which status to be changed, you cannot use RANGE function on selection.
    4. MESSAGE TYPE and IDOC NUMBER fields on selection do not work together. It is EITHER OR condition.
    5. You cannot DELETE the IDocs.

    So the standard tool-sets provide very limited functionality.
    To mitigate this and to bring utmost innovations to IDOC MANAGEMENT are as a whole, there is a really cool product – Error Message Manager (EMM) out there. This product provides Editing, Analysis, Monitoring, Mass Editing, Mass Status change, Mass delete, and a number of other user friendly features.

    Please visit website http://www.omksolutions.com OR send an email to emm@omksolutions.com to learn more about it.

  8. Avatar
    SAIDULU A
    January 28, 2015 at 5:26 am · Reply

    Hi Tim,

    Its very helpful to us who are new for IDoc’s.

    Thank you,keep posting like above………..:)

    BR
    Sai

Leave a reply

Your email address will not be published. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

This site uses Akismet to reduce spam. Learn how your comment data is processed.