Regarding ABAP query layout changes

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Ambichan,

Yes 1 is standard 2 is custom.

You need to solve the layot problem using SQ01.

Regards,

Atish

[Former Member]

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

[Former Member]

yes. Just explore SQ01.

Regards,

Atish

[former_member223537]

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