Application Development 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
Showing results for 
Search instead for 
Did you mean: 

Regarding ABAP Query

Former Member
0 Kudos

hi all,

I am developing ABAP Query. After Developing how can i save that ABAP Query ( To Particular Transaction or Individual ).

Please Suggest.

Regards

Reddy

5 REPLIES 5

Former Member
0 Kudos

In the menu bar , u have an option to generate abap program for that query.

generate a pgm and then create tcode for that pgm ....

0 Kudos

hi All,

Can anybody send steps for creating ABAP Query.

Thanx & Regards

Reddy

Former Member
0 Kudos

hii

refer link given below

regards

twinkal

Former Member
0 Kudos

Go to Transaction SQ02.

1)Give Infoset a description, give source of data for infoset i.e. Logical Database or Tables etc.

2)If you have used logical database e.g. PNPCE then a screen will pop-up to select the infotypes.

3)Select the infotypes and continue.

4)f you later want to add more infotypes then click on menu item u2018Editu2019 -> u2018Change Info-Type Selectionu2019 and add or remove the infotypes.

5)If you have used tables then only give one table name and you will be brought to the screen where you can add more tables and specify joins between tables.

6)To add more tables, click on u2018Join Tablesu2019 and click on u2018Insert Tablesu2019.

7)You can drag and drop the matching field from one table to another to specify joins, you can also change the join type from inner join to outer join.

8)There is an area u2018Field Groupu2019 in infoset screen, only the fields that appear here will be available while creating queries. All fields from infotypes may not be available in field groups, so you will have to manually drag and drop them in appropriate field groups.

9)On the left hand side, under each node of infotype/table you will see some fields in blank or blue text color. Blue fields are those that are included in the infoset and hence available for reporting in SQ01.

10)Save and generate your infoset. This is mandatory, as when you generate the infoset, a program is generated with the code reflecting your changes in infoset.

Former Member
0 Kudos

Hi,

To assign a query to a particular transacton follow the below steps :

1) Open transaction SE93

2) Put object name ,sort text for your transaction

3) Choose radio button 5. Transaction with parameter.

4) Default value for transaction u2018START_REPORTu2019

5) In bellow default value section insert default value

SREPOVARI-REPORTTYPE = AQ "Parameter indicating Abap Query

D_SREPOVARI-REPORT = ZY_CS_ALLSLS "Query User group

D_SREPOVARI-EXTDREPORT= ZY_SLS_MST_001 "Query name

In 5th step make the changes according to your user group and Query name.