BDC Errors

[Former Member]

I ran BDC session with some work orders. Many records failed. To look at which work order numbers failed I have to go thru each record, click a few buttons to get the work order number of one failed record. Is there any way to get numbers of all failed records easily - could be a report that can display all the original records that failed to load

[Former Member]

Jenny,

You can use transaction SM35 to view all your sessions. Click on the session then click on the Analysis button. Then click the incorrect radio button on the top. You can see only failed records. To view filaed transaction you can click on the Transaction Tab. If you want to check the data then click on Screens tab & then field List.

Hope this helps.

Cheers,

Bipin

• Award points if you find this useful.

[RichHeilman]

Hi Jenny, i don't know of a handy report which could give you this information, you can do as Bipin suggested, but I believe that is what you don't want to have to do. I agree, it is a little cumbersome.

Welcome to SDN!

Regards,

Rich Heilman

[Former Member]

You will have to write a custom report to do that and it is not easy.

[former_member181962]

Hi Jenny,

One of the inherent advantages of using BDC session method over Call transaction is that, you don't need to worry about report the errors in the program.

But if you really want a report sort of thing for Erroneous records, YOu can always use a Call transaction method, where in you can check for sy-subrc and prepare a log report in the program, which does the BDC.

See this.

Call transaction <TCODE> using t_BDCDATA

mode 'N'

UPdate 'S'

messages into t_Messages.

if sy-subrc <>0.

perform write_log.

endif.

form write_log.

call function 'FORMAT_MESSAGES',

*pass the message numbers IDs etc.

and get the message as the importing parameter.

Write:/ message.

endform

Regards,

Ravi

[Former Member]

Bipin, Rich, Srinivas, Ravi,

Thank you all for your help. I know how to look for the error as mentioned by Bipin. But it is not what I am looking. I think I need ot write a report on my own.

Jenny

[Former Member]

Hi Jenny,

If writing a program is what you are thinking about, then please go through the solution I gave another person on this forum. May be you can use the same logic.

Srinivas