on 03-30-2009 9:54 PM
Hi experts,
I have web layouts with ALV grid design, containing key figures in columns. Normally data set are sorted ascendingly by the first characteristics in lead columns.
The requirement: data sets in the layout should be sorted descendingly by the values of the first key figure.
It works with an additional characteristics in the first column, containing values e.g. "1000000 - key figure value". But this doesn't look nice.
Has anyone a better idea?
Thanks and regards,
Wolfgang
There is no feature provided in BPS to sort the data in the layout based on keyfigure value.
You can try to write some function exit and sort the data in planning buffer. To trigger that function exit you can provide a button to the user in web interface.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks a lot for your hints!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Also you can add some java-script to your BSP Application for sorting or ranking any rows or columns you want and provide on-demand functionality in your web application just like Deepti said...
Please consider something like this:
// ** SORT THE COLUMN ITEMS
if (Orden=="a")
colArray.sort();
else
colArray.reverse();
// ** SORT ROWS IN TABLE
for (i=0; i< colArray.length-1; i++)
{
tableToSort.moveRow(colArray<i>[1],i+1);
if ( colArray<i>[1] != (i+1))
for (j=i1; j<colArray.length-1;j+)
if ( (colArray[j][1]>=(i+1)) && (colArray[j][1]<colArray<i>[1]) )
if ((colArray[j][1]+1)<=colArray.length)
colArray[j][1]++;
}
Hope this helps...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gerardo,
thank you very much for this proposal. At present I hesitate to modify the system-generated BSP pages. The preferred solution is by sorting with a planning function (FOX or ABAP coding). But currently I miss the idea to write sorted lines back to the planning buffer.
Regards, Wolfgang
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.