Application Development 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Please guide me how this Delete Statement is working

Former Member

‎05-18-2013 7:51 PM

0 Kudos

DELETE ITAB WHERE segnam = 'ZCREEXT' OR

                                   segnam = 'E1LFA1M' OR

                                   segnam = 'E1LFB1M' OR

                                   segnam = 'E1LFA1M' OR

                                   segnam = 'E1LFA1B' OR

                              segnam = 'E1LFA1A' OR

                              segnam = 'E1LFA1H' OR

                              segnam = 'E1LFA1L' OR

                              segnam = 'E1LFB1M' OR

                              segnam = 'E1LFBWM' OR

                              segnam = 'E1LFB5M' OR

                              segnam = 'E1LFB1H' OR

                              segnam = 'E1LFB1L'.

Now my question is Would this Statement would delete the segments available in Table ITAB as provided in the Condition.

Now in my code it is deleting the segments present in table ITAB as mentioned in the where clause. But i think it should only delete whichever the condition holds true..

Pls guide me whether this statement is correct or will it falter somewhere.

6 REPLIES 6

matt
Active Contributor

‎05-19-2013 9:04 AM

0 Kudos

If segnam is 'ZCREEXT', the record will be deleted.

If segnam is 'E1LFA1M' the record will be deleted

If segnam is 'E1LFB1M' the record will be deleted.

...

etc.

...

What's the problem? The DELETE statement removes exactly those records where the condition holds true. Perhaps your understanding of the condition is incorrect? What are you expecting?

Former Member
In response to matt

‎06-02-2013 9:24 PM

0 Kudos

Thanks for the reply..

I was of understanding that OR means that any of the conditions would work not both.

so nevertheless ur reply sorted out my confusion. thanks alot

Former Member
In response to matt

‎06-03-2013 10:29 AM

0 Kudos

This message was moderated.

Former Member

‎05-19-2013 9:38 AM

0 Kudos

Hi Rajat,

The records from the itab will be deleted for any of the condition you have specified since you are using 'OR'. There may be chances of multiple deletion of records. If segnam matches any of 'ZCREEXT' or

'E1LFA1M' or 'E1LFB1M' or 'E1LFA1M', the record will be deleted.

Former Member

‎05-19-2013 9:42 AM

0 Kudos

DATA: BEGIN OF ITAB OCCURS 0,

      sno type i,

      segnam type c LENGTH 7,       "Plant+ material

   END OF  ITAB.

itab-SNO = 1.

ITAB-segnam = 'ZCREEXT'.

APPEND ITAB.

CLEAR ITAB.

itab-SNO = 2.

ITAB-segnam = 'E1LFA1M'.

APPEND ITAB.

CLEAR ITAB.

itab-SNO = 3.

ITAB-segnam = 'E1LFB1M'.

APPEND ITAB.

CLEAR ITAB.

itab-SNO = 4.

ITAB-segnam =   'E1LFA1B'.

APPEND ITAB.

CLEAR ITAB.

itab-SNO = 5.

ITAB-segnam = 'E1LFA1M'.

APPEND ITAB.

CLEAR ITAB.

itab-SNO = 6.

ITAB-segnam = 'E1LFA1A'.

APPEND ITAB.

CLEAR ITAB.

itab-SNO = 7.

ITAB-segnam = 'E1LFA1H'.

APPEND ITAB.

CLEAR ITAB.

itab-SNO = 8.

ITAB-segnam = 'E1LFA1L'.

APPEND ITAB.

CLEAR ITAB.

itab-SNO = 9.

ITAB-segnam = 'E1LFB1M'.

APPEND ITAB.

CLEAR ITAB.

itab-SNO = 10.

ITAB-segnam = 'E1LFBWM'.

APPEND ITAB.

CLEAR ITAB.

itab-SNO = 11.

ITAB-segnam = 'E1LFB5M'.

APPEND ITAB.

CLEAR ITAB.

itab-SNO = 12.

ITAB-segnam = 'E1LFB1H'.

APPEND ITAB.

CLEAR ITAB.

itab-SNO = 13.

ITAB-segnam = 'E1LFB1L'.

APPEND ITAB.

CLEAR ITAB.

itab-SNO = 14.

ITAB-segnam = 'ABCDE'.

APPEND ITAB.

CLEAR ITAB.

DELETE ITAB WHERE segnam = 'ZCREEXT' OR

                                    segnam = 'E1LFA1M' OR

                                    segnam = 'E1LFB1M' OR

                                    segnam = 'E1LFA1M' OR "no need to repeat

                                    segnam = 'E1LFA1B' OR

                               segnam = 'E1LFA1A' OR

                               segnam = 'E1LFA1H' OR

                               segnam = 'E1LFA1L' OR

                               segnam = 'E1LFB1M' OR

                               segnam = 'E1LFBWM' OR

                               segnam = 'E1LFB5M' OR

                               segnam = 'E1LFB1H' OR

                               segnam = 'E1LFB1L'.

LOOP AT ITAB.

WRITE😕 ITAB-SEGNAM.

ENDLOOP.

YOUR REUSLT WILL BE ABCDE.

raymond_giuseppi
Active Contributor

‎05-20-2013 2:17 PM

0 Kudos

What do you exactly expect, you only post a statement for deletion, and then you ask us if it does what it is intended to do ?

If the statement doesn't work as you expected you wrongly code it, but as long as you don't write your exact requirement; guessing it is difficult/hazardous, try to write your requirement in plain logical English...

Regards,

Raymond