topic SAP Query in Application Development and Automation Discussions

SAP Query

Former Member — Fri, 09 Dec 2011 05:37:29 GMT

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

former_member13738 — Fri, 09 Dec 2011 06:26:56 GMT

Could you please elaborate your requirement.

Regards

Leon

Former Member — Fri, 09 Dec 2011 06:38:17 GMT

Hi Friend,

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

Thanks and Regards,

Ramkumar R

Former Member — Fri, 09 Dec 2011 07:03:29 GMT

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