SAP Bi-Writing Queries

Posted on 2011-10-11
Last Modified: 2013-12-08
Hey Everyone,

Just wondering if there was a way in SAP to write SQL statements to query out data? Right now all I am able to do in the front end (Netweaver) is view/click on  various reports or store systems but these all have limitations. Also, through the back end (BEX Analyzer) I was also unable to find a way to write queries to obtain the data.

Is this possible at all? It would make my life a whole lot easier than simply cliking on fields or the  critieria I wanted and not having it come back in the format I wanted.

Question by:vtahal17
    LVL 9

    Accepted Solution

    SAP QuickViewer (Transaction Code: SQVI)
    Data Viewer(Transaction Code SE16)

    Author Comment

    Thanks. How do I access quick viewer or data viewer in Netweaver and BI? I am very new to SAP and do not see any links for these...

    Author Comment

    Here is what i see on the front end...

    Author Comment

    Here is what I see on the back end (BEX Analyzer)

    Author Closing Comment

    Was not specific

    Featured Post

    Looking for New Ways to Advertise?

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

    Join & Write a Comment

    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
    Via a live example, show how to shrink a transaction log file down to a reasonable size.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    731 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

    15 Experts available now in Live!

    Get 1:1 Help Now