Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Query Crearion

Former Member

‎2007 Oct 04 10:27 AM

0 Likes
758

Hi,

In SQ02, i want to copy from one query name to another query name.and also

i want to add the new field in that query. How to copy it and add the new fields.

Regards,

Sathya..

Hi,

In SQ02, i want to copy from one query name to another query name.and also

i want to add the new field in that query. How to copy it and add the new fields.

Regards,

Sathya..

Reply
6 REPLIES 6
Read only

Former Member

‎2007 Oct 04 10:30 AM

0 Likes
727

hi

good

go through this link

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

reward point if helpful.

thanks

mrutyun^

Read only

Former Member

‎2007 Oct 04 10:30 AM

0 Likes
727

Hi Sathya,

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

Thanks,

Reward If Helpful.

Read only

Former Member

‎2007 Oct 04 10:32 AM

0 Likes
727

Give the query name in the infoset field...and click the copy(ctrl+F1) button...

you can copy the query....

Read only

Former Member

‎2007 Oct 04 10:32 AM

0 Likes
727

Hi,

Goto Transaction SQ01.

ENter the source query name which is to be copied.

Click on COPY BUTTON on the top.

Enter the target query name --> New name

Then click on CHANGE.

Add new fields

Best regards,

Prashant

Read only

Former Member

‎2007 Oct 04 10:38 AM

0 Likes
727

Hi

Query's are client specific and User specific

You can't copy them just like that

that's why they are not suggested to use

only functional consultants for their internal client calculatiosn they use

it. You can add a new field for the existing query

see the doc

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

Read only

Former Member

‎2007 Oct 04 10:40 AM

0 Likes
727

Hi Sathya,

To copy infoset, Goto SQ02, Give the source infoset name of query in Infoset field and clik on Copy(Ctrl+F1). Give your target infoset name and click on Enter.

You can add fields by clicking on the field and drag this on to right hand side Field Group. Generate (Shift+F6) after finishing of your changes.

Thanks,

Vinay