topic Re: Sortinf problem in ztable in Application Development and Automation Discussions

Sortinf problem in ztable

Former Member — Wed, 17 Dec 2008 14:00:35 GMT

Moved to correct forum by moderator. Duplicate deleted - don't post the same subject in more than one forum

Hi All,

I created one ztable with three primery keys in order

ZRECNO

ZSUBREC

ZUKEY

All have same domain sytabix.

Data is sorting on ZUKEY FIRST THEN ZSUBRC But not sort on ZRECNO.

I want to sort data in above order means zrecno zsubrec and zukey..

Please sort me out from this problem...

Thanks,

Edited by: Matt on Dec 17, 2008 3:59 PM

Former Member — Wed, 17 Dec 2008 14:10:32 GMT

SY-TABIX is an integer number, so it's not really a good type of data to be used for a key field.

If you need to have a numeric key field u should use a type N ( so a char number)

Probably if u change the domain u'll solve the problem on sorting

Max

Former Member — Wed, 17 Dec 2008 14:12:32 GMT

Hi,

u have to use order by in your select query.

for example:

DATA: wa_sflight TYPE sflight.

SELECT * FROM sflight INTO wa_sflight

WHERE carrid = 'LH' AND

fldate BETWEEN '20010227' AND '20010305'

ORDER BY planetype ASCENDING seatsocc DESCENDING.

WRITE: / wa_sflight-planetype, wa_sflight-seatsocc,

wa_sflight-connid, wa_sflight-fldate.

ENDSELECT.

Regards,

Arun.

Former Member — Wed, 17 Dec 2008 14:14:16 GMT

Didn't you ask this question 10 minutes ago?

matt — Wed, 17 Dec 2008 14:59:29 GMT

Duplicate has been deleted. This one moved to correct forum.

Former Member — Wed, 17 Dec 2008 14:59:52 GMT

removed