What is SAP InfoSet?

Posted on by Mary Andersen

What is SAP InfoSet?

InfoSets are InfoProviders that allow you to analyze data in several InfoProviders by using combinations of master data-bearing characteristics, InfoCubes, and DataStore objects. The system uses joins to bring together information from the tables of the relevant InfoProviders.

How do I run InfoSet in SAP?

As soon as a suitable InfoSet is available for your user group, you can generate a query for it:

  1. Call transaction SQ01.
  2. To execute an existing query, select it from the table, and choose Execute (F8).
  3. To create a new query, enter a name for it, and choose the Create button.

How do I create an InfoSet in SAP query?

How to Create Infoset?

  1. Go to Transaction Code RSA1.
  2. Browse to the tab “InfoProvider”
  3. Enter the Technical Name.
  4. The Change Info Set screen appears.
  5. Select the insert Info provider button shown below, to choose the infoprovider with which data is to be joined.
  6. Enter the name of the DSO.

How do I create an InfoSet in SAP HR?

To set up an InfoSet for the HR application, proceed as follows:

  1. On the initial screen for maintaining InfoSets, enter a name for the InfoSet and choose Create.
  2. On the next screen, enter a name for the InfoSet and select one of the HR logical databases in accordance with your reporting requirements.
  3. Choose .

How do I open InfoSet in SAP ABAP?

Call transaction SQ01. The SAP Query initial screen appears. This screen shows a table of all queries that have been created and stored for your user group. To create an InfoSet query, choose the InfoSet Query button on this screen.

How do I change Infoset description in SAP?

1 Answer

  1. Go to Transaction SQ02.
  2. Enter your Infoset.
  3. Hit the “Change” button.
  4. Double-click on the field you want to change.
  5. In the Field label box change the Long text and the Header.
  6. Hit the “Copy” button.
  7. Save and Generate the Infoset.

How do I create an infoset in SAP HCM?

On the initial screen for maintaining InfoSets, enter a name for the InfoSet and choose Create. On the next screen, enter a name for the InfoSet and select one of the HR logical databases in accordance with your reporting requirements. Customer infotypes can be created on all HR logical databases.

How do I assign a user to a group in Infoset?

Procedure

  1. You are in the User Group: Initial Screen.
  2. Choose Assign Users and InfoSets.
  3. Enter the names of those users that are to belong to this user group.
  4. To be able to change queries, the user requires authorization for the authorization object S_QUERY with the value Change .
  5. Choose Assign InfoSets.

How do I add a field in InfoSet?

  1. Click on Create icon in the Extras Tab.
  2. In the pop-up, select Additional Field option and give the Additional field name as say MNTHR.
  3. Continue and define the details and Continue .
  4. Also in Extras tab on the right.
  5. Note:
  6. Then,
  7. We see this (Short Name, Local field indicator columns appear)

How do I change InfoSet in SAP ABAP?

Procedure

  1. Choose Create New Query. The Create New Query – InfoSet Selection dialog box appears.
  2. Select the user group that has access to the required InfoSet. The InfoSets area lists all of the InfoSets that can be accessed by the selected user group.
  3. Select the InfoSet that you want to use for the query.
  4. Choose .

How do I edit Infoset description?

How do I change the Infoset in sq01?

From menu Edit–>Other user group, choose the user grp where u have assigned the infoset no give the name of ur query and press create button, it will display all the infosets those are assigned with that user group. Now select ur infoset and start developing the query.