2009 Apr 20 7:33 AM
Hi All,
I am trying to capture some data or records which we update weekly in our project.
Right now,we are using Microsoft xls.But I want it in SAP.
So can anyone suggest,which should be the approch to go for that?
Should I use table maintence generator or go for ALV report?
Please provide notes or links.
2009 Apr 20 7:37 AM
hi,
you can go for ALV
Please check this link
http://help.sap.com/saphelp_erp2004/helpdata/en/22/a3f5fed2fe11d2b467006094192fe3/frameset.htm
thanks
2009 Apr 20 11:50 AM
I want to capture data from microsoft xls sheet?
SO please guide me how to build alv or anything else?
I hardly did any coding and alvs?
2009 Apr 20 11:53 AM
hi,
u can capture the data using ALSM_EXCEL_TO_INTERNAL_TABLE.This FM will fetch the data from xsl and put this in an internal table row wise and column wise.Then u can fetch the details into the internal table to be displayed and display it as alv or in the pout put format u require.If ur updating any table in the program after fetching the details u can insert into the table.If the user wants to view the data u can display it in alv and provide a button on which executing the details can be stored in the tables.
Edited by: soniya baboo on Apr 20, 2009 12:54 PM