topic Re: ABAP-Query in Application Development and Automation Discussions

ABAP-Query

Former Member — Fri, 02 Feb 2007 05:14:23 GMT

Hi Experts,

I am having a doubt in ABAP-Query . Please clear it.

Is it possible to link 2 INFOSETS to a single ABAP-Query.

Thanks in advance.

Regards

Sourabh

Re: ABAP-Query

Former Member — Fri, 02 Feb 2007 05:21:10 GMT

You can assign only one infoset to query; and all the field groups created for that infoset(functional area) are displayed. here you can select any number of field groups for the query. (only the fields from the selected field groups are visible.)

Message was edited by:

M B

Re: ABAP-Query

Bema — Fri, 02 Feb 2007 05:28:36 GMT

HI ,

Yes You can .

Re: ABAP-Query

Former Member — Fri, 02 Feb 2007 05:34:54 GMT

Hi MB,

While creating a Query it prompts me for the INFOST but i am able to associate only a single INFOSET.

Secondly if i want to associate one more INFOSET after the query has been created than what is the procedure.

Regards

Sourabh

Re: ABAP-Query

Bema — Fri, 02 Feb 2007 06:03:39 GMT

Hi,

Sorry, Not 2 infosets.

In the Infoset you can create field groups .

Suppose you are using direct read table method.

In the first field group add one table and in the 2nd fieldgroup , add the next table.

and assign this infoset to the query.

regards,

Beena

Re: ABAP-Query

Former Member — Thu, 08 Feb 2007 21:06:44 GMT

You cannot create a single query based on multiple infosets. Only one is permitted. Why would you need two infosets. You may consider modifying/expanding the one infoset, to suit your needs. One infoset can have joins of several tables. Besides you have the feature of alias tables and added fields with minimal coding.