Vivek Pillay

• Nov 1st, 2005

 

RE: Which functions are used to transfer an excel sheet..

latha

• Nov 19th, 2005

 

hi vivek

lsmw is the function used to upload excel data into sap system

k.l.v.s.n. ramana murthy

• Nov 19th, 2005

 

is there any defference between real time and training session

sudhakar reddy

• Nov 22nd, 2005

 

you please find the function namestarts with ALSM_EXCEL*  in the function builder SE37.

ok

byeeee.

Niharika

• Dec 12th, 2005

 

LSMW is used for migrating data from a legacy system to SAP system, or from one SAP system to another. Apart from standard batch/direct input and recordings, BAPI and IDocs are available as additional import methods for processing the legacy data. The LSMW comprises the following main steps: ? Read data (legacy data in spreadsheet tables and/or sequential files). ? Convert data (from the source into the target format). ? Import data (to the database used by the R/3 application. But, before these steps, you need to perform following steps : ? Define source structure : structure of data in the source file. ? Define target structure : structure of SAP that receives data. ? Field mapping: Mapping between the source and target structure with conversions, if any. ? Specify file: location of the source file Of all the methods used for data migration like BDC, LSMW , Call Transaction which one is used most of the time? How is the decision made which method should be followed? What is the procedure followed for this analysis? All the 3 methods are used to migrate data. Selection of these methods depends on the scenario, amount of data need to transfer. LSMW is a ready tool provided by SAP and you have to follow some 17 steps to migrate master data. While in BDCs Session method is the better choice because of some advantages over call transaction. But call transaction is also very useful to do immediate updation of small amout of data. (In call transaction developer has to handle errors). SO Bottom line is make choice of these methods based of real time requirements. These methods are chosen completely based on situation you are in. Direct input method is not available for all scenario, else, they are the simplest ones. In batch input method ,you need to do recording for the transaction concerned. Similarly, IDoc, and BAPI are there, and use of these need to be decided based on the requirement.

sudhar

• May 1st, 2006

 

The function 'GUI UPLOAD' can be used to transfer the data from an excel file to SAP.

sandeep reddy

• Nov 19th, 2006

 

the function module used to convert exel into sap is

ALSM_EXCEL_TO_INTERNAL_TABLE

take internal table as ALSMEX_TABLINE

ram

• May 21st, 2007

 

use the existing T CODE

sankaran.ramaiah

 Profile Answers by sankaran.ramaiah Questions by sankaran.ramaiah

• May 24th, 2011

 

HI ,
you can use the function Module:TEXT_CONVERT_XLS_TO_SAP

thanks

Regards,
Sankaran