Spreadsheet output not reflecting proper output via T.Code MM60

[Former Member]

Hi Guys,

Please find the scrnsht for your reference.

When via T.Code MM60, we are trying to take the material list dump via spreadsheet, the display of few material are not coming in proper sequence.

This is only happening in Production server. Whereas no such error coming in DEV or QA server.

Please suggest.

[Prasoon · Accepted solution]

Hi,

   Please remove the special character double quotation ( " ) in the material description or end the special character in the material description (like "description") and try again. Alternatively, you may open the excel with delimitters. Refer the KBA: 2329249 - Incorrect data when report output is exported to Spreadsheet and the note: 569537 - Incorrect data during import into Excel (last line in the note clearly explains the reason)

Regards,

AKPT

[Former Member · Accepted solution]

Other materials having the description with commas....but for few materials only such distortion in output is taking place that too only in this PRD server. I am confused where it is going wrong.

[Former Member · Accepted solution]

Thanks Prasoon for the references but unable to open them @sap market place.

[Prasoon · Accepted solution]

Hi,

   Comma is not the issue in your case. the issue is the double quotes ("). Remove the same from the material description and try again. Or you may download as .txt and open with excel and use the delimitters to differentiate the columns.

   You can contact your support team to get the access to marketplace.

Regards,

AKPT

[Former Member · Accepted solution]

Thanks Prasoon. I will try it as u suggested.

[Former Member · Accepted solution]

I have chkd there are few matl whose description having this  "" but one matl is not having any such description but still it is in distorted way.

Please suggest.

[Former Member · Accepted solution]

Sorry Prasoon...its my mistake....it is the continuation of the list only so kindly ignore the earlier post. But otherwise ur suggestion worked well. Thnks a lot.

[Former Member]

Hi,

     You can try the above solution if you still face same problem check whether any filter is set on any of the column in T code MM60

[Former Member]

No filter has been set as checked.