topic Re: Change Query in Application Development and Automation Discussions

Change Query

Former Member — Wed, 22 Apr 2015 06:04:06 GMT

Hi Experts,

We want to modify an existing ABAP query developed using SQ01 transaction code. We want to add additional fields with certain calculations. We have made changes to the query program using SE38 but the column names are getting duplicated in output. Due to this reason values are getting shifted 1 place left to actual columns. We don't want to regenerate the query as already few conditions are added in the program. How to remove duplicate column names?

Regards,

Sibin

Re: Change Query

Former Member — Thu, 23 Apr 2015 08:12:12 GMT

Can we set Page Header and Page Footer for ABAP query programs?

Re: Change Query

Former Member — Thu, 23 Apr 2015 08:58:08 GMT

Hi,

You can restrict it by selecting those fields and choose No currency fields before or after and apply.

1. Goto SQ01, provide your query name and select "Infoset Query".

2. Now choose the currency/quantity fields on the lower bottom of window.

3. Right click on the field and traverse to Unit->Do not Output.

Hope this helps!

Regards

Suganya

Re: Change Query

Former Member — Thu, 23 Apr 2015 09:06:06 GMT

Hi Suganya,

Thanks for your feed back.

Can we set Page Header and Page Footer for ABAP query programs?

Regards,

Sibin