topic Re: Exception Report in Application Development and Automation Discussions

Exception Report

Former Member — Wed, 27 Sep 2006 18:07:43 GMT

Hi!

I am a developer in SAP ABAP. My recent project is on exception reporting in transports. Can anyone give me an idea on this. In my understanding its a report that marks the deviation of values in the fields of interest in traffic light colors. Can anyone pass me a sample code on exception report ASAPPPPP?

I appreciate your time & help.

Thank you

Re: Exception Report

Former Member — Wed, 27 Sep 2006 18:26:55 GMT

Hi,

Check the links,

http://help.sap.com/saphelp_47x200/helpdata/en/4c/420c5a470a11d1894a0000e8323352/frameset.htm

http://help.sap.com/saphelp_47x200/helpdata/en/5c/c1c85d445f11d189f00000e81ddfac/frameset.htm

Regards,

Azaz.

Re: Exception Report

Former Member — Wed, 27 Sep 2006 19:25:28 GMT

Thank you for the helpful response Ali.

But would someone have any sample code or how to's please.

Re: Exception Report

uwe_schieferstein — Wed, 27 Sep 2006 19:45:43 GMT

Hello Priyanka

I cannot provide you with an entire report but tell you a very useful function module which your report should contain: <b>TR_READ_GLOBAL_INFO_OF_REQUEST</b>

When you test this function module in SE37 set the following parameters:

- IV_TRKORR = <request> " Take on that is released and imported (probably into several systems) already

- IV_SETTINGS = <initial) " Then you will get the export data

Execute the function module. The transport log data are returned in ES_COFILE. Look at the itab SYSTEMS and there again at the itab STEPS. There you will find the STEPID (e.g. 'e' = export), its returncode and ACTIONS (date, time, rc).

Thus, this function module returns you the most interesting data of the transport protocols.

I cannot explain all parameters in detail because I do not know exactly their function. However, If you play around with the parameters on the same transport request (and comparing with the transport log) you soon will understand how you can extract data from the transport protocol.

I hope I could give you a kick-off for your report.

Regards

Uwe

Re: Exception Report

Former Member — Wed, 27 Sep 2006 19:51:30 GMT

Hi priyanka,

Searched for code but can't found any way go through the forums, might be helpful...

/thread/152265 [original link is broken]

Regards,

Azaz.

Re: Exception Report

ferry_lianto — Wed, 27 Sep 2006 19:59:08 GMT

Hi,

Please check this online document on how to setup exception report step by step.

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/LOLIS/LOLIS_FRÜHWARNSYSTEM.pdf

Hope this will help.

Regards,

Ferry Lianto

Re: Exception Report

Former Member — Wed, 27 Sep 2006 21:05:01 GMT

Boy Uwe, was that a kick off. I tried the FM and did see some interesting results in all systems. I will analyse these thoroughly and follow-up. Still dont know how to write exception report from this. Well, its just a start. Thankyou. I appreciate it. Any more suggestions let me know.

Re: Exception Report

uwe_schieferstein — Wed, 27 Sep 2006 21:46:29 GMT

Hello Priyanka

I am pleased that I could have helped you. A first draft for you report could look like this:

- Selection-screen with appropriate criteria (like request, systems)

- Collect the log data using the function module

To display the collected data you could choose two options (or more):

- Flatten the complex itab that you can display the data in an ALV grid (ABAP-OO based, please!!!)

- If you are eager on control programming then you could try to display your data as a tree

Regards

Uwe

Re: Exception Report

Former Member — Thu, 28 Sep 2006 00:25:26 GMT

Hi! Gurus,

Can I get some additional guidance please. I have been asked to create a custom table with some fields relevant to transport in STMS. Then upload the fields from the application handling transports in production. Compare these fields and write an exception report on the successful and mismatched transports. I have already created ztable and inserted values from e070, e07t & 70c. I can compare fields but how exception. Appreciate your time & help.

Thank you

Re: Exception Report

Former Member — Thu, 28 Sep 2006 02:15:35 GMT

Hi! Ali,

I did see all these links before but it just freaked me out. Wherever I browse about exception reporting, it says something about BeX Analyser or web templates. I am an ABAP programmer, I have no idea about BW. If u have time & patience please tell me how o do these. I have posted my proj in the prev message. Or tell me where I should physically start it, in SAP Query or where?

Thanks a lot

Re: Exception Report

Former Member — Thu, 28 Sep 2006 02:19:27 GMT

Hi,

Is your requirement is to display the transports that are released and which has a return code 4 for a given date range??

Thanks,

Naren

Re: Exception Report

Former Member — Thu, 28 Sep 2006 13:02:24 GMT

Hi!

My requirement is to compare logs from SAP side and the other application side and create an exception report. That is if any dates dont match or something like that.

Thank you