topic Re: query in Application Development and Automation Discussions

query

Former Member — Tue, 03 Apr 2007 11:23:41 GMT

hi,

can have comment on

1) what is the difference for quickviewer and query

2) what is infoset for

3) what is user group for

4) steps to create quickviewer / query / infoset / user group

thanks

Re: query

Former Member — Tue, 03 Apr 2007 11:27:37 GMT

Hi,

1. Main Difference between Quickviwer and Query is that first one is user-specific and other one is generic.

2. Infoset , in 46B were called as Functional area. These are basically the things where u actually describe the tables, join conditions etc. which need to be used in the Query creation.

3. User Groups are the logical groupings of the queries. e.g. All queries made for MM will come under MM User group and so on.

4. For creation of a query first of all, u need to create an infoset, define the tables and joins between them.

5. Assign the Infoset to a user group and then create a query using the inofset.

Hope the above info helps.

Regards,

Himanshu

Re: query

amit_khare — Tue, 03 Apr 2007 11:29:12 GMT

I think this link will answer all questions -

http://searchsap.techtarget.com/searchSAP/downloads/Teach_yourself_SAP_C20.pdf

Regards,

Amit

Re: query

Former Member — Tue, 03 Apr 2007 11:40:09 GMT

hi,

1) why assigned infoset to user group?

2) quickviewer does not need infoset whereas query need infoset?

3) quickviewer required user group?

also thanks for the link. i will award accordingly.

Re: query

Former Member — Tue, 03 Apr 2007 11:45:54 GMT

Infoset needs to be assigned to user group if required. If not assigned, the it will behave as a generic infoset and any query can be linked to it.

Ideally, every infoset will be corresponding to some Functional area(MM, SD, PP etc.).

Re: query

Former Member — Tue, 03 Apr 2007 11:49:21 GMT

hi,

what about quickviewer that i asked? hope you can clarify.

thanks

Re: query

Former Member — Tue, 03 Apr 2007 11:51:47 GMT

Hi,

Quick viewer is a simple query builder.

you can just relate tables, give selection criteria and list fields.

Re: query

Former Member — Tue, 03 Apr 2007 11:52:17 GMT

Yes, Quickviewer I think doesnt needs infoset as there is one table only from which can view the data. Hence there is no option of placing a join on the tables and hence no infoset.

I am not so sure abt this but yes most probably this is the reason we dont use infoset with quickviewr.

Hope it clarifies ur doubt.

The third question, I am not so sure abt hence I am not in a position to answer ur third question.

Regards,

Himanshu

Re: query

Former Member — Tue, 03 Apr 2007 12:00:59 GMT

hi all,

thanks for explaining.

Re: query

Former Member — Wed, 18 Apr 2007 10:47:40 GMT

1) why assigned infoset to user group?

2) quickviewer does not need infoset whereas query need infoset?

3) quickviewer required user group?

1. because one info set could be used many of user groups and with one infoset you could create many querys in one or many user groups. If not assigned in any user group NONE of querys could be created.

2. quickviewer is only for simple reports for one user. In infoset you colud get data, call functions etc etc. so that no limitation of select data exist.

relp