topic Re: LSMW Batch processing issue in Application Development and Automation Discussions

LSMW Batch processing issue

Former Member — Tue, 10 Feb 2015 11:45:58 GMT

While fetching report from S_BCE_68001425 transaction using LSMW batch process i got an error.

It wasn't able to fetch report.

What I am trying to do is to automate the process of fetching role report from SUIM. S_BCE_68001425 transaction is executed when you execute SUIM and select complex selection criteria under roles option.

When I tried to run it in foreground it worked. Then I run it in foreground but with background simulation and it showed error. Unable to find VAL111 like that something.

When you go in transaction S_BCE_68001425, there is an option 'selection according to authorization values'.

In authorization object 1 I put the value S_TCODE. After that we have to press enter for displaying the text boxes where we put values for S_TCODE like SUIM and ST01.

When I run it in foreground the boxes showed but in background it showed error as mentioned above.

i.e. in ackground process batch program is not able to find the hidden boxes and tried to input the required field values and hence the error.

Could anyone please help me with this.

Re: LSMW Batch processing issue

former_member74904 — Tue, 10 Feb 2015 15:18:40 GMT

Hi Hari Om Kashyap,

Another idea might be to schedule a job (using RSUSR070) with the values required instead of using LSMW.

I don't think you will encounter the same issue when doing it this way.

If for some reason this doesn't help, can you show can you show us a screenshot of the recording you use with the LSMW?

Good luck!

Dimitri.

Re: LSMW Batch processing issue

Former Member — Wed, 11 Feb 2015 10:24:32 GMT

Hello Dimtri,

Thanks for your reply.

I know about report RSUSR070, but due to some constraint i need to do this activity with LSMW. I am fetching the report using tcode S_BCE_68001425 and the exporting it to an excel file.

I am attaching the recording screenshot

Thanks,

Hari

Re: LSMW Batch processing issue

former_member74904 — Wed, 11 Feb 2015 12:51:51 GMT

Can you try repeating the recording and using the "entry values" button before entering the actual T-code values for S_TCODE:

That seems to have worked for me.

In the recording this should result in an additional entry with BDC_OKCODE =SHO

Mind you, I have different issues with my quick attempt of recreating your LSMW with the saving to a local file of the results. But we'll leave that for later...

Good luck!

Re: LSMW Batch processing issue

Former Member — Thu, 12 Feb 2015 12:12:48 GMT

I think it's a correct answer but when I tried it runing in foreground with Backgroung simulation Worked fine. which was not in the earlier case. Didn't throw any error. Hence I marked your answer as correct.

But still when executed in background it gives error but file. Am I doing something wrong.

Have you run it in background only and got the file as output without eror?

I have attached the error log

Please help me with this. Thanks....

Re: LSMW Batch processing issue

Former Member — Thu, 12 Feb 2015 14:30:01 GMT

I debugged in deep a little and found out the problem is with OK codes.

%PC is not working for downloading file. in front end it's supported but not in background.

Could you please have an alternate method for this. this will solve my issue..

Thanks

Re: LSMW Batch processing issue

former_member74904 — Thu, 12 Feb 2015 15:02:30 GMT

Hi again Hari Om Kashyap,

I figured as much that it had to do with downloading the Results.xls.

If you still want to use LSMW as your preferred method, I think that you may be able to use custom coding in the __END_OF_TRANSACTION__ or __END_OFPROCESSING__ area and call a function to download. I suggest to start looking at WS_EXCEL. Not sure if that will do what you require but it'll be a good starting point.

Good luck!