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

Advertisement

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.
Thanks

Advertisement

Hi Ramesh,
You can download the data into application server using the following code. You will have the vendor details in the internal table. Then you will open a file and transfer the data as follows.
*   Download internal table to Application server file(Unix)
DATA: e_file like rlgrap-filename value '/usr/sap/tmp/file.txt'.     
  open dataset e_file for output in text mode.
  lOOP AT it_datatab......
    transfer it_datatab to e_file.
  ENDLOOP.
  close dataset e_file.
In application server you will have only files and not excel sheets.
Reward points if useful,
Aleem.

October 11, 2015

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  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 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

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

How to delete the Junk Data From Excel Sheet

Dear ABAPers,             I am uploading the Excel sheet from the Desktop to the SAP System. In the Internal table i am getting Unwanted Junk data's for Example '##########'.I am not getting this Junk data for all the times. i am getting it for Some

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

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

Uploading Data From Excel Sheet to SAP Database Tables

Dear Friends, We are having an Excel Sheet with 90 different columns. Now we want only 2 of the columns to be uploaded in the database tables. So, Plz tell me which function module will be suitable for this. And plz help me with the code also. Thanks

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

To load master data into infoobject 0mat_unit

Hi Experts, Cud you pls give me any idea to load master data into infoject 0mat_unit from R/3. We need more than 10,000 master data into 0mat_unit. How can I collect data from R/3 for different attributes of infoobject 0mat_unit? I will assign full p

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 know which master data objects need to activated  in R3

SALES OVERVIEW CUBE -0SD_C03 How to know which master data objects need to activated from delivery version to active version in R/3 for a particular standard cube like 0SD_C03. its very urgent please advise. R/3 in RSA5 Sales Master Data 0ACCNT_ASGN_

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 create customer master data for walking customer in retail

hi experts !!!!!! for retail industry e.g books trading industry how to create customer master data for walking customer in retail its dummy or one time customer if i create one time customer then same customer number can i use for every new order an

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

How to download internal table data into xml file?

Hi, Experts, I have downloaded internal table data into XLS format using GUI_DOWNLOAD Function module, But i didn't Know how to download internal table data into XML format please post some ideas/inputs on this issue. Thank you, Shabeer ahmed.check t