Extrach BDoc messages from SMW01

[Former Member]

Hi All,

I have built a small SAP GUI script in Microsoft Excel which extracts all the BDoc message from SMW01. I have a lof of BDoc failures and it was painful to see the errors one-by-one. There could be a more elegant way to extract this information, but I built this script anyway.

If you are not familiar with SAP GUI Scripting, this is a scripting tool which runs on the SAP GUI and simulates the button clicks, selections, etc. that happens in the GUI which can be recorded and played back. My script is running from MS Excel, and it dumps the information into the same Excel file which can be filtered and manipulated later on.

This is how to use it:

1. Download the Excel file: https://docs.google.com/leaf?id=0Bw1XOPtMPlsNNTc3YzA0ZTAtZjEyYi00ODZiLWE4YmMtMmZmMmNhNWU5N2Qz&hl=en_...

2. If you have a security warning, enable the marcos in the Excel document

3. Log into your target system, start SMW01 and execute a query so the screen shows the Bdocs for which you want to extract the messages.

4. Put the System name and client number - no spaces - into the A8 field.

5. Click Start Dump.

Depending on the number of Bdocs or the number of messages this can take some time. You will see in the GUI screen what the script is actually doing. It loops through the Bdocs in the SMW01 view and simulate the pressing of "Show Bdoc Msg Error/Receviers" button and dumps everything on pop-up screen.

SAP GUI scripting should be enabled in your SAP system indicated by a small ikon on your GUI toolbar on the lower right corner. If it is not turned on, change the "sapgui/user_scripting" parameter in RZ11. Also you need a SAP GUI with scripting support installed. If you see "Script Recording and Playback" under "Customize Local Layout" button than you have it.

Enjoy.

[former_member684008]

Hi Csongor,

Thanks for posting this blog this is really useful. But when I am trying to run the quarry it is reading only first BDOC and then an error msg poped up.

Please find the attached error details.

Kindly helps me to get the SMW01 dump downloaded.

Appreciate your help!

Thanks & Regards

Kavita Arya

[matt]

This should really be posted in the Wiki or as a blog.

matt

[Former Member]

Hi Matt,

I don't have an SAP related blog and I don't want to open a separate blog just for this article. To be honest I only know SDN and how to post messages here. If you show me how to use Wiki or other Blogs, I am happy to repost this article with some additional details.

Regards,

Csongor

[matt]

To have your own SAP Blog, check [here|http://wiki.sdn.sap.com/wiki/display/SCNGUIDE/Blogs] For the wiki try [here|https://wiki.sdn.sap.com/wiki/display/HOME/Wiki+FAQ].

The problem with posting in the forums is that your useful information can rapidly disappear off the front page, and then be not so easy to find..

[former_member189549]

Hello Varga,

Please provide the error message that you have from trx SMW01

thanks

Willie

[Former Member]

Hi Willie,

I don't understand you. This thread is not about a specific issue, in fact I have no issues at all. I just wanted to share a way of extracting error messages from SW01 and analyse them outside SAP.

Regards,

Csongor

[former_member189549]

Hello Csongor

I tried to follow the link, but got an empty screen. Sorry for the confusion

thanks

Willie

[Former Member]

Hi Willie,

It is loading OK for me. Anyway, my emails is removed by moderator Drop me a mail and I will send you the file.

Regards,

Csongor

Edited by: Matt on Sep 24, 2011 12:49 PM