How to  send ALV output data into Excel sheet format via Mail to the user?

Advertisement

Hi friends,
I have a doubt ie,
How to  send ALV output data into Excel sheet format via Mail to the user?
regards
Moosa

Advertisement

Hi,
Provide the output internal table to the objbin in the below FM
Send Message
  CALL FUNCTION 'SO_NEW_DOCUMENT_ATT_SEND_API1'
       EXPORTING
            document_data              = i_docdata
            put_in_outbox              = c_x
       TABLES
            packing_list               = i_objpack
            object_header              = i_objhead
            contents_bin               = i_objbin
            contents_txt               = i_objtxt
            receivers                  = i_reclist
and specify the document type
  i_objpack-doc_type   = 'XLS'.
and try.
Regards,
Nandha

October 11, 2015

How to  send ALV output data into Excel sheet format via Mail to the user?

Hi friends, I have a doubt ie, How to  send ALV output data into Excel sheet format via Mail to the user? regards MoosaHi, Provide the output internal table to the objbin in the below FM Send Message   CALL FUNCTION 'SO_NEW_DOCUMENT_ATT_SEND_API1'   

How to downlaod vednor master data into excel sheet in SAP Application ser

Hi friends I want to download SAP vendor master data into excel sheet and the file should be stored in SAP Application server Location with padding zeros. Please help me. ThanksHi Ramesh, You can download the data into application server using the fo

How to populate the Quering data into Excel sheet in Oracle

Dear Guys, How to populate the Quering data into Excel sheet in oracle. Please provide a solution. Thanks & Regards, Senthil K KumarHi To make Excel sheets from sqlplus, you can use the markup html tag in sqlplus. Here's an example. Example <code&g

Export Data into Excel Sheet in UNIX

Hi All How to export the table data into excel sheet in unix. ThanksCreate a csv file. A csv file is just an ascii file, so it doesn't matter what OS you are on.Read other 2 answers

Download internal table data into excel sheet with column heading and data

Hi,   I am having one internal table with column headings and other table with data. i want to download the data with these tables into an excel sheet. It should ask the user for file name to save it on their own name. They should give the file name

Alv output download to excel sheet spliting into three line

hi, i have developed alv report with 62 fields (62 colums).when i download this output into excel sheet each line spliting into three line.each field has 20 char length.i want download each row as single line. i am using local file  (ctrl + shift+F9)

Download colored ALV output in to EXCEL sheet

Hi , I want to download colored ALV output to Excel sheet with color. one of the field in ALV is with 4 colors depending on condition. i am unable to download the color using download option(that field is comming with out color). Please help me by pr

Downloading table data into Excel sheet - Webdynpro Java

Hi All, We have developed a custom webdynpro application that executes an RFC and displays data in Table UI element. We have provided a button to download the data in excel sheet. When data is huge like, total number of rows filled up in the table ar

How to convert internal table data into excel format?

Hi all, I want to convert internal table data in excel format and then send it as email attachment in workflow. Please tell me how do i perform this. Regards, Arpita.Hi Arpita, Try this sample code:: Send mail maildata-obj_name = 'TEST'. maildata-obj

Oracle function to extract data into excel sheet

I have extracted data from a couple of tables onto a view. Basically I have got about 15 coloums in that view but i need to extract the data in the view into an Excel sheet. I just want to know if their is a function in oracle whereby i can export th

Exporting data into excel sheet from CRM

Hi All, I am facing problem while extracting data from CRM - Service Process Monitor. I tried to extract data(records) from executed service process monitor through System -> List ->Save->Local file->Spreadsheet I am not getting actual records

Need to download the ALV blocked output in to excel sheet

I have a requirement where there is a need to download the Alv block output to excel sheet. when i click on excel button which is on output only header block data is coming in excel sheet.but i need both header block and item block data into excel.Hi

How we export report data into excel in report 10g

hi can any one tell me how we export report data into excel in report 10g (except spreadsheet)We can use TEXT_IO PackageRead other 2 answers

How to export the data as integer into excel sheet?

Hi All,      I am working on export to excel functionality and using JEXCEL API to create it.  When I export the data to excel sheet, the data are stored in text format in the excel sheet.  If I click on summation button on excel sheet,  it is not su

How to send SMARTFORMS output as attachment through?

how to send SMARTFORMS output as attachment through e-mail? after executing SMARTFORMS how to send that output via e-mail. Help me. thanks surya. Moderator Message: Please search for available information first Edited by: kishan P on Nov 7, 2010 7:19

How export report into excel sheet automatically using SSRS 2010?

Hi, I have created many reports using SQL Server Data Tool 2010 and at my work, we are using active batch to ran reports every month. Now question is, my boss want me to set up reports such a way that when active batch is ran, reports should be expor

How to load tab limited data into apllication server

Hello All, I have 2 questions. 1)I have data in a table,i want to place this data in the applcation server with tabdelimiter in ASC.How do i proceed? 2)I have the data in my application server in a compressed text format,i want to download this data

About how to send ALV through email

Hi  everyone ,       I have a problem about how to send ALV through email  in background . if someone knows , pls tell me . thanks in advance Best Regard NickI write a test program , but it doesn't work , use any exists ALV program in the system , an

How to insert one table data into multiple tables by using procedure?

How to insert one table data into multiple tables by using procedure?Below is the simple procedure. Try the below CREATE OR REPLACE PROCEDURE test_proc AS BEGIN INSERT ALL   INTO emp_test1   INTO emp_test2   SELECT * FROM emp; END; If you want more e

How to read the data in excel sheet

Dear sir, How to read the data in excel sheet when i recieve a data serial communication... ie i have store a data in excel such that Cell A       Cell B    A           Apple     B           Ball    C           Cat    D           Doll when i recieve