topic Re: Sort Statement Error in Application Development and Automation Discussions

Sort Statement Error

Former Member — Mon, 29 Sep 2008 14:06:55 GMT

Friends,

I have declared an internal table declared as below:

data:zitab type table of zsalesitem1a.

The ztable 'zsalesitem1a' has a primary key, zecrno.

After populating the internal table zitab with values from the ztable, i am sorting the zitab using :

sort zitab descending by zecrno.

But the sort statement is sorting the zitab using line number, not by zecrno values.

Please let me know what is missing.

Thanks and Regards.

Re: Sort Statement Error

Former Member — Mon, 29 Sep 2008 14:09:28 GMT

Did you try:


SORT zitab BY zecrno DESCENDING.

Re: Sort Statement Error

Former Member — Mon, 29 Sep 2008 14:10:24 GMT

sort zitab by zecrno descending .

with luck,

Pritam.

Re: Sort Statement Error

Former Member — Mon, 29 Sep 2008 14:41:52 GMT

Hi,

There is no change with this version of the sort statement.

Thanks and Regards.

Re: Sort Statement Error

Former Member — Mon, 29 Sep 2008 14:42:01 GMT

Hi,

There is no change with this version of the sort statement.

Thanks and Regards.

Re: Sort Statement Error

BH2408 — Mon, 29 Sep 2008 15:05:03 GMT

1.First delete the Duplicates.

2.SORT itab DESCENDING BY field-1 field-2 asceding .

try this...

Re: Sort Statement Error

Former Member — Mon, 29 Sep 2008 15:11:12 GMT

That should have worked. Can you post your code?

Re: Sort Statement Error

Former Member — Mon, 29 Sep 2008 15:29:58 GMT

Hi,

Here is the code:

data:zstruct type zsalesitem1b.

data:zitab type table of zsalesitem1b.

select zecrno from zsalesitem1b into zstruct.

append zstruct to zitab.

endselect.

describe table zitab.

sort zitab by zecrno descending.

Thanks and Regards.

Re: Sort Statement Error

Former Member — Mon, 29 Sep 2008 15:36:06 GMT

What does zsalesitem1b look like?

Avoid SELECT ENDSELECT.

Instead use:


select zecrno from zsalesitem1b into corresponding fields of table zitab.

Re: Sort Statement Error

Former Member — Tue, 30 Sep 2008 05:03:11 GMT

Hello

Try:


data:zstruct type zsalesitem1b.
data:zitab type table of zsalesitem1b.

select zecrno from zsalesitem1b into zstruct-zecrno.
append zstruct to zitab.
endselect.
describe table zitab.

sort zitab by zecrno descending.

Re: Sort Statement Error

Former Member — Tue, 30 Sep 2008 05:54:03 GMT

Hi,

The SORT statement can be like:

sort zitab by zecrno descending.

sort zitab descending by zecrno .

There is no problem.

But check the below ones:

1.You might have filled line numbers instead of zecrno values.If so Check the content and fill accordingly.

2.The fields order might be swapped.?If so Check the strture and content.

3.You might have declared the Key fields and not followed the rules as there are different kinds of internal tables like SORTED,HASHED,STANDARD.If so folllow the order.

Regards,

Rama Chary.Pammi

Re: Sort Statement Error

Former Member — Tue, 30 Sep 2008 09:28:57 GMT

Hi,

Problem seems to be with the structure definition of zsalesitem1a and zsalesitem1b. Compare the two structures and make sure that zrecno from zsalesitem1a actually gets mapped to the same field in zsalesitem1b. In debug check that the right values are getting populated into your internal table. Once that happens, sorting should work just fine.

Re: Sort Statement Error

Former Member — Tue, 30 Sep 2008 09:34:03 GMT

Hi,

What is the data type of field zecrno ?

regards,

Advait.

Re: Sort Statement Error

Former Member — Wed, 01 Oct 2008 04:45:55 GMT

hi,

write in the below way.

sort <internal table> by <field> descending.

Regards,

venkat

Re: Sort Statement Error

Former Member — Wed, 01 Oct 2008 04:47:54 GMT

Hi,

can you paste your code..then we will look at once.

Regards,

venkat

Re: Sort Statement Error

Former Member — Wed, 01 Oct 2008 09:02:19 GMT

Hi,

Pls try this

select zecrno from zsalesitem1b into corresponding fields of zstruct.

append zstruct to zitab.

endselect.

describe table zitab.

sort zitab descending by zecrno .

Regards

Re: Sort Statement Error

Former Member — Fri, 03 Oct 2008 16:38:05 GMT

Thanks to all for your help.