SAP export LSMW batch input session results

Sometimes, when running an LSMW batch input session (Fig 1), we want to get the results in a useful format - like a spreadsheet, or a raw text file. This to handle, use and compare results.

SAP export LSMW batch input session results : Fig 1 : LSMW menu
Fig 1 : LSMW menu

Once we ran our session, in transaction SM35 (Batch Input : Session Overview), we can select it, for example one in error. We choose it, and then select Log display (Fig 2). In the log display, we select the line, and click on "Display" (Fig 3).

SAP export LSMW batch input session results : Fig 2 : LSMW batch input session
Fig 2 : LSMW batch input session
SAP export LSMW batch input session results : Fig 3 : LSMW batch overview
Fig 3 : LSMW batch overview

We now have the whole log - but displayed in SAP. We may want to export it. To do so, we first have to select the printing option, by clicking on the print icon in the upper part (Fig 4).

SAP export LSMW batch input session results : Fig 4 : LSMW log display
Fig 4 : LSMW log display

The log is now ready (Fig 5) for handling it as we want : print it, or export it. To export it in spreadsheet, we just have to click on the common export icon, or to use default shortcut Ctrl-Shift-F7.

SAP export LSMW batch input session results : Fig 5 : LSMW log print
Fig 5 : LSMW log print

We are then asked for the spreadsheet type (Fig 6), and we can choose our spreadsheet software (Fig 7).

SAP export LSMW batch input session results : Fig 6 : LSMW spreadsheet export menu
Fig 6 : LSMW spreadsheet export menu
SAP export LSMW batch input session results : Fig 7 : LSMW spreadsheet export software
Fig 7 : LSMW spreadsheet export software

The result then display by itself (Fig 8) in the choosen spreadsheet software, from which we can handle the data as we want, but some cleansing may be necessary first to remove some useless data.

SAP export LSMW batch input session results : Fig 8 : Excel export LSMW log
Fig 8 : Excel export LSMW log

Of course, some other export options are offered to us (Fig 9) - for example, we could choose to save the log as unconverted (raw text file), in HTML to display it in a web browser, ...

SAP export LSMW batch input session results : Fig 9 : LSMW export formats
Fig 9 : LSMW export formats

Similar articles

Comments (8)

Carlton Parks, 2018-08-19
Non sapevo di questi dettagli, per favore fai di più
Alfonso Ramos, 2018-08-19
ฉันไม่รู้เกี่ยวกับรายละเอียดเหล่านี้โปรดให้ข้อมูลเพิ่มเติม
Stephanie Clark, 2018-08-19
สิ่งที่ฉันกำลังมองหาที่สมบูรณ์แบบ
Jose Walker, 2018-08-19
No sé cómo agradecerte, pero eso es puro genio, gracias
Cottonerac, 2018-08-19
Non so come ringraziarti, ma questo è puro genio, grazie
WsGoodMusic, 2018-08-19
Je ne sais pas comment vous remercier, mais c'est du pur génie, merci
Brilliant, 2018-08-19
伟大的信息,谢谢分享
Upforushi, 2018-08-19
Hello, láttam a cikkedet, és segített nekem megoldani a problémámat, sokat köszönöm

Leave a comment