Question:
Hello.
Is there any function Module that can attach an excel file from a local computer and send it (email it )to a user in SAP.
( I dont wanna transfer contents of the file into an internal table and then use the function module SO_NEW_DOCUMENT_ATT_SEND_API1.. becoz that disturbs the format of my excel and the client is quite strict abt it . )
Pls help me on this ASAP.
_________________
~Hozefa~
Answer:
If you have WAS , have a look at program BCS_TEST03, package SBCOMS
Answer:
If you don't have WAS, you may not have a choice but to use the FM you mentioned. I understand the problem that the Excel file gets messed up in the translation. Use the CLASS 'CL_ABAP_CHAR_UTILITIES' with attributes like 'CR_LF' to format your columns and line feed.
Ex:
concatenate 'HEADING 1' 'HEADING 2' 'HEADING 3' ' '
into t_contents_txt
separated by cl_abap_char_utilities=>horizontal_tab.
Above code will put the headings in the correct columns.
If you have this coded, double click on 'horizontal_tab' and it will take you to all available attributes that you can use.
Hope this helps.
Answer:
Thanx NestyA.
_________________
~Hozefa~
Answer:
Have a look at this program..if you are still get stuck..
http://sapfans.com/forums/viewtopic.php?t=22468&highlight=&sid=5b78ecf05c125d92276a51c93c17bc8e
_________________
Best Regards
Manohar
Answer:
Thanx Manohar.
I used the code u suggested but in this case while executing the report i get a pop-up and i have to click send mail for each XLS file . I want it to mail multiple number of files together without user intervention.
_________________
~Hozefa~
Answer:
Thanx Manohar.
I used the code u suggested but in this case while executing the report i get a pop-up and i have to click send mail for each XLS file . I want it to mail multiple number of files together without user intervention.
Yah to avoid that i have done BDC recording and executed in 'N' mode.
Also you can upload multiple files even ( should be coded in BDC accordingly )
Any doubts pls let me know...
Answer:
Hi guys,
my requirement is to send a mail from sap to outlook inbox directly.
SCOT triggering need to be done default.
thanks in advance.
tks
jenita