Infoset (SQ02) based on Program

[alain_cloet]

Hi,

Has anyone ever used a program to generate an infoset ? I need to make a query which seems too complex to use the default joins, so I need to generate a view first, or an infoset made by a program (which I would prefer).

It seems difficult to find info on this, even in the BC407-course I didn't get the info, but I wasn't able to ask the questions either as I didn't have any clue on what infosets were before I took it, so I was hoping anyone out here can help me a little now I had the time to think this over :)...

I have the following questions before I can get started:

• Which type of programm has to be selected ?

• Can any structure be used ?

• Has anyone a sample code of such a program ? (Maybe very simple, just to have a start ; to know if there is anything special needed in the SELECT-clause)

Thanks In advance,

Alain

[Former Member]

Hi Alain Cloet,

New versions of Infoset query provides facility for the user to write complex data manipulation logic in the Infoset itself. You can do as much as you normally do in an SE38 program.

Two options are available for the data source in Infoset.

1. Use Integrated program

2. Use external program.

Out of these two , I will explain the former ( Integrated program ) .

As a first step, you need to create a structure (through SE11), which will consists of all the fields that you would want in your output. Or in other words , the fields in your final internal table which you wish to display will be the fields of the structure.

So , once when you create the Infoset, and in the global properties , put the structure and select "Integrated program".

You will find a seperate tab "Data Integrated program" in the application bar.

Selecting it will open you the ABAP editor.

This is similar to the SE38 editor, and it would be split into sections automatically by the system.

FIrst would be the data decleration , then the area where you define your selection screen, then your area where you put your code.

An internal table called IT_DATA will be created by the system with the same structure as that of the structure which you created and mentioned initially while creating the Infoset.

In short, this IT_DATA is your final internal table.

Your main aim should be to fill this internal table with the data you want to display.

Rest ...is taken care by Infoset Query.

Hope this gives you started.

Go ahead. Its simple.

Approach for any queries.

Regards,

Subin John

[Former Member]

Hi subin john  Hope you are doing well. Want to develop an infoset against this structure RMPS_DOMEA_CM sap CRM but the data selection program is not working. please assist if you can

[Former Member]

Hi Subin John,

Can write a full length program as we do in SE38?? I want to access this infoset  with crytal reports.