Customized report on slow moving items

[Former Member]

n MC46 we get a report on slow moving items.Suppose we have execute dthe report today(19.09.2011) and number of days we put on the selection screen say 400 days.The report will give list of materials say X1,X2 and X3 which have not moved for 400 days.

We again execute the report today say 19.10.2011.Now the report gives say list of materials X1 and X3 which have not moved for 400 days.Therefore from the period 19.09.2011 to 19.10.2010 X2 material have moved out from the list .The reason may be that it is issued to cost center or issued to production.

The user tried to use V look up to get the list of materials which have moved during period 19.09.2011 to 19.10.2010.The user informed that when he is saving the report in local file the texts are getting saved in text format in excel file and hence he is unable to apply VLOOK up.

Is there any Tcode in SAP from where i can get the list of missing material Or else can someone help me in preparing the functional specification

Regards

Manash Das

[Former Member]

Answered

[Former Member]

Hi,

You can download xls file from option system > List > save option > Spreadsheet,save the file in local directory and then use "save as" option and then save in 2007/2003 format.(Usually sheet gets downloaded in txt format)

This will allow user to use vlookup in xls format.

Thanks & Regards,

Sandesh Sawant

[Former Member]

Hi,

To get VLOOK up go for smartform. The T-code is SMARTFORM. Desighn the layout according to your requiremnt. Preparing Z report for your requirement is not that much neede in your scenario. Thanking you.

[Former Member]

Hi,

Function specification should be provided by functional consultant. In this from which table and which fields need to be considered for the Z report creation. The field inter linking also need to mention. The screen selection criteria also need to mention. Thanking you.

[Former Member]

Hi

Please check S039 info structure table fields if already info update is activated or MSEG table fields to develop the report.

regards

Narahari

-

---