Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Filtering Select-Options criteria?

Former Member
0 Likes
449

Hi Experts,

I populated the itab.

From this itab, I need to delete the KUNNR records, which wuld not satisfy the S_KUNNR (select-options) range. So, the follwoing codes is not working!

DELETE ITAB WHERE KUNNR LT S_KUNNR-LOW AND KUNNR GT S_KUNNR-HIGH.

DELETE ITAB WHERE KUNNR NE S_KUNNR.

What is the correct code?

ThanQ.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
423

Hi,

Try this..

DELETE ITAB WHERE NOT KUNNR IN S_KUNNR[].

Thanks,

Naren

Hi Experts,

I populated the itab.

From this itab, I need to delete the KUNNR records, which wuld not satisfy the S_KUNNR (select-options) range. So, the follwoing codes is not working!

DELETE ITAB WHERE KUNNR LT S_KUNNR-LOW AND KUNNR GT S_KUNNR-HIGH.

DELETE ITAB WHERE KUNNR NE S_KUNNR.

What is the correct code?

ThanQ.

2 REPLIES 2
Read only

Former Member
0 Likes
424

Hi,

Try this..

DELETE ITAB WHERE NOT KUNNR IN S_KUNNR[].

Thanks,

Naren

Read only

0 Likes
423

ThanQ Naren.