query

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[amit_khare]

I think this link will answer all questions -

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

Regards,

Amit

[Former Member]

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.).

[Former Member]

hi,

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

thanks

[Former Member]

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

[Former Member]

Hi,

Quick viewer is a simple query builder.

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

[Former Member]

hi all,

thanks for explaining.

[Former Member]

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