topic Sorting before get logical database in Application Development and Automation Discussions

Sorting before get logical database

Former Member — Tue, 17 Mar 2009 10:41:16 GMT

Hi,

I would like to know any way to apply sorting before get logical database?

for e.g.

GET regup.

PERFORM extract.

IF reguh-zbukr NE regup-bukrs.

tab_uebergreifend-zbukr = reguh-zbukr.

tab_uebergreifend-vblnr = reguh-vblnr.

COLLECT tab_uebergreifend.

ENDIF.

END-OF-SELECTION.

I need to sort regup before GET regup which before it trigger for each line.

Thanks.

Re: Sorting before get logical database

Former Member — Wed, 18 Mar 2009 06:50:44 GMT

Hi,

Instead of going for a sort before GET statement, you can move the required fields into an internal table first and sort that table and use it for your processing.

A small eg:

GET bkpf.

MOVE:bkpf-bukrs TO tb_bkpf-bukrs,

bkpf-budat TO tb_bkpf-budat,

bkpf-belnr TO tb_bkpf-belnr.

APPEND tb_bkpf.

CLEAR tb_bkpf.

Please revert back for any further queries.

Regards,

Chandra.