Skip to Content
0

Excel as Email attachment ,Amount not summing up

Apr 01, 2017 at 02:19 PM

36

avatar image
Former Member

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

cl_bcs_convert=>string_to_solix

( EXPORTING iv_string = g_strmsg iv_codepage = '4103'

iv_add_bom = 'X'

doc types

IMPORTING

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers