topic Re: Deleting records from database table in Application Development and Automation Discussions

Deleting records from database table

Former Member — Thu, 19 Jul 2007 09:48:14 GMT

Hi Experts,

In this program i used Table Control.

Here i want to delete the selected Rows. But Here if i say delete the selected row , it is deleting the last row. Why ?

Please help me It's Urgent.

Thanks,

Basu

MODULE USER_COMMAND_9000 INPUT.

DATA: LV_FCODE LIKE SY-UCOMM.

LV_FCODE = SY-UCOMM.

CASE LV_FCODE.

WHEN 'CHANGE'.

FLG = 'Y'.

WHEN 'DELETE'.

FLG = 'Y'.

LOOP AT I_MAKT.

DATA NUM TYPE N.

NUM = SY-TABIX.

READ TABLE I_MAKT INDEX NUM INTO I_MAKT1-EMPID.

MOVE I_MAKT1-EMPID TO I_MAKT2-EMPID.

ENDLOOP.

UPDATE ZEMPLOYE FROM TABLE I_MAKT.

DELETE I_MAKT WHERE EMPID = I_MAKT2-EMPID.

DELETE FROM ZEMPLOYE WHERE EMPID = I_MAKT2-EMPID.

MESSAGE S001(YTC).

WHEN 'INSERT'.

MODIFY ZEMPLOYE FROM TABLE I_MAKT.

MESSAGE S002(YTC).

WHEN 'BACK'.

SET SCREEN 0.

WHEN 'EXIT' OR 'CANCEL'.

LEAVE PROGRAM.

ENDCASE.

ENDMODULE. " USER_COMMAND_9000 INPUT

Re: Deleting records from database table

Former Member — Thu, 19 Jul 2007 09:50:40 GMT

Hi,

See following link:

http://www.sapmaterial.com/tablecontrol_sap.html

Reward points if helpful.

Regards.

Srikanta Gope.

Re: Deleting records from database table

Former Member — Thu, 19 Jul 2007 09:51:52 GMT

First if you want to delete more than one rows you have to append I_MAKT2 in the loop.

and then loop at I_MAKT2 and doing in the loop the delete operation.

if not you delete only the record it has in the header line.

hope this helps

Re: Deleting records from database table

Former Member — Thu, 19 Jul 2007 12:03:32 GMT

No yaar its not working.

Tell me another way.

Thank you

Basu