Internal table sort

[Former Member]

Dear All,

I am facing sort problem in internal table . Table type is standard.

When program executed in fore-ground sort happened properly where same program while executed in background sorting is not happening which I observed in spool.

Internal table has around 80,000 records with 6 column.

Below is the code

SORT int_s711_a BY gross_p DESCENDING umsmng DESCENDING.

Both gross_p & umsmng are of CURR field 19 length 2 decimal

Thanks for your help.

Joseph

[Former Member]

Dear All,

I am facing sort problem in internal table . Table type is standard.

When program executed in fore-ground sort happened properly where same program while executed in background sorting is not happening which I observed in spool.

Internal table has around 80,000 records with 6 column.

Below is the code

SORT int_s711_a BY gross_p DESCENDING umsmng DESCENDING.

Both gross_p & umsmng are of CURR field 19 length 2 decimal

Thanks for your help.

Joseph

[Former Member]

Use.....SORT int_s711_a BY gross_p umsmng DESCENDING

Also, while sorting currency fields sometimes it happens that sort might not be proper. But it will work...If possible try to use some other key field also.