Extraction Using Infoset (Query)

An InfoSet is a special view of a set of data (logical database, table join, table, sequential file). It serves as the data source for SAP Query. An InfoSet determines which tables or fields of these tables are referenced in an evaluation. InfoSets are usually based on logical databases.

If you are using an InfoSet to extract data, the system first collects all data in the main memory. The data is transferred to the BI system in packages using the Service API interface. The size of the main memory is therefore important with this type of extraction. It is suitable for limited datasets only.

When an InfoSet is created, a data source is selected in an application system. Since a data source can have a large number of fields, fields can be combined into logical units; the functional groups. Functional groups are groups of several fields that form a logical unit within an InfoSet. Any fields that you want to use in an extraction structure have to be assigned to a functional group. In generic data extraction using an InfoSet, all the fields of all functional groups for this InfoSet are available.

The relevance of SAP Query to BI lies in the definition of the extraction structure by selecting fields of a logical database, a table join or other datasets in an InfoSet. This allows you to use generic data extraction for master or transaction data from any InfoSet.

A query is generated for an InfoSet. The query gets the data and transfers it to the generic extractor.

Steps to create a SAP query using InfoSets.

• Creation of User Groups (Defines who is going to create, modify and use the query)
• Creation of InfoSet (Defines the set of data used in the query)
• Creation of the Query (Generating reports using the data)

Step 1: Creation of User Groups (Tcode SQ03)

Generally there is no need for you to carryout this for every query you write. Once created, you can reuse them in queries.

Enter the Group Name you want to create and press Create

Enter a description to the user group and press save

Step 2: Creation of InfoSet (Tcode SQ02)

Enter the Descriptive name to your InfoSet

Select the data source which suits your requirement

Enter the First table to get the data

Let us use VBAK to get the header data of the Sales Document

Enter SD Item level data table (VBAP)

Lets Enter one more table...VBKD to get the Sales Document: Business data.

Now click Check button to check for errors... 

If there is no error,

Click Back button

We can limit the number of fields the Infoset can contain

Select the create empty field groups button and press continue

Now we can see all the field groups which are created and now we can drag and drop the fields from " Data Fields tab "in the left side of the panel to Field Group/ Data Fields in Right side panel

After Generating , Click the "BACK" button

Now we have generated our InfoSet to be used in the query. Now we have to tell the system who can Change/Use this InfoSet

Click on Save button...

Step 3: Creation of InfoSet Query (Tcode SQ01)

Now lets create Datasource based on this query...

Tcode -  RSO2

Lets check for data availability in RSA3

Now lets replicate this to BW

Now data is available in PSA of BW system...

Best SAP training in Kerala

Best SAP training in Kochi

Best SAP training in Ernakulam

SAP FICO, SAP MM, SAP SD, SAP PP, SAP ABAP, SAP Basis, SAP SAC, S4Hana