Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Bringing in Additional Fields into SAP Query

Former Member

‎2009 Jul 27 3:05 AM

0 Likes
3,160

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.

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.

Reply
5 REPLIES 5
Read only

Former Member

‎2009 Jul 27 3:18 AM

0 Likes
1,802

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

Read only

Former Member

‎2009 Jul 27 9:12 AM

0 Likes
1,802

This message was moderated.

Read only

Former Member

‎2009 Jul 27 1:54 PM

0 Likes
1,802

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.

Read only

Former Member
In response to Former Member

‎2009 Jul 27 2:01 PM

0 Likes
1,802

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

Read only

Former Member

‎2009 Jul 27 2:28 PM

0 Likes
1,802

Thanks guys. I'm all set now.