Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Special character is appended in Email excel attachment

0 Kudos

Hi Experts,

We are facing issue while sending excel file attachment through EMAIL here we are getting special character multiple '#' at the last column even my last column is not coming fully.Total columns character count is 180. For sending Email we are using FM SO_DOCUMENT_SEND_API1.

Thanks in advance

Regards,

Ravi K

5 REPLIES 5

raymond_giuseppi
Active Contributor

You could try to use class CL_BCS and not old fashioned FMs. You didn't explain which tool you used to create the Excel attachment?

oliver_wurm
Active Participant
0 Kudos

Hi Ravi,

extra characters at the end of the file could mean the file length is nor properly passed. Please check if FM SO_DOCUMENT_SEND_API1 is called with the column DOC_SIZE populated with the right value for each Attachment Line in tables parameter PACKING_LIST.Regards,Oliver

matt
Active Contributor
0 Kudos

Don't use the FMs. Use the classes. The FMs have always been problematic. The classes work much better.

former_member182550
Active Contributor
0 Kudos

Also, # when shown in a variable display denotes a non-displayable character.

0 Kudos

Hi Experts,

Thanks for your inputs problem of '#' is resolved but still one more problem we are facing there are gaps between the Sentences For example if i want message as "SO blocked due to change in PO pricing" it will be coming as " Sale Order 0000001532 block ed due to change in PO pricing" or material number as " 26529131000RXBB1" then it will be coming like "2652913100 0RXBB1" or Quantity as " 50.000" then it will be coming like " 5 0.000" in mail excel attachment means gaps are coming also some of the quantity are left aligned in column and some of the quantity are right aligned in same column.

please help.

Thanks in advance

Regards

Ravi k