Skip to Content
0
Former Member
Mar 03, 2010 at 03:18 PM

query problem

29 Views

Hello experts,

I have a little problem with the code below.

I need to sort as you see the result of the query by the field prsdt, but i don't want to sort the table after the query is executed. I want the query to short the result while it is executed.

Any idea?

Thanx!!

 DATA qs     TYPE REF TO cl_crm_bol_dquery_service.
 DATA qr     TYPE REF TO if_bol_entity_col.
CALL METHOD qs->set_query_parameters
    EXPORTING
      it_parameters = lt_parameter.

   qr ?= qs->get_query_result( ).
*  Inicio modificacion JAO ordenar por fecha comienzo descendente el listado 26/02/2010
  CALL METHOD qr->if_bol_bo_col~sort
    EXPORTING
      iv_attr_name  = 'PRSDT'
      iv_sort_order = 'D'.