SQ01 QUERY DOWNLOAD

Here are the actions that can be done when user double clicks the row: You cannot change the infoset later, so be sure which infoset you want to choose, otherwise you will have to create a new query to choose a different infoset. Thanks and regards Like 0 Former Member November 27, at Data processing in Queries Data can be processed and presented in 3 ways: May 9, at 4: November 27, at

Uploader:	Dozahn
Date Added:	2 November 2016
File Size:	57.93 Mb
Operating Systems:	Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads:	67952
Price:	Free* [*Free Regsitration Required]

To execute an existing query, select it from the table, and choose Execute F8.

May 9, at 3: To create a new query, enter a name for it, and choose the Create button. Thank you, good day.

I want to go directly to the sales order when I click onto the line of this ALV grid. May 9, 5 minute read. January 14, at 8: July 7, at 4: Thanks and regards Like 0 Former Member November 27, at A special authorization is usually required to create an InfoSet and to maintain its properties.

SAP Query – Creation & Execution – Table Join & Logical Database

Can anyone also help for Making t-code after completing all the query building so that user can use via t-code. November 25, at 7: SAP Queries are always accessible to all members of your own user group. I have created the Infoset and added some additional custom fields to it. You would therefore create an SAP Query if you determine that you want to run a particular database query frequently, and want it to be flexible to operate.

Select the InfoSet which had been created.

Identify your request number. April 23, at 8: Open link in a new tab. Every user in a system can be assigned to several user groups. Hi, I liked the blog a lot. An InfoSet is a special view of a data source.

An InfoSet can be assigned to several roles or user groups. We have defined custom subtype in infotype communiction.

SAP Adhoc Query SQ01 SQ02 SQ03 | SAP Blogs

SQ02 Here we will include all of our tables or infotypes that will provide us data for our queries. Advantages - By creating InfoSets and assigning them to roles or user groups, the system administrator determines the range of reports that the individual application departments or end-users are able to generate dq01 the SAP Query. Other option is to put Communication Subtype on Selection Screen and select only the subtype in which you are interested, but I do not recommend this approach, why?

Like 0 Former Member January 14, at 8: Thanks for the wq01 valuabledocument…. Well if you hoping that it will open up an infotype, then it will not do it. As soon as a suitable InfoSet is available for your user group, you can generate a query for it: May 9, at Creation of Query — SQ Users in a user group need to have the necessary authorizations before they are able to change or redefine aq01 query. You are in comment section in a blog post. Top ten customers of a travel agency.