SAP Query creation and Trasaction Code

Query Creation steps:

Creation of User Group:

T Code:

SQ03

Name user group and press create tab

Add in a small description in the pop up and press SAVE tab

Infoset  (SQ02) are not yet created so we don’t add users and infoset to the user group created

T Code: SQ02

Creation of Info Set

Punch in the infoset name  and press create tab

Put in a short description of the infoset, enter a table name in 'Table join using table basis' and press enter

Press Edit and then insert table option on the top bar

Put in the table name to be joined and press enter (more than two tables can be joined)

Now right click on the connecting line between the two tables and choose left outer join

Press the info set tab or F6

Choose option Include all table fields ---in case all fields are to be chosen, or create enpty field groups---in case we need to put in the fields in the empty groups and press enter

Incase of all table field option all the fields would be inserted in the field gropus, in case of empty field groups we need to choose and drag the options to the empty groups

Press generate

Press local object

T code: SQ03

Assigning the Infoset to the User Group

Put in the user group already made in step 1

Press Assign users and infosets tab

Put in the log in id of the users who need to be authorised to run this report

Now press the tab 'Assign Infosets'

Choose the infoset created and press save

T Code: SQ01

Create Query

1

Put in the query name and press create tab

2

Add in a short description of the query

3

Press the forward arrow (-->) tab on the bar

4

Check the tables names

5

Press the forward arrow (-->) tab on the bar

6

Choose the fields which we would like to appear as we run the query

Steps 4-6 can also be done by press the basic list tab

In the basic list 'Test' tab can also be used to test the query run

Go to SQ03

Follow the path

Query---More functions---Display report name

Copy the report name

Making T Code for Query

T Code: SE93

Put in a Tcode Name starting with Z and press create

Choose the radio button repot trasaction

Put in a short text for name and press enter

Paste the report name in the programe space

Save