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: 

SAP Query

Former Member
0 Kudos

HI Expert,

I have to prepare a query , can any one let me know How to prepare query

Moderator message : Search for available information, thread locked.

Edited by: Vinod Kumar on Dec 9, 2011 2:54 PM

3 REPLIES 3

0 Kudos

Could you please elaborate your requirement.

Regards

Leon

Former Member
0 Kudos

Hi Friend,

Just Explain your Requirement in brief, What kind of query you want.

Thanks and Regards,

Ramkumar R

Former Member
0 Kudos

Hi,

First u have to create infoset using T-Code SQ02

In that u have to select TableJoin else if u have select LDB as DATASOURCE

I tabel join give the table name u want to join

In infoset initial screen insert the table using insert table tab.

Then Goback and select all fields or all keyfields whatever u want.

saveit.

Afetr GOto SQ03 tcode for giving authorization

give authorization name(user defined)

create it

In the same screen click on Assign User and Infosets tab

In assign users screen click on Assign Infosets Tab

there u have to check the infoset name(u have given in SQ02)

save it.

Go to SQ01 tcode and create query and select the infoset what u have created.

there u have to give title and notes and click on Basic List

Layout design will be open.

there u can desing the query(selection parameters and output parameters)

Regards

krishnakiran