Skip to Content

How to obtain Clean or Cleaner Excel file report using IW39 Report

Dec 28, 2016 at 01:22 PM


avatar image
Former Member

Hello Experts

I have received a file from a client for a report using Using IW39 Report (Preventive Maintenance Work Order data) indicating WO Num, WO Date, Func Locn, Work Center, Task List Name, Duration, Manpower Nos, Total Work.

The file is in excel format and is in haphazard format and there are various blank spaces in between the data for various dates.

Can someone show or describe a workaround for obtaining a clearer file from SAP?



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Veselina Peykova
Dec 28, 2016 at 03:57 PM

Would something like this be good enough?

Probably they are sending you some output with sorting and subtotals and the are using the wrong option to extract the data (I think, they use LIst->Save->File->Spreadsheet instead of right-click on the ALV, select Spreadsheet. What is more, they could have sent you the data as Pivot (you get the option to choose whether to save as table or as pivot).

I guess, you simply need to explain to the client in what form you need to get the data, so that you can perform your job. Either the PM user lacks some understanding of basic SAP navigation skills or he/she was in a hurry.

iw39.jpg (55.7 kB)
10 |10000 characters needed characters left characters exceeded