This website is not affiliated with, sponsored by, or approved by SAP AG.

Importing or Removing data in SAP from Excel file

Development (ABAP Development WorkBench, ABAP/4 programming)

Moderators: Snowy, thx4allthefish, YuriT, Gothmog

Importing or Removing data in SAP from Excel file

Postby rafaelo » Thu Mar 04, 2010 7:05 am

Dear All,

I'm not sure if this is the correct section to post this question in, so please excuse me in advance if it's wrong.

I'm trying to do the following through CUA:

I have an excel sheet with users and roles. Lets say user1 has 5 roles, user2 has 10 roles, user3 has 2 roles etc and all this is written in an excel shet.
I need to remove those roles base on this excel sheet. I believe this can be done through transaction LSMW but i don't have the technical knowledge
to program it. Also i don't know how SAP will make the connection with the excel sheet. Any advice would be highly appreciated. Thank you in advance.

Kind Regards,
Rafi Hovsepyan
rafaelo
 
Posts: 6
Joined: Tue Jan 19, 2010 1:15 am

Re: Importing or Removing data in SAP from Excel file

Postby YuriT » Thu Mar 04, 2010 11:53 pm

In LSMW you can for example map excel sheet fields to a Batch input recording and then run it.
You can also read data from Excel into your ABAP program and perform needed actions from within the program.

But in either case you need technical knowledge to do that. Less for LSMW, but still.
YuriT
 
Posts: 885
Joined: Fri Feb 03, 2006 6:40 am
Location: Basel/Riga

Re: Importing or Removing data in SAP from Excel file

Postby rafaelo » Fri Mar 05, 2010 3:35 am

Thanks for your answer. I found this really useful tutorial on how to build my own LSMW Project:

http://www.sap-img.com/general/lsmw-ste ... ration.htm

Do you think it might come in handy ?


Cheers
rafaelo
 
Posts: 6
Joined: Tue Jan 19, 2010 1:15 am

Re: Importing or Removing data in SAP from Excel file

Postby YuriT » Fri Mar 05, 2010 4:52 am

Well this one explains how to build LSMW batch input. You need LSMW batch input. So I guess yes :)
But be sure you have a sandbox system and a lot of guinea-pigs before you actually do anything in a real system.
YuriT
 
Posts: 885
Joined: Fri Feb 03, 2006 6:40 am
Location: Basel/Riga


Return to ABAP

Who is online

Users browsing this forum: Google [Bot] and 7 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.