Tempy said:
Hi all, i have a certain report that i run in SAP on a daily basis and
save it as an excel file and then manipulate it.
Is it possible to run this report from Excel ?
Yes but it's unlikely that the administrators of the database would allow
the kind of access you require direclty to the tables.
If you can't access the tables, you're better off using an abap query (SQ00)
rather than a report to generate the data in the format you require and
saving it in excel format in a network location accessible by you (I say
this not knowing your level of access or skill, you may need someone to
create an "infoset" for you - this is a definition of which tables and the
kind of joins required). Your db admins may even be able to automate the
creation of the data file daily. You can then use excel to automate the
conversion of the data into the output you require.
I used to do this with PA & inventory information daily. Run the query and
save the data (30 seconds). Open the excel model to manipulate the data and
run my code to create the output data (15 sec). Quick & easy info.....
priceless....
