Sortinf problem in ztable

[Former Member]

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]

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]

Hi

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]

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]

Didn't you ask this question 10 minutes ago?

[matt]

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

[Former Member]

removed