Create Transaction Code for Infoset Queries Using Area Menu

Link to Article

Setting-up a Role for the InfoSet Query

Use

To be able to create an InfoSet Query, the system administrator must set up a role for the work with the InfoSet Query.

Procedure...

       1.     A role has to be assigned specifically to a single SAP Query user      

              group. This is because the InfoSet Query is derived from the SAP 

              Query.

a. Call up the Role Maintenance (RSQ10). You get to a table containing the roles that are relevant for working with the InfoSet Query.

b. Choose the role you want, and use the Assign User Group function (second column in the table) to assign a user group to the role, or to remove an existing assignment. 

When you are assigning user groups, a dialog box appears asking you if you want to create a new user group, or use an existing one. Use the input help to choose from the available user groups. It is not possible to assign a user group to more than one role. 

Creating InfoSet Queries

Use

The InfoSet Query is designed for reporting on data stored in flat tables. It is particularly useful for reporting on joins for master data and joins for ODS objects. 

Prerequisites

You must take the following steps before you can create Infoset queries:

• SetHYPERLINK "http://help.sap.com/saphelp_nw04/helpdata/en/86/0bf9392486ce1ae10000000a114084/content.htm" up Roles for the HYPERLINK "http://help.sap.com/saphelp_nw04/helpdata/en/86/0bf9392486ce1ae10000000a114084/content.htm"InfoSetHYPERLINK "http://help.sap.com/saphelp_nw04/helpdata/en/86/0bf9392486ce1ae10000000a114084/content.htm" Query

• Process Classic HYPERLINK "http://help.sap.com/saphelp_nw04/helpdata/en/92/43ec39d0383f09e10000000a11402f/content.htm"InfoSetsHYPERLINK "http://help.sap.com/saphelp_nw04/helpdata/en/92/43ec39d0383f09e10000000a11402f/content.htm" and Assign Roles

Procedure

How to Create Infoset Query (SAP 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