Creation Of Info Sets in SAP CRM

Info Sets in SAP CRM are used to access business partner master data. SAP provides various Info Sets in the standard delivery, which can be used for marketing purposes.

To create InfoSets, go to SAP Menu  Architecture and Technology ABAP Workbench Utilities SAP Query InfoSets

Or

Use transaction code SQ02 to create an info set.

Click on “Create” and enter the name of the Info Set.

Select the data source as one of the following:

• Direct Read Of Table
• Table Join Using Basis Table
• Logical Database
• Data Retrieval Program

    

"Table Join Using Basis Table" is chosen for the info set created in this example.

Select the Basis table name from the list of tables available. Choose the table name as per the requirement. E.g.:- “BUT000"

Click on "Insert Table" icon to insert the table which is to be joined with BUT000 (E.g:- BUT100).

 Add the table "BUT100".

"BUT000" and "BUT100" are joined with the key field "Business Partner ID".

 

Choose all the table fields or include only key fields.  Field groups can be created to group the fields together into a meaningful unit.

Click on "Generate" icon to generate the Info Set.

Select the package in which the Info Set is to be included.

Once saved, the Info Set gets Generated.

Once the Info Set is successfully generated, it would be visible on the main screen (Sq02).