sap query

Former Member — Thu, 27 Dec 2007 09:08:52 GMT

hi i have been asked to work on sap query !!can u tell me waht is this !!something called sq01,sq02 etc. my req is the slection fields are matreila no, po doc no,vendor no and the deired output fields are material number,vendor number,po doc no,gr doc no,gr posting date,tax code!!can u give me a sample code for this!!!

Re: sap query

Former Member — Thu, 27 Dec 2007 09:17:12 GMT

Hi,

SAP Query is a tool to generate quick reports without getting any ABAP coding done

Consists of three components:

User Groups

Functional Areas/Infosets

Query

Transaction Codes for creation of SAP Query

SQ03 – User Groups

SQ02 – Functional Area/Infoset

SQ01 – Query

Advantages of SAP Query:

Designed for users having little or no knowledge of ABAP (SAP Programming Language).

No programming is required to generate the reports.

Different output options for the report like List display, ALV display, Graphical display etc. without doing any coding.

Options available to save output in Word or Excel format.

Options available to display output in different formats like Basic list, Statistics or Ranked List.

Disadvantages of SAP Query:

Complex reports including complex data selection, complex conditions and formulas are not achievable by SAP Query.

User Groups – A collection of users that work with about the same data and carry out the similar tasks. The members of a user group can access any of the query made by any of the user in the group. Users are not allowed to modify queries from other user groups, although they may, under certain circumstances, copy and execute them.

If you want further information see this link.

http://help.sap.com/saphelp_nw04/helpdata/en/d2/cb3efb455611d189710000e8322d00/content.htm

Reward points if it is helpful.

Regards,

Swetha.

topic Re: sap query in Application Development and Automation Discussions

sap query

Re: sap query