Skip to Content
avatar image
Former Member

Excel as Email attachment ,Amount not summing up

Hi Experts,

One of our customer requirement was to send the Spool create from Program SAPF100 as an Excel attachment.

In SCOT we have Spool email attachment configuration as PDF hence I have created a program in which I submit the program and use "LIST_FROM_MEMORY" and "LIST_TO_ASCI" to get the data and process.

To make it excel compatible , I have looped on data use cl_bcs_convert=>gc_tab as Horizonal deliimter and cl_bcs_convert=>gc_crlf as vertical delimiter.

Then I have used the Method cl_bcs_convert=>string_to_solix with below parameter


( EXPORTING iv_string = g_strmsg iv_codepage = '4103'

iv_add_bom = 'X'

doc types


et_solix = l_binary_content

ev_size = l_size ).

Then I call CL_BCS to send email with excel as attachement.

Everything works great only issue is the amount field does not sum up.

Our customer uses "," as decimal notation and "." as thousand separator.

If in user profile I make Decimal notation as "." and thousand separator as "," then it work fine however when I make it vice versa amount field in excel does not sum up.

P.S: I have tried to change column into number format but that does not help.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers