Hi all,
I am working on a report in that report i have 6 charactics and 4 key figure.
charactics : material number
demand type,vendor,date.
here requirment is that before displaying data on the BEX client wants to sort the data on the basic of following logic first material number then demand type then date and then vendor . I can do this on BEX but problem is Demand type
Demand type variable contaning following values PO,PR,PL so sorting can not done at BEX leven on character type basic .So i have to write a routine where i have added one more field zsort and assigned the value 1 for PO ,2 for PR and 3 for PL . I am getting all assigned values for Zsort at BEX but as per client's requirement I dun have to show the variable at BEx but shorting has to be done on the basis of this variable only. I wont take this variable neither in dimension nor in keyfigures and will write a routine by taking this variable in my code. Folowing code I had written in R/3 FM to write in routine:
Sort IT by matnr zsort date.
I want to write same code in routine so where and what code I will have to write? Main problem is we don't have any internal table available here so inplace of IT(internal table) what I will have to write that is the main problem for me. Second where the code would be written in start routine or field level routine??
Thanks
Ankit modi