LSMW Batch processing issue

[Former Member]

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.

[former_member74904]

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.

[Former Member]

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

[former_member74904]

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!

[Former Member]

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

[Former Member]

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

[former_member74904]

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!