topic SORT statement in Application Development and Automation Discussions

SORT statement

Former Member — Wed, 07 Feb 2007 23:44:38 GMT

Hi All,

I have a requirement to sort a internal table like below. Only the last 2 fields as descending. But when I check in debug it is not working. What is wrong in this syntax.

SORT i_conterms BY oicontnr posnr vkorg kunag kunwe werks matnr

ascending season_effdate season_expdate descending.

Thanks in advance for all your help.

Regards,

Chandra Kumar

Re: SORT statement

Former Member — Wed, 07 Feb 2007 23:54:45 GMT

Hi,

Try changing it like this:

SORT i_conterms BY oicontnr posnr vkorg kunag kunwe werks matnr

ascending

season_effdate descending

season_expdate descending.

regards

Subramanian

Re: SORT statement

Former Member — Thu, 08 Feb 2007 00:08:16 GMT

You can also try descending fields frst then ascending fields

SORT i_conterms BY season_effdate season_expdate descending

oicontnr posnr vkorg kunag kunwe werks matnr

ascending.

Please mark Useful Answers

Re: SORT statement

gopi_narendra — Thu, 08 Feb 2007 00:22:37 GMT

If not you can just give by this also.

sort I_CONTERMS by season_effdate season_expdate descending.

Regards

Gopi