Skip to Content
author's profile photo Former Member
Former Member

Creating Ad-hoc Reports in SAP

Hi All,

Looking for a tool in SAP for creating Ad-hoc Reports by users (i.e., ability to create instant reports without any programming). Please advise a tool which is not considered obsolete and is a part of SAP's future strategy. Many thanks!

Best Regards,

Tanvir

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2007 at 04:12 AM

    Hi

    You can use the SAP query and

    Report painter/Report Writer

    for designing the reports without programming.

    see the links

    report painter/writer

    Report Writer functions can be accessed from within the Report Painter.

    The difference lies in the GUI of the report painter.

    For Report Painter

    http://help.sap.com/saphelp_47x200/helpdata/en/66/bc7d2543c211d182b30000e829fbfe/content.htm

    For Report Writer

    http://help.sap.com/saphelp_47x200/helpdata/en/66/bc7dc143c211d182b30000e829fbfe/content.htm

    Refer the following links :

    http://www.virtuosollc.com/PDF/Get_Reporter.pdf

    http://sap.ittoolbox.com/groups/technical-functional/sap-r3-other/accessing-tables-using-report-painterwriter-98766

    http://help.sap.com/saphelp_47x200/helpdata/en/da/6ada3889432f48e10000000a114084/frameset.htm

    http://help.sap.com/saphelp_bw31/helpdata/en/66/bc7d2543c211d182b30000e829fbfe/frameset.htm

    SAP Query

    http://help.sap.com/saphelp_46c/helpdata/en/35/26b413afab52b9e10000009b38f974/content.htm

    http://www.thespot4sap.com/Articles/SAP_ABAP_Queries_Introduction.asp

    Step-by-step guide for creating ABAP query

    http://www.sappoint.com/abap/ab4query.pdf

    ABAP query is mostly used by functional consultants.

    SAP Query

    Purpose

    The SAP Query application is used to create lists not already contained in the SAP standard system. It has been designed for users with little or no knowledge of the SAP programming language ABAP. SAP Query offers users a broad range of ways to define reporting programs and create different types of reports such as basic lists, statistics, and ranked lists.

    Features

    SAP Query's range of functions corresponds to the classical reporting functions available in the system. Requirements in this area such as list, statistic, or ranked list creation can be met using queries.

    All the data required by users for their lists can be selected from any SAP table created by the customer.

    To define a report, you first have to enter individual texts, such as titles, and select the fields and options which determine the report layout. Then you can edit list display in WYSIWYG mode whenever you want using drag and drop and the other toolbox functions available.

    ABAP Query, as far as I Believe, is the use of select statements in the ABAP Programming. This needs a knowledge of Open SQL commands like Select,UPdtae, Modify etc. This has to be done only by someone who has a little bit of ABAP experience.

    To sum up, SAP queries are readymade programs given by SAP, which the user can use making slight modification like the slection texts, the tables from which the data is to be retrieved and the format in which the data is to be displayed.ABAP queries become imperative when there is no such SAP query existing and also when there is a lot of customizing involved to use a SAP Query directly

    use either SQ02 ans SQ01

    or SQVI tr code

    for more information please go thru this url:

    http://www.thespot4sap.com/Articles/SAP_ABAP_Queries_Create_The_Query.asp

    http://goldenink.com/abap/sap_query.html

    Please check this PDF document (starting page 352) perhaps it will help u.

    http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCSRVQUE/BCSRVQUE.pdf

    check the below link will be helpful for u

    once you create query system generates a report starting with AQZZ/SAPQUERY/ABAGENCY2======= assing this report to tr code for the same

    Regards

    Anji

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Anji,

      Thanks a lot for your detailed and extremely useful information. Level of your help is truly remarkable, far exceeding my expectations. I feel highly obliged & greatly appreciate it!!!

      Best Regards,

      Tanvir

  • Posted on Nov 30, 2007 at 11:05 PM

    Check SAP Query

    Tcodes:

    SQVI - Quick Query

    SQ01 - Query Builder

    Regards,

    Naimesh Patel

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.