What is SAPquery

[Former Member]

hi .

can u explain about sapquery.

rewards as per ur answer.

[Former Member]

hi kiran,

The SAP Query application is used to create reports not already contained in the default. 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 reports and create different types of reports such as basic lists, statistics, and ranked lists.

The SAP Query comprises five components: Queries, InfoSet Query, InfoSets, User Groups and Translation/Query.

Classic reporting- the creation of lists, statistics and ranked lists- are covered by the InfoSet Query and Queries components. Other components’ range of functions cover the maintenance of InfoSets, the administration of user groups and also the translation of texts created in the SAP Query.

All data required by a user for a report can be read from various tables.

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. In the WYSIWYG mode, you can edit the lists using Drag & Drop and various toolbars.

The SAP Query comprises five components: Queries, InfoSet Query, InfoSets, User Groups and Translation/Query

The InfoSet Query component offers an alternative way to maintain queries. Calling up this component is described under Calling Up the InfoSet Query.

From each screen of every component, you can use the Environment option to call up one of the other components.

Different groups of users work with the different components of the SAP Query. See SAP Query User Groups.

reward points if helpful

[Former Member]

Hi Kiran,

ABAP/4 Query is a <b>powerful tool</b> to generate simple reports without any coding.

ABAP/4 Query can generate the following 3 simple reports:

<b>Basic List:</b> It is the simple reports.

<b>Statistics:</b> Reports with statistical functions like Average, Percentages.

<b>Ranked Lists</b>: For analytical reports.

For creating a ABAP/4 Query, programmer has to create user group and a functional group.

Functional group can be created using with or without logical database table. Assign user group to functional group.

Finally, create a query on the functional group generated.

Regards,

Sonal

<b>Reward points if helpful</b>

[Former Member]

Hi,

query is for faster reporting.

see this link

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

rgds,

bharat.

[Former Member]

Hi,

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

<b>SAP query</b>

Also check this link

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

http://www.sapmaterial.com/?gclid=CN322K28t4sCFQ-WbgodSGbK2g

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

https://www.sdn.sap.com/irj/sdn/advancedsearch?query=how%20to%20create%20sap%20query&cat=sdn_all

Refer below Links :

Regards,

Padmam.

[Former Member]

<u><b>SAP Query </b></u>

<b>Purpose</b>

The SAP Query application is used to create reports not already contained in the default. 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 reports and create different types of reports such as basic lists, statistics, and ranked lists.

<b>Features</b>

The SAP Query comprises five components: Queries, InfoSet Query, InfoSets, User Groups and Translation/Query.

Classic reporting- the creation of lists, statistics and ranked lists- are covered by the InfoSet Query and Queries components. Other components’ range of functions cover the maintenance of InfoSets, the administration of user groups and also the translation of texts created in the SAP Query.

All data required by a user for a report can be read from various tables.

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. In the WYSIWYG mode, you can edit the lists using Drag & Drop and various toolbars.

Regards,

Pavan

[Former Member]

hi

The SAP Query application is used to create reports not already contained in the default. 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 reports and create different types of reports such as basic lists, statistics, and ranked lists.

Features

The SAP Query comprises five components: Queries, InfoSet Query, InfoSets, User Groups and Translation/Query.

Classic reporting- the creation of lists, statistics and ranked lists- are covered by the InfoSet Query and Queries components. Other components’ range of functions cover the maintenance of InfoSets, the administration of user groups and also the translation of texts created in the SAP Query.

All data required by a user for a report can be read from various tables.

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. In the WYSIWYG mode, you can edit the lists using Drag & Drop and various toolbars.

pls go thru this http://www.olemiss.edu/projects/sap/SQ01_10_03.pdf

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40bec8da-4cd8-2910-27a9-81f5ce10...

thanks

[Former Member]

Hi Sridar,

would you pls help on almost similar issue, My percentage value in output is not correct. you can view the details in following link,

http://scn.sap.com/thread/3260910

regards

Muhammad Shoaib