04-12-2010 5:57 AM
Hi all ,
Have requerment to send excel options in mail but data in row having more than 225 characater ,have using the method name
CL_DOCUMENT_BCS=>CREATE_DOCUMENT please guide me send more number character in a rows .
Regards,
santosh.
04-12-2010 6:00 AM
hi santosh
greetings for the day
FYI link
http://forums.sdn.sap.com/search.jspa?q=CL_DOCUMENT_BCS
cheers
S.Janagar
04-12-2010 6:00 AM
hi santosh
greetings for the day
FYI link
http://forums.sdn.sap.com/search.jspa?q=CL_DOCUMENT_BCS
cheers
S.Janagar
04-12-2010 6:21 AM
My dear S.Janagar,
Know to send using this method ,My question My data in row having more than 225 characater using this method or any other method is there to send mail which can fit more than 225 character in excel and send mail .
Please Guide me
Regards,
Santosh
04-12-2010 6:25 AM
hi santhosh
there are lot of questions that has been previously posted by previous users
see the below
http://www.sdn.sap.com/irj/scn/advancedsearch?query=emailwithmorethan255+char
in this one such thread is
read the answer given by thomas jung
answer given by dileep kumar
and try to search for that
please posting
cheers
S.Janagar
Edited by: Janagar Sundaramoorthy Nadar on Apr 12, 2010 7:28 AM
04-12-2010 1:32 PM
Dear S.Janagar,
i check all the blogs but am not able understand ,Can please send sample code it will helpfull for me.....
Regards,
santosh
Edited by: santosh jajur on Apr 12, 2010 2:34 PM
Edited by: santosh jajur on Apr 12, 2010 2:52 PM
04-12-2010 1:56 PM
Santhosh,
Change the data type of that field to some 400.
Thats the simple solution.
Thanks.
04-12-2010 2:09 PM
Dear Viji,
Send attachment through standard function module or methods ,how it possable to change the data length fields,
regards,
santosh
04-12-2010 2:27 PM
Hi Santosh,
You can send data with length greater than 255 character to the excel sheet as an attachment but the data will be displayed in the next line in the excel sheet.I think, Its not possible to display data greater than 255 characters in single line in the excel sheet via mail. For this you can use the following logic:
CLEAR lv_success_attach.
*adding line feed for every row in success table for sending attachment through mail.
CONCATENATE lc_con_cret " lc_con_cret TYPE c VALUE cl_abap_char_utilities=>cr_lf.
lv_success "single row
INTO lv_success_attach.
lv_length = c_length. "255
lv_offset = c_offset. "0
lv_strlen = STRLEN( lv_success_attach ).
* dividing every row into 255 characters
"This loop will run more than once if the data in a single row is greater than 255 characters
DO.
IF lv_strlen LT c_length.
lv_length = lv_strlen.
ENDIF.
wa_success_attach1 = lv_success_attach+lv_offset(lv_length).
APPEND wa_success_attach1 TO it_success_attach1.
CLEAR wa_success_attach1.
lv_offset = lv_offset + lv_length.
lv_strlen = lv_strlen - lv_length.
IF lv_strlen = 0.
EXIT.
ENDIF.
ENDDO.
Hope it will help you. If it is not clear, please feel free to post queries. I will try to explain it to you.
Thanks & Regards
Rocky
04-13-2010 8:44 AM
Dear Rocky,
Thanks for the Suggestion ,Have different question need to send excel file attachment in color format in mail ,please can guide me how to due it and if its possable please send the code..
Regards,
santhu
Edited by: santosh jajur on Apr 13, 2010 9:45 AM