topic Re: Regarding ABAP query layout changes in Application Development and Automation Discussions

Regarding ABAP query layout changes

Former Member — Tue, 09 Oct 2007 01:44:02 GMT

In 46C system, we have addon transaction ZXX created thru ABAP query displaying in ALV report

layout fields in order A,B,C,D. But after upgrade to ECC5.0 we found the layout is changed to fields D,B,C,A.

why its changed? Is it Patch problem or its SAP problem.

However after upgrade we could manualy drag and drop the fields as per the 46C existing report layout

it works fine.

But we would like to know the reason why its happenning.?

Could somebody give me suggestion.

Regards

Ambichan

Re: Regarding ABAP query layout changes

Former Member — Tue, 09 Oct 2007 01:47:52 GMT

Hi Ambichan,

Is the query you are talking is a standard query or the custom one. There may be chance that only you have Z transaction but the underneath query is standard SAP query.

Regards,

Atish

Re: Regarding ABAP query layout changes

Former Member — Tue, 09 Oct 2007 01:59:01 GMT

hi athish,

Could you explain me little brief.

what is standard query or custom query you are talking about. how can i identify those program name in SE38.

regards

Ambichan

Re: Regarding ABAP query layout changes

Former Member — Tue, 09 Oct 2007 02:05:17 GMT

Hi Ambichan,

Just go to SE93 and look at your transaction ZXX..

Now here you will see the name of the query. If it is not Y or Z query then it is standard SAP query.

To get more idea of query look at transaction SQ01, SQ02, SQ03.

Regards,

Atish

Re: Regarding ABAP query layout changes

Former Member — Tue, 09 Oct 2007 02:39:49 GMT

hi Atish,

Thanks for your reply.

i found two generated program for the query.

1) one of the program looks like this.

AQCSZCK=========QUE_ABAP2_01==

2) The other program looks like this

AQCSZCK=========ZMDQRY2=======

Can i consider 1) is Standard and 2) is Custom query. Please clarify.

if so, you mean to say customer query might have this layout problem. pls clarify how to solve this problem.

regards

Ambichna

Re: Regarding ABAP query layout changes

Former Member — Tue, 09 Oct 2007 02:44:02 GMT

Hi Ambichan,

Yes 1 is standard 2 is custom.

You need to solve the layot problem using SQ01.

Regards,

Atish

Re: Regarding ABAP query layout changes

Former Member — Tue, 09 Oct 2007 03:10:10 GMT

Thanks athish, so you mean to say only custom query will have this kind of problem. and this can be solved using SQ01 modification, generate it and use it.

regards

ambichan

Re: Regarding ABAP query layout changes

Former Member — Tue, 09 Oct 2007 03:12:48 GMT

yes. Just explore SQ01.

Regards,

Atish

Re: Regarding ABAP query layout changes

Former Member — Tue, 09 Oct 2007 03:16:39 GMT

Hi Ambikumar,

The ALV output layout is dependent on user settings.

THe order of layout fields is changed bcz user has saved the new layout.

In the output, check the ALV toolbar for CHANGE LAYOUT button. Click on it & check if anyone has saved any new layout. Delete the layout & you would alwyz get the fields in the same order as specified in the query.

No need to modify the query using SQ01/SQ02.

Simply execute the query & click button CHANGE LAYOUT.

Best regards,

Prashant