RFC Call Sort Ability

[Former Member]

Hi Guru's,

Wondering is there an easy way to do a sort on results returned from and RFC_READ_TABLE call. Basically i the call returns three items and i am wondering if there is a way i can get SAP to return them sorted by column similar to if i was to use the SQL Syntax ORDER BY D1 DESC;

Is there a way i can do this easily in the call , the options parameter does no allow me to use the sql function order by ?

Thanks,

Emmett

[jcgood25 · Accepted solution]

If the RFC doesn't provide you with the necessary 'order by' functionality then you have to do it inside BLS. Assuming you are already building up an Illum Doc XML then just apply the GenericSortFilter action to the results.

[Former Member · Accepted solution]

You can't sort with RFC_READ_TABLE, but i think it does sort using the first column by default. Your best bet is to do what Jeremy suggested and build your xml doc from the output and sort it there.

[Former Member]

Thanks Gents,

Didn't use this but managed to resolve my problem in another manner.

Appreciate the input.

Emmett

[former_member185881]

Hello Emmett

May I know whcih method you used as I am also facing the same issue.

Thanks

Dheeraj Kumar