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
Showing results for 
Search instead for 
Did you mean: 

delete statement

Former Member
0 Kudos

Hi

experts can anyone please tell me the syntax of delete statament.actually my code is not running and is giving a shortdump.

DELETE itab WHERE emo_cd_rd_dest = 2314.

is there any alternate mthod fot this.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

Try this,

DELETE itab WHERE emo_cd_rd_dest = '2314'.

What dump it is Showing?

Regards,

Padmam.

5 REPLIES 5

Former Member
0 Kudos

Hi,

what is the error message in shortdump?

former_member491305
Active Contributor
0 Kudos

Hi,

Give it in codes.

DELETE itab WHERE emo_cd_rd_dest = '2314'.

former_member404244
Active Contributor
0 Kudos

Hi,

Try like this.use single code.

DELETE itab WHERE emo_cd_rd_dest = '2314'.

Regards,

Nagaraj

Former Member
0 Kudos

Hi,

Try this,

DELETE itab WHERE emo_cd_rd_dest = '2314'.

What dump it is Showing?

Regards,

Padmam.

Former Member
0 Kudos

Hi Gaurav

You can also use Clear or else you can also delete by comparing

DELETE ADJACENT DUPLICATES FROM itab.

DATA ITAB LIKE STANDARD TABLE OF LINE 
          WITH NON-UNIQUE KEY COL2.

LINE-COL1 = 1. LINE-COL2 = 'A'. APPEND LINE TO ITAB.
LINE-COL1 = 1. LINE-COL2 = 'A'. APPEND LINE TO ITAB.
LINE-COL1 = 1. LINE-COL2 = 'B'. APPEND LINE TO ITAB.
LINE-COL1 = 2. LINE-COL2 = 'B'. APPEND LINE TO ITAB.
LINE-COL1 = 3. LINE-COL2 = 'B'. APPEND LINE TO ITAB.
LINE-COL1 = 4. LINE-COL2 = 'B'. APPEND LINE TO ITAB.
LINE-COL1 = 5. LINE-COL2 = 'A'. APPEND LINE TO ITAB.

OFF = 0. PERFORM LIST.

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING ALL FIELDS.

OFF = 14. PERFORM LIST.

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING COL1.

OFF = 28. PERFORM LIST.

DELETE ADJACENT DUPLICATES FROM ITAB.

OFF = 42. PERFORM LIST.

FORM LIST.
  SKIP TO LINE 3.
  LOOP AT ITAB INTO LINE.
     WRITE: AT /OFF  LINE-COL1, LINE-COL2.
  ENDLOOP.
ENDFORM.

Reward all helpfull answers

Regards

Pavan