I have never used SAP before and am in dire need of pulling massive historical sales data and putting it in an access database.
I wanted to know if there was any way to get back end access (i.e. via ms access or an odbc connection) so that I can query out the data and not have limitations on size or rows.
Currently, here is what I have tried...
(1) Pulling data from the front end (SAP Netweaver). But it becomes difficult if not impossible to pull store/article level data and it often times out.
(2) Pulling data from BEX analyzer (BI) through excel directly. But this also has its limitations (65,000 rows).
Any help would be appreciated as I signed up for EE only b/c of this issue...