12-09-2011 5:37 AM
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
12-09-2011 6:26 AM
12-09-2011 6:38 AM
Hi Friend,
Just Explain your Requirement in brief, What kind of query you want.
Thanks and Regards,
Ramkumar R
12-09-2011 7:03 AM
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