topic Re: Problem with EVENT 01 in Table maintenance in Application Development and Automation Discussions

Problem with EVENT 01 in Table maintenance

Former Member — Thu, 31 Dec 2009 06:57:39 GMT

Hi,

I have used event 'before saving to database table' (01) in table maintenance generator and done some changes to the fileds. when I enter values they are getting saved in the database. but if i delete any entry form table maintenance and when I try to save, values are not getting deleted from database table.

My code in the event form is :

FORM abc.

DATA: F_INDEX LIKE SY-TABIX. "Index to note the lines found

LOOP AT TOTAL.

IF <ACTION> = desired constant.

READ TABLE EXTRACT WITH KEY TOTAL.

IF SY-SUBRC EQ 0.

F_INDEX = SY-TABIX.

ELSE.

CLEAR F_INDX.

ENDIF.

Make desired changes to the line TOTAL

TOTAL-uname = sy-uname.

TOTAL-udate = sy-datum

MODIFY TOTAL.

CHECK F_INDX GT 0.

EXTRACT = TOTAL.

MODIFY EXTRACT INDEX F_INDX.

ENDIF.

ENDLOOP.

SY-SUBRC = 0.

ENDFORM.

Can anyone solve this problem.

Thank you,

Regards,

Kusuma K.

Re: Problem with EVENT 01 in Table maintenance

Former Member — Thu, 31 Dec 2009 07:21:26 GMT

Hi Kusuma,

I dont think the event 01 , has any thing to do with deleting data from table , it is just used to do some check / modification before the data is saved in the table,.

After deleting the data , please save it and exit from the transaction and then again check if the data was deleetd or not , because i assume that the deleting is done as the last step .

Please feel free to revert in case of more questions.

Regards,

Arun

Re: Problem with EVENT 01 in Table maintenance

Former Member — Thu, 31 Dec 2009 07:22:47 GMT

Hi Kusuma,

For deleting a entry from database, you need to use the primary keys.

On the basis of index, it won't work.

Try this using Primary Key.

I hope it will help you.

Thanks & Regards,

Nidhi kothiyal

Re: Problem with EVENT 01 in Table maintenance

Former Member — Thu, 31 Dec 2009 08:02:07 GMT

You logic will work when any of the record is modified .

You need to consider the case in which a record is deleted from the internal table.

Check rhis.

Edited by: Harsh Bhalla on Dec 31, 2009 1:38 PM

Re: Problem with EVENT 01 in Table maintenance

Former Member — Thu, 31 Dec 2009 08:39:35 GMT

Thank you all. Problem is solved. I need to check status of the action. STATUS-ACTION should be equal to HINZUFUEGEN

Regards,

Kusuma K.

Edited by: kusuma kurapati on Dec 31, 2009 2:09 PM

Re: Problem with EVENT 01 in Table maintenance

kiran_k8 — Thu, 31 Dec 2009 08:39:50 GMT

Kusuma,

Check the below give link,may be it can give you some lead

http://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=93454609

Kiran.