Tuesday, 30 March 2010

Changing SAP IDOCs Status In Mass / Mass Deletion Of IDOCs

Posted by Tim Yates on Wednesday, October 7, 2009 · Leave a Comment

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 Tim:

Tim has over 20 years industry experience, with 15 years concentrated on SAP and related technologies. He has broad industry exposure working with companies such as Siemens Automotive, Mercury Marine, SAP America, Eli Lilly & Company, and Verizon. Tim’s deep understanding of SAP and the industry comes from a very hands on approach. His concentration in SAP has been in systems architecture and integration, helping companies develop their infrastructure and controls to successfully integrate SAP into their existing IT landscape.

5 comments:

  1. 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 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

    ReplyDelete
  2. More companies are taking a closer look at implementing SAP Supply Chain Execution (SCE) Extended Warehouse Management (EWM) or SAP Enterprise Resource Planning (ERP) Warehouse Management (WM) in their automated and/or conventional warehouses.
    http://eonlinetraining.co/course/sap-ewm-online-training/

    ReplyDelete
  3. very good theory.Lots of good information.Thank you.
    SAP automotive

    ReplyDelete
  4. Thanks for sharing such an information on SAP .Keep sharing on.

    ReplyDelete
  5. Nice information thank you,if you want more information please visit our link
    ewm training
    sap ewm training in hyderabad

    ReplyDelete