Which functions are used to transfer an excel sheet to an sap system.

Showing Answers 1 - 9 of 9 Answers

Vivek Pillay

  • Nov 1st, 2005
 

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

  Was this answer useful?  Yes

latha

  • Nov 19th, 2005
 

hi vivek

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

  Was this answer useful?  Yes

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

  • Nov 19th, 2005
 

is there any defference between real time and training session

  Was this answer useful?  Yes

sudhakar reddy

  • Nov 22nd, 2005
 

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

ok

byeeee.

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

ram

  • May 21st, 2007
 

use the existing T CODE

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions