topic Re: quey in Application Development and Automation Discussions

quey

Former Member — Thu, 25 May 2006 04:49:04 GMT

what is an infoset query..?

how is it created,...

do discribe the need and diffrence from queries and user queries..

regards,

Re: quey

sbhutani1 — Thu, 25 May 2006 04:51:43 GMT

Hi swaminathan,

You can follow this link for information on infoset query

http://help.sap.com/saphelp_46c/helpdata/EN/24/fc9638f5f0283de10000009b38f8cf/content.htm

Regards

Sumit Bhutani

Re: quey

Former Member — Thu, 25 May 2006 04:55:23 GMT

A tool that provides reporting on one or multiple ODS Objects. InfoSet Query provides Web reporting capabilities (previously known as ABAP Query or SAP Query).

Check this link.May be it can help you.

http://help.sap.com/saphelp_nw04/helpdata/en/ed/084e3ce0f9fe3fe10000000a114084/content.htm

<b>And good pdf doc is there....

http://www.sappoint.com/abap/ab4query.pdf</b>enjoy.

Re: quey

Former Member — Thu, 25 May 2006 05:00:40 GMT

GUD

GO THRUOGH THIS

To access data stored in the system, InfoSet Query uses an InfoSet. It provides you with a view of data in specific parts of HR that is structured by infotype. On the initial InfoSet Query screen, the InfoSet is displayed with its field groups as an overview tree. This overview tree enables you to choose selection fields and output fields.

The InfoSets used in InfoSet Query are created and managed in SAP Query. When you create an InfoSet, you select a logical database on which the InfoSet is based, and determine which infotypes are included in the InfoSet. They are displayed in the InfoSet as field groups. After you have selected the infotypes, you can determine which fields are included in the field groups for each infotype.

If you want to create an InfoSet, you should first discuss the requirements for the InfoSet with the appropriate application department.

You must clarify the following points:

Which data source corresponds to the requirements?

Example: Material evaluations in materials management or document evaluation in financial accounting.

Which fields do you need to include in the InfoSet?

Do you need additional information which is not available in the data source? (This calls for the linking of additional tables and the definition of additional fields).

Do you need parameters and selection criteria? (parameters and selection criteria appear appear on the selection screen of queries which are created using the InfoSet).

Do you have to take any special measures such as access protection?

Do you have to change the long texts and headers of the selected fields?

The last two points are rather less important, since you can add these components to an existing InfoSet at any time. However, the choice of data source determines the reports you can produce with this InfoSet.

When you have resolved these questions, you can create the InfoSet. Proceed as follows:

Call the component Maintain InfoSets.

This takes you to the initial screen for editing InfoSets.

Enter a name in the InfoSet field.

InfoSet names can contain up to 24 characters. The lower half of the screen displays all of the InfoSets that already exist.

Choose Create.

You then go to the Title and Database screen. For further information, read the following sections.

THANKS

MRUTYUN

Re: quey

Former Member — Thu, 25 May 2006 05:28:07 GMT

can u kindly mnetion thestep by step procedure to create an infoset query...i am still having some difficulties..

u can mention the things int the sap r3 gui to select in order to create an infoset ...

thanks in advance

Re: quey

Former Member — Thu, 25 May 2006 05:54:41 GMT

GOOD

Steps on how to proceed to create a Query:

ADHOC QUERY

A query can be created to extract information from master records i.e Infotypes. For example, by creating a query , the data relating to an employee contained in various Infotypes can be extracted.

Proceedure :

Decide on the various Infotypes we want to make the query. Decide on the area where we want to query i.e Global area or Standard area. Standard area is client specific and globel area will include all clients.

Menu : HR – PM – Admn - Information System - Adhoc Query

Select area standard and select the user group already created

Creation of new query :

TC SQ03 - Select Environment – Select Standard Area - Enter -- If new user group is to be created, enter name of the user group, click on create and enter necessary information and exit after saving

TC SQ02 - Enter name of the Infoset – Create – enter name of Infoset - Data source -- > Table join by basis table – give name of table e.g pa0000 - Enter - Click on insert table if we want to include more tables – give name of table one by one and after finishing, place cursor on the joining lines and right click to delete unwanted relationships - check - and go back - field groups - include all table fields - click on generate button - go out

TC SQ03 - Select user group - eg. Payroll

Infoset - Enter name of newly created Infoset

Assign users and Infosets - Assign infosets - put tick on payroll - save and go back

TC PAAH - Expand the nodes and put tick on relevant fields depending upon necessity

Save the query by giving the same name as infoset for easyness..

THANKS

MRUTYUN