topic Re: Bringing in Additional Fields into SAP Query in Application Development and Automation Discussions

Bringing in Additional Fields into SAP Query

Former Member — Mon, 27 Jul 2009 02:05:33 GMT

Hi,

I'm new to SAP Query. I had to modify an existing report to bring in an additional field from one of the tables of the query. When i look at the tables in query, i don't even see the field i would like to add under the table. I guess it needs to be first bring into query and later i can add. Can someone help me how to do this?

Thanks in Advance.

Re: Bringing in Additional Fields into SAP Query

Former Member — Mon, 27 Jul 2009 02:18:16 GMT

Hello,

You have to select additional fields from existing tables in InfoSet (SQ02) and add them into existing field groups. If the fields are from different table, add the table in Join screen. Then these new fields will be available in SQ01 for you to modify the Query.

Thanks,

Venu

Re: Bringing in Additional Fields into SAP Query

Former Member — Mon, 27 Jul 2009 08:12:28 GMT

This message was moderated.

Re: Bringing in Additional Fields into SAP Query

Former Member — Mon, 27 Jul 2009 12:54:34 GMT

Venu,

I tried doing in SQ02, but unfortunately not been able to add the new field. I saw the options for adding additional fields from logical DB etc., but i need to bring in an additional field from the physical DB table which is part of the query. Could you please tell me the menu options.

Re: Bringing in Additional Fields into SAP Query

Former Member — Mon, 27 Jul 2009 13:01:55 GMT

HI,

IN SQ02, IF table is already in JOIN, just click on the PLUS sign to expand the strcture.

All the field showing Plus sign in the strcture are selected in your query and with MINUS sing are no selected.

So you have to just click on the MINUS sign for the field you want to use through table field.

Generate the query and execute thriugh SQ01.

If you want to add some other field which is not a part of JOIN,

then click on EXTRAS Button shown in the MENU option.

Click on Create button and system will ask abt the additional field.

Regds,

Anil

Re: Bringing in Additional Fields into SAP Query

Former Member — Mon, 27 Jul 2009 13:28:55 GMT

Thanks guys. I'm all set now.