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

Query

Dear Seniors,

what is the difference in S_PH0_48000510 - Ad Hoc Query & T.codes SQ01, SQ02 & SQ03?

by these T.codes also we r creating a query only?

Regards

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 07, 2009 at 09:30 AM

    Hi Ritu

    Ad Hoc Query is an HR specific area, transaction code S_PH0_48000510 is used specifically for HR reporting

    - it is part of the SAP Query concept

    SQ01 has many more functions it is cross component transaction for the SAP Query concept - its scope is generally wider - - here are some examples of what can be done in the transactions you mentioned -->

    Create the Query based on the Functional Area (SQ01)

    Create a Functional Area/ Infosets (SQ02)

    Create an User Group (SQ03)

    Ad-hoc queries are generally very direct specific reporting tool, returning specific output based on defined selection and output criteria with SAP Query you may be able to return more complex datasets, comparisons etc - you probably only really

    get to see the differences when using both in depth

    I found the following wiki entry very useful

    https://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=30083

    Best wishes

    Stuart

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi

      SQ01- Consultant devlop it and give to customer .this can be used for reports not avilable in STD Sap reports.You can access LDB and save it.Anytime client can select the report name and get the o/p.Here you can access all tables and ldb.

      S_PH0_48000513-Adhoc query-you can access to certain infotypes and u can save the query.at anytime u wanted u can select the report name as like sq01.

      PQAH.-Time being you can see the report and no save option is there.

      Hope i reach u atleast half

      with regars

      partha

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.