cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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?

Regards

Vinay

Accepted Solutions (0)

Answers (1)

Answers (1)

VeselinaPeykova
Active Contributor
0 Kudos

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.