Skip to Content
avatar image
Former Member

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

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?



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    Add comment
    10|10000 characters needed characters exceeded