Ad hoc Query - Add table to an existing Infoset

[Former Member]

Hi,

I have an Infoset created based on PNP database table. Now I wanted to add certain fields from a table (not from logical database table) to same Infoset. Can I add the table to the existing Infoset? If yes could please guide me how to do it.

From one thread I found out using Extras tab, in change Infoset screen we can add table. But not able to proceed further.

I will be grateful for your help.

Thank you.

GRM

[Former Member · Accepted solution]

Hi,

Create the Fields in additional Field Options.

right click on the Field ->Field Code.do the Coding here for populating the Field.

Manoj.

[Former Member · Accepted solution]

Hi Manoj,

Thanks for your reply. Could you please tell me the step by step procedure?

Regards,

GRM

[Former Member · Accepted solution]

IN SQ02,click on Extras tab.

Add your Fields you want to populate .Add the logic for poulating this fields in 'Code' tab.

Manoj.

[Former Member · Accepted solution]

Hi Manoj.

Thanks for your guidance.

I have created an additional filed for an existing Infoset and a code is written to fetch the data from a configuration table.

But when executing the Infoset in SQ01 Transaction Code, check box is not appearing under selection filed for the new filed which I created. But it is appearing for out put field.

If Switch is on for object selection, check box is appearing under selection filed, but if it is off check box is not appearing, where as it is appearing for other fields.

Could you help me to how to resolve this issue?

Thank you.

Regards,

GRM

[Former Member]

Hi Experts,

Waiting for your suggestions.

Kindly reply.

Regards,

GRM

[Former Member]

Hi,

If i understand your question correctly, you need:

1. Open your infoset in edit mode

2. Go to data field section (on the left part of the screen) and klick on the "additional fields" icon for example in 0001 infotype with the right button (you need to add new table in one of the infotype field group as you need to have some key to access a table you need to attach to infoset, for example: where pernr = 0001-pernr etc).

3. click "create" and chose "aditional table" and specify the name of a table.

4. After that you will be asked to specify keys.

Hope that it was helpful!

[shafiq_rehman3]

what you want to do is not possible, you cannot add tables and LDB in your infoset.

Either you can base your infoset on an infoset

OR

You can base it on a number of tables.

Not Both.

[Former Member]

Hi GRM,

As u have mentioned that u have used LDB, PNP. Now ur query is that u want to add a table into the query.

Firstly check in which Infotype that Table and field is being called.

Then, go to T.Code - SQ02

Select ur query that u have used in that LDB - PNP. Click change.

Then from the Menu bar, Select EDIT & then CHANGE INFO-TYPE SELECTION.

After the above activity, a selection screen will appear. From that Selection screen, select the appropriate Infotype then add it and it'll bring all related Tables used in that Infotype.

Accordingly u may select and deselect as per ur requirement. Generate the Infoset Query once again after coming out of the screen.

Hope this helps,

ARNAV...

[Former Member]

Hi Arnav,

Thanks for your detail explanation. But when I am going to CHANGE INFO-TYPE SELECTION screen and selecting appropriate Infotype it is showing me all the fields for that infotype not table. I want to add a table in the existing Infoset so that I can select a particular filed from that table and add in Infoset.

Kindly help.

Regards,

GRM