Skip to Content
0
Former Member
Jan 07, 2011 at 10:35 AM

Junk values in Excel attachment when sending external mail from SAP

106 Views

Hi Everyone,

Requirement is to send error records for interfaces to user via email's from SAP.

I am able to populate all the error recors using classes CL_BCS program that i obtained from a sdn WIKI and send mails to the recipients as a XLS attachment.

Now the mail is sent with XLS attachment with all the error records. But when I open the attachment, i see that the error records are populated but along with junk values ... as shown below

First is the header line.

From 2nd row are the actual records.

Column MSG2 is the last column in the file.

Sometimes MSG1 and MSG2 may not be populated fully also. In that case it is filling with junk values.

INT_ID DATE TIME SYSTEM DIRECTION MSG1 MSG2

FI-SD-015 20100924 122913 CTBS INBOUND 150 Sales order created succesfully ഀ  ऀ䘀䤀ⴀ匀䐀

FI-SD-017 20100924 115613 CTBS INBOUND 1000000070 Sales Order successfully Created 䤀一䈀伀唀一䐀FF-SD 20100923 92724 CTBS INB TEST ⴀ䴀䴀ⴀ  ㄀ऀ㈀ ㄀ ㄀ ㌀ ऀ㄀㘀㌀㐀㌀㔀ऀ

If someone faced this issue before and solved this, can you pls share the resolution.

Regards,

Vinay