Using MS Access Queries to Pull Data From SAP

Posted on 2011-10-11
Last Modified: 2013-11-05
Hi Experts,

There HAS to be a more efficient and easier way of getting large  amounts of data from SAP.

Trying to determine if there is a way to use MS Acess 2007 to query out data from SAP Netweaver (BI)? When I have been using the front end of SAP to pull data, it has its limitations and often times out. I figure if I can establish a connection in Access, I can pull and store more data.

I don't think I can use an oracle connection as I don't have a username or password. Thanks for the help in advance.
Question by:vtahal17
    LVL 8

    Expert Comment

    LVL 8

    Expert Comment

    But the simplest way would be to save it as a text file or tab delimited to your desktop, then open Access and import it (File, Get External Data, Import...).

    Author Comment

    Hey I appreciate this but none of those codes worked for me. I am not a programming expert so I don't know how to debug them. Is there an easier way to tap into the back end of SAP?
    LVL 24

    Expert Comment

    With all likliness there is some ODBC driver to access that service. If that  is possible one must be able to use Access for accessign them.
    LVL 7

    Expert Comment

    Hi vtahal17,

    I am sorry, but Why do you want to extract the data from SAP? SAP is designed to work with a lot of data, access not!
    So what do you want to do? Create some special requests from some tables?

    If you want to create your own quickview on some tables you could try the quickviewer in SAP-menu-bar -> System -> services -> quickviewer

    If you want to get data from SAP there should be three ways:
    1. extract the data using frontend -> i.e. se16 show data than extract it using System -> list -> save -> local file ... this will only work for smaller amount of data.
    2. create an abap programm which exports the data to a file which access can import ... this would work even for bigger data.
    3. access the data directly from DB -> this will need a DB user/password and a driver to access tha data

    But again the question: Why do you want to export the data. Once extracted the data will be old, because the data in SAP was updated ...

    Best regards

    Author Comment

    Hi Gnurl,

    Thanks for the advice but I don't see the options you mentioned for accessing the quickviewer in SAP. Attached are the two views of SAP I have (one in BI on the front end and one for BEX in Excel).

    Also, Since I do not have a database username/password, option 3 is not likely. But I have heard of other mentioning abap programming. How do I do that to access the data?

    Basically I want to export historic sales data (from 2008-current) by market and article level. The data is going to be old, but that's the point. The SAP I am using does not allow for market to be pulled which is yet another issue (I have been pulling by store and rolling up).

    I have tried IT for direct access to the cube in SAP but they will not grant me permission.


    LVL 7

    Accepted Solution

    Hi Vtahal,

    as I can see, it would be quite complex to extract data from all the tables you need. BI cubes are not flat tables, the data is structured in a so called star scheme needing quite complex sql strings to get the data you want.

    I think the best way would be to ask your BI-Team to create the selection you need to be exported.
    Programming in ABAP would need a skilled programmer as well.

    Good luck

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    Creating and Managing Databases with phpMyAdmin in cPanel.
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now