email with excel attachment

[Former Member]

Hello friends,

I'm having an issue with excel attachmnet which is being genetaed through email using function module 'SO_NEW_DOCUMENT_ATT_SEND_API1'...issue is getting more space on first column of the data...not header column, only space on data column. Do you have any idea what might be the reason? Thanks in advance.

Regards,

Satya

[Former Member]

Check your final internal table field attributes and content.

[Former Member]

This message was moderated.

[former_member254311]

HI

Implemented this idea . Problem is while generated the excel file That is

Suppose 5 field in ur internal table then but dont want display all 5 fields

just all add ' ' if you dont want column then alignment will ready

for example

CONCATENATE CON_NEW ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' ' INTO IT_ATTACH SEPARATED BY CON_TAB. "***

APPEND IT_ATTACH.

with regards

anand kumar

[Former Member]

Hi Anand, I could able to get rid of space on first column..but now my problem is decimals won't show up on output in excel..Any idea?Thanks in advance.

[former_member254311]

HI

Simple Mate

just make variable as Type p DECIMALS 0

Just try this option

With regards

anand kumar

[Former Member]

Hello Satya,

I was doing similar kind of example; SAP data has decimals but output in an Excel sheet will not have that; it doesn't mean that it has skipped decimals; again when you migrate data from Excel sheet to packed data type input structure; it will surely add decimals.