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

Adding a field in already existing query layout

Former Member

‎2008 Jun 04 8:35 AM

0 Likes
2,249

Hi All,

I have a requirement where I have to add couple of fields in an already existing query layout.

Through SQ01 and layout painter I have added the fields to the layout. When I test from query painter it displays the newly added fields. But when I execute the transaction that is designated to run the query its not displaying those fields.

What am I missing here?

Thanks in advance.

Thanks,

Arun

Hi All,

I have a requirement where I have to add couple of fields in an already existing query layout.

Through SQ01 and layout painter I have added the fields to the layout. When I test from query painter it displays the newly added fields. But when I execute the transaction that is designated to run the query its not displaying those fields.

What am I missing here?

Thanks in advance.

Thanks,

Arun

Reply
5 REPLIES 5
Read only

GauthamV
Active Contributor

‎2008 Jun 04 8:58 AM

0 Likes
1,235

hi,

In queries program will be generated internally so any changes done will change the program also.

so if u hav done changes to query ,again use tht program name and create a transaction.

Read only

kiran_k8
Active Contributor

‎2008 Jun 04 9:01 AM

0 Likes
1,235

Arun,

As you have done some changes to the query,the internal report generator will generate a new program correspponding to the Query which should be attached to the T-code.

Currently the t-code might be having the earlier program name ie the program generated by the query before changes were made hence it is not displaying.

Just check the program name of the Query and the program name attached to the tcode.

K.Kiran.

Read only

Former Member
In response to kiran_k8

‎2008 Jun 04 9:21 AM

0 Likes
1,235

Hi Kiran, Guatam,

The transaction calls a standard SAP program SAP_QUERY_CALL and passes the user group and query as input.

Now how to change the program name here?.

Thanks,

Arun

Read only

Former Member
In response to kiran_k8

‎2008 Jun 04 9:28 AM

0 Likes
1,235

Hi,

One problem I found is when I tried to generate the program.

There is a option in query->more functions->generate program.

Do i need to do this to generate the program. But in my case it is disabled.

Can you please help me on this?

Read only

kiran_k8
Active Contributor
In response to kiran_k8

‎2008 Jun 04 9:40 AM

0 Likes
1,235

Arun,

As you have already done the changes and were able to get the required output just check select the Query in SQ01 and then go to Quick view>>Additional functions>>Display report name.In a Pop up you will be able to see the report name,just check this report name and the report name attached to the tcode in se93.

K.Kiran.