topic Re: help in range in Application Development and Automation Discussions

help in range

Former Member — Thu, 20 Dec 2007 15:30:30 GMT

hallow

i have table with emp nun(pernr) how i can invert this table

to range table becouse i wont to use delete for other table

like delete itab where pernr is not in pernr_tab.

regards

Re: help in range

Former Member — Thu, 20 Dec 2007 15:39:22 GMT

Hi ,

Two options :

field-symbols : <ls_pernr_tab> like line of pernr_tab .

Loop at pernr_tab assigning <ls_pernr_tab> .

delete itab where pernr ne <ls_pernr_tab>-pernr .

endloop .

data : lr_pernr type range of pernr_d .

data : ls_pernr like line of lr_pernr .

field-symbols : <ls_pernr_tab> like line of pernr_tab .

ls_pernr-sign = 'I' .

ls_pernr-option = 'EQ' .

Loop at pernr_tab assigning <ls_pernr_tab> .

ls_pernr-low = <ls_pernr_tab>-pernr .

endloop .

delete itab where pernr not in lr_pernr .

Both of the ways will do the job but the runtime will the depend on the table's sizes .

Hope it helps .

Best Regards .

Avi Sarmani

Re: help in range

former_member191735 — Thu, 20 Dec 2007 15:40:39 GMT

Declare a range in your program and append this value to the range

RANGES: r_werks FOR marcv-werks.

r_werks-sign = 'I'.

r_werks-option = 'EQ'.

r_werks-low = wa_inventory-werks.

You will get it.

Re: help in range

former_member156446 — Thu, 20 Dec 2007 15:42:13 GMT

loop at itab .

MOVE 'E' TO ra_matkl-sign.

MOVE 'EQ' TO ra_matkl-option.

MOVE itab-pernr TO ra_matkl-low.

APPEND ra_matkl.

MOVE itab-pernr TO ra_matkl-low.

APPEND ra_matkl.

MOVE itab-pernr TO ra_matkl-low.

APPEND ra_matkl.

clear wa_matkl..

endloop.

u cna use this range to delete from other table as u said..

but its not prepered ranges are again like a selection screen table.. so ppl say its not prefered..

hope Rob might have weblog for this as well..

Re: help in range

Former Member — Thu, 20 Dec 2007 15:45:27 GMT

RANGES : pernr LIKE PERNR-pernr.

loop at itab.

pernr-sign = 'I'.

pernr-option = 'EQ'.

pernr-low = itab-pernr.

APPEND pernr.

endloop.

Re: help in range

Former Member — Thu, 20 Dec 2007 15:49:41 GMT

Just a quick one for all ...

For all I now , RANGES statement is obsolete and you should use

DATA : lr_pernr type range of pernr_d .

RANGES defines a header line which is obsolete ...

Re: help in range

Former Member — Thu, 20 Dec 2007 16:18:17 GMT

Hi,

Ranges: r_pernr for tablename-pernr.

then you can use this r_pernr like your select-option.

Reward if useful.

Thanks,

Sreeram.