topic Doubt in using the function module SO_DOCUMENT_SEND_API1 in Application Development and Automation Discussions

Doubt in using the function module SO_DOCUMENT_SEND_API1

Former Member — Thu, 12 Jun 2008 12:29:02 GMT

Hi ,

My requirement is sending an excel sheet to the mail id's given in excel sheet.I am using the FM:SO_DOCUMENT_SEND_API1.I complete the program. It is working good.My problem here is once I received the excel sheet , if the amount value is 123.00. i can see only 123. As if the amount value is 123.78, i can see the value 123.78.I can see the value perfectly in debug mode , but the valus has been truncated in excel sheet .

Can anyone give me the idea how to correct this ?

Thanks,

Suresh.

Re: Doubt in using the function module SO_DOCUMENT_SEND_API1

Former Member — Thu, 12 Jun 2008 12:43:29 GMT

Most likely reason seems to be that Excel is being overly friendly and fixing formats for you - e.g. if you have a column containing a PO reference such as 4500001234 then it will assume this is a number that can be included in calculations for format it as general, and not a text string that just happens to contain only numbers. You can fix this once the data is in Excel by formatting the cells the way you want.

Jonathan