Abap Query

[Former Member]

Hi All

How to configure abap query?

How we create different queries?

How we execute different queries for reporting purpose?

Is there any standard queries for this thn plz mention?

Is it a pure functional work or help of abapers required for it?

Please help me out.

Points will be awarded for helpful answers.

Regards

Ashis

[Former Member · Accepted solution]

For step by step procedure to create an ABAP query you can refer to the following links

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

http://allaboutsap.blogspot.com/2007/09/sap-query-step-by-step.html

Reward if useful.

[Former Member]

Dear Ashis Patnaik,

I will suggest you to visit http://sap-img.com.

It will give you the overview of all the modules of SAP.

Moreover there is a separate section of FAQs with answers which will help you in great deal.

Do let me know in case of any queries.

Hope this helps you.

Do award points if you found them useful.

Regards,

Rakesh

[former_member204513]

Hi Ashis,

Go through these document which is having steps involved in the ABAP Quiery.

Step 1: Create User Group – SQ03

Follow the menu path – SAP Menu > Tools > ABAP Workbench > Utilities > SAP Query > User Groups

a) In the User Group: Initial Screen -

Enter User Group Code (self named)

Click on “Create”

b) In the User Group (Code): Create or Change pop-up window -

Enter the User Group Description

Click on “Save”

c) In the Create Object Directory Entry pop-up window -

Ö Click on “Local Object” button

Ö The User Group Created is saved

Step 2: Create User Group – SQ02

Follow the menu path – SAP Menu > Tools > ABAP Workbench > Utilities > SAP Query > Infosets

a) In the Infoset: Initial screen -

Ö Enter Infoset Code (self named)

Ö Click on “Create” button

b) In the Infoset: Title & Database Screen -

Ö Enter Description of Infoset in the “Name” field

Ö In the Data Source selection: Select appropriate Data Source by clicking

the radio button

· Source the data can either be multiple tables OR single table. There are 4

options for the user to select from

Ö Click on “Continue” (Enter)

Ö Selected Table gets displayed in the Infoset : Initial Screen

c) In the Infoset: Initial Screen -

Ö Click on “Insert Table” button

d) In the Add Table Screen -

Ö Enter the Table Name that is to be inserted

Ö Click “Continue” (Enter)

e) In the Infoset: Initial Screen -

Ö Click on “Back” button

f) In the Field Group Defaults pop-up Screen -

Ö Select Appropriate Field Group Option by clicking on the radio button

· there are 3 options to select from. User can select Empty Field Group

option and then select the data fields in the steps explained further.

Alternatively, User can select an option which clubs all the data fields

From all the tables selected

Ö Click “Continue” (Enter)

g) In the Change Infoset Screen -

· the left side lists the Tables that the user has selected in step b, c & d

· In the right side, system creates field groups, one for each table listed in the

left part. Initially, the Field Groups are empty

Ö In the Left Side, Click on the arror next to the table name and expand and

display all the data fields in the table

Ö Select a Data Field from the expanded Table view, which is to be added to

the Field Group on the right.

Ö Select a Field Group on the right side, in which Data Field selected above

has to be added

Ö Right click on the Data Field selected and click on “Add Field to Field Group”

Ö The selected Data Field gets added to the selected Field Group, which is

indicated by an arrow next to the Field Group.

Ö Carry out the steps above to add the required Data Fields to the respective

Field Groups

Ö After transferring Data Fields to Field Groups click on “Generate” button

h) In the Create Object Directory Entry Screen -

Ö Click on “Logical Object” button to generate the infoset

i) In the Change Infoset Screen -

Ö Click on the “Back” button

j) User is taken back to the “Infoset: Initial Screen” which displays the

created Infoset record.

Step 3: Assigning User Group to Infoset – SQ03

Follow the menu path – SAP Menu > Tools > ABAP Workbench > Utilities > SAP Query > User Groups

a) In the User Groups: Initial screen -

Ö Enter the User Group for which Infoset is to be assigned

Ö Click on “Assign Users & Infosets” button

b) In the User Group: Assign Users Screen -

Ö Click on “Assign Infosets” button

c) In the next screen, select the Infoset, which needs to be attached to the

User Group selected

d) Click on the “Back” button

Step 4: Creating Query – SQ00 & SQ01

Follow the menu path – SAP Menu > Tools > ABAP Workbench > Utilities > SAP Query > Queries

a) In the “Query from User Group: Initial Screen -

Ö Click on “Other User Groups” button

Ö In the pop-up screen, User Groups, select the User Group for which the

Query has to created. The pop-up screen closes.

Ö Enter the Query Code in the “Query” field

Ö Click on “Create” button

b) A pop-up screen “Restrict Value Range” shows the list of Infosets assigned to

the User Group

Ö Select the Infoset for which Query has to be created

c) In the new screen Create Query: Title, Format -

Ö Enter the Description of the Query in the “Title” field

Ö Click on the “Next Screen” button

d) In the Select Field Group” screen

Ö Select the Field Groups from which Data Fields have to be selected for the

Output

Ö Click on the “Next Screen” button

e) In the “Select Field” screen -

Ö Select the Data Fields, which should appear in the output

Ö Click on the “Next Screen” button

f) In the Screen “Selection” -

Ö Select the Data Fields for the selection criteria

Ö Enter the sequence in which the selected fields would appear in the input

screen of the query.

Ö Define if the selection criteria should be Single Value or Multiple Value Range

by clicking in the appropriate check boxes

Ö Click on the “Basic List’ button

g) In the screen “Query Layout Design” -

Ö Select the Output Fields from the Data Fields section by clicking the

appropriate check box

Ö Change the sequence of Data Field columns if required

Ö Click on the “Test” button to test the query created

h) On the “Test Query” screen click “Continue”

i) In the “Query” screen -

Ö Enter the selection criteria

Ö Click on “Execute” button

j) Save the Query created

Step 5: Running the Query – SQ00

a) In the Query From User Group: Initial screen –

b) Click on “Other User Groups” button to select the User Group

c) In the pop-up screen “User Groups” select the User Group

d) System lists all the queries created for the User Group

e) Select the appropriate Query

f) Click on “Execute” button

g) User is taken to the Selection screen

h) Enter the selection criteria and click on “Execute” button

i) System runs the query and gives the output

I hope it will help you

Thanks,

Murali.