How to export logs from sm35 to excel ?

[Former Member]

Hope that the question is clear.

I have run an lsmw and excecuted the same in sm35.

I want the list of data which got 'processed' and which are processed 'incorrect' in an excel file so that i can compare it with the input data.

Thanks in advance,

Shankar

[andreas_mann3]

hi,

create a spool and read it with fm RSPO_RETURN_ABAP_SPOOLJOB

Andreas

[Former Member]

Hi Andreas Mann ,

Can you please exlain in detail, how to do that ?

Regards,

Shankar

[Former Member]

Hi,

Use this.

DATA : P_SPOOL1 LIKE TSP01-RQIDENT.

DATA: ABAPLIST1 LIKE SOLI OCCURS 0 WITH HEADER LINE.

CALL FUNCTION 'RSPO_RETURN_ABAP_SPOOLJOB'

EXPORTING

RQIDENT = P_SPOOL1

• FIRST_LINE = 1

• LAST_LINE =

TABLES

BUFFER = ABAPLIST1

EXCEPTIONS

NO_SUCH_JOB = 1

NOT_ABAP_LIST = 2

JOB_CONTAINS_NO_DATA = 3

SELECTION_EMPTY = 4

NO_PERMISSION = 5

CAN_NOT_ACCESS = 6

READ_ERROR = 7

OTHERS = 8.

where P_SPOOL1 will be the SPOOL no. U got from the

output.

The list is stored in ABAPLIST1 now download this to

an excel using FM GUI_DOWNLOAD

call function 'GUI_DOWNLOAD'

exporting

filename = v_file

FILETYPE = 'ASC'

tables

data_tab = ABAPLIST1

EXCEPTIONS

FILE_WRITE_ERROR = 1

NO_BATCH = 2

GUI_REFUSE_FILETRANSFER = 3

INVALID_TYPE = 4

NO_AUTHORITY = 5

UNKNOWN_ERROR = 6

HEADER_NOT_ALLOWED = 7

SEPARATOR_NOT_ALLOWED = 8

FILESIZE_NOT_ALLOWED = 9

HEADER_TOO_LONG = 10

DP_ERROR_CREATE = 11

DP_ERROR_SEND = 12

DP_ERROR_WRITE = 13

UNKNOWN_DP_ERROR = 14

ACCESS_DENIED = 15

DP_OUT_OF_MEMORY = 16

DISK_FULL = 17

DP_TIMEOUT = 18

FILE_NOT_FOUND = 19

DATAPROVIDER_EXCEPTION = 20

CONTROL_FLUSH_ERROR = 21

OTHERS = 22

.

Regards,

GSR.

[Former Member]

Dear Srinivas,

I want to export the logs from batch Input session ( SM35 ) to excel . I didn't understand what is the spool number that you are telling ? Whether sm35 logs will be available in any spool ? I am not able to see any spool related to this batch input session.

Awaiting your reply ..

Thanks & Regards,

Shankar

[Former Member]

Hi,

OK.

Goto SM35

There U have an option to download the file to

presentation server(say .XLS file)

Select Your Session name and press the Export Session

button or press Shift+F12.

In the screen which follows select the

'File from presentation server' radio button and give

the file name (with .xls extension) and data format as

ASC

U'll get the required session in excel format.

Regards,

GSR.

[Former Member]

Dear Srinivas,

What you told will give the BDC/ lsmw program screen, fields , okay code etc.. But my requiremn\ent is to get this list. ( Here LSMW is used to run the transaction CA02 )

1 CA02 Incorrect

2 CA02 Incorrect

3 CA02 Incorrect

4 CA02 Processed

5 CA02 Incorrect

6 CA02 Processed

7 CA02 Incorrect

.......................

.......................

.......................

Is my requirement clear ?

Regards,

Shankar

[Former Member]

you can export the sm35 logs to an excel file using the

program RSBDCLOG. But this program no longer exists in

My SAP ERP 2004 versions instead of that you can use the

function modules that they are using it in the report.

regards,

Krishnakumar

[Former Member]

Hi All,

I got the solution . We have to go to the logs and click the print button . It will give the logs in ALV format and with that you can filter and get the required result.

Thank you everybody for giving suggestions.

Regards,

Shankar

[linuspts06]

Hello,

Really appreciate that you have posted after you found the solution.

It helped me today.

Thanks a lot