All data not present in Excel sheet when a report output is send via e-mail

[Former Member]

Hi Friends,

I am just into a small confusion.

While sending the report output via mail (Excel attachment), all the data in report output is not displayed in the Excel sheet.

While the internal table which is building the data and passed to the FM 'SO_DOCUMENT_SEND_API1' is being populated properly with the whole data as in Report output.

Waiting for your inputs.

Thanks

Ashiq

[Former Member]

Hello Ashiq,

Did you check the body of the mail which you are passing into the table

CONTENTS_TXT in the tables parameter in the function module.

check it in debugging.

if all the fields are not passed then pass the fields into a variable of character type with length how much you required them and concatenate all the fields with required spacing and append the in to the internal table CONTENTS_TXT.

try it.

Regards,

Phani.

[Former Member]

Hi Phani,

The table (contents) passed to CONTENTS_TXT is being filled properly with all the records.

[Former Member]

There is a 255 character limitation, but you can convert the record string to a binary internal table.

• convert record string to binary internal table

REFRESH xxl_tab.

CLEAR xxl_tab.

CALL FUNCTION 'SCMS_STRING_TO_FTEXT'

EXPORTING

text = rec_str

• IMPORTING

• LENGTH =

TABLES

ftext_tab = xxl_tab.

[Former Member]

u can create a unix script which sends email using sendmail command with attachment.

Create a external command and use "SXPG_CALL_SYSTEM" to call the external command