Change Query

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Suganya,

Thanks for your feed back.

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

Regards,

Sibin