Tutorial SAP InfoSet: qué es, cómo crearlo y unir tablas
By s4pcademy
Infoset
Infoset is a special kind of Infoprovider which does not store data physically. In other words, Infoset are InfoProviders that logically join data and provide this data for BI queries. Infoset collects data from the tables of InfoProviders used to build it. Infoset describes data sources that are defined as a rule of join on Datastore objects, Info-objects or standard InfoCubes.
When to Use Infosets?
- To join required data from basic InfoProviders
- To allow BEx Reporting on a DataStore object without turning the BEx Reporting indicator on
- To evaluate time dependencies
- To create self joins and left outer joins
What are InfoSet Joins?
DSO (Data Store Objects) and/or InfoObjects (characteristics with master data) are connected in the InfoSet using join conditions. The joined data from the InfoSets are available for access from Business Explorer Queries. InfoSets allows you to report on several Info-Providers (Infocubes, Data Store objects, master data InfoObjects), but they contain no data.
Joins Categories:
- Inner Join
- Left Outer Join
- Temporal Join
- Self Join
How to Create Infoset?
- Go to Transaction Code RSA1
- Browse to the tab “InfoProvider”
- Right-Click on the infoarea and choose the option “Create Infoset” from the context menu.
When the Info Set Builder is called for the first time, the below two display mode options as Network (Dataflow Control) Tree (Tree Control). The network display is clearer. The tree display can be read by the Screen Reader and is suitable for visually-impaired users. You can change this setting at any time using the menu path Settings -> Display.
Enter the Technical Name Description. In the Start with Info Provider section, you determine which Info Provider you want to use to start defining the Info Set. Select one of the object types that the system offers you: Data Store object, Info Object, Standard Info Cube. Choose an object. If you want to choose an Info Object, it must be a characteristic with master data. The system provides you with the corresponding input help. Choose Continue button.
The Change Info Set screen appears. Select the insert Info provider button shown below, to choose the infoprovider with which data is to be joined. Enter the name of the DSO. Click Continue button. The below screen appears with the 2 info providers selected. Activate the Info set by clicking on the activate button.
