topic Re: Delete entry from Database table in Application Development and Automation Discussions

Delete entry from Database table

Former Member — Wed, 15 Jul 2009 07:20:00 GMT

Hi,

I configured one PCR scenerio in SPRO node -> business Packakes/ funtional packages-> Manager self service-> Personal Change request -> Group Change request scenerio.

later I deleted that entry in backend, but still the same entry exist in db table "TWPC_PCR_Groups" .

How can we delete that entry?

thanks

Re: Delete entry from Database table

Former Member — Wed, 15 Jul 2009 07:40:43 GMT

Hi,

SPRO configuarion depends on your table fields.. Please check again in SPRO if the entry exists.. If it exists ther it willbe present in the table..

Re: Delete entry from Database table

Former Member — Wed, 15 Jul 2009 08:40:52 GMT

Hi Sneha,

thanks for ur reply, I cheked no entry exist in SPRO only exist in DB table. so pls help me to delete that entry from DB table, without any ABAP coding.

thanks

Re: Delete entry from Database table

Former Member — Wed, 15 Jul 2009 09:46:57 GMT

Hi,

If you just want to delete a single entry from database table then you have to it in debug mode .

go to se11->Give table name->Press F7( ie: display table entries)-> Goto the table contents (CTRLSHIFTF10)->Select the entry you want to delete->Give /H in the command bar ->enter into debug mode-> Give code as DELE -> save it. and press enter. Your entry will be deleted from database.

Hope this helps..

Re: Delete entry from Database table

Former Member — Wed, 15 Jul 2009 09:52:58 GMT

Hi,

If the previous post is not understandable one more option is through table maintenance generator i.e Tcode SM30. Please check if the table from which you want to delete the entries has table maintenance generator activated. If yes then goto Tcode SM30-> give your table name ->Click on Maintain-> Choose the entry you want to delete-> and from the application toolbar click the delete button. save changes.. The entry will be deleted from your table.

Re: Delete entry from Database table

Former Member — Wed, 15 Jul 2009 10:06:58 GMT

Hi Sneha,

Thanks for ur consideration, that way to delete through SE16 I already suggested and tested it working fine, but as per my team ABAP they are saying that is not recommendable, it may be effect to other data in future...it will be create complication.

and through SM30 we can't delete bcs this entry does not exist there only in DAB table is exist.

so pls tell me any other way to delete it without touching ABAP things

Re: Delete entry from Database table

Former Member — Wed, 15 Jul 2009 11:43:04 GMT

Hi,

When you are deleting the entry from database table through debugger i dont think it will affect your future data because the entry is completely deleted from the table.. These are the only two ways of doing it. If you are saying that it is not present in the table maintainence then, it should be visible to you in table as well..

Re: Delete entry from Database table

Former Member — Wed, 15 Jul 2009 11:47:48 GMT

Hi, The entry might exist in database but it might be marked for deletion. Please check it.

Thanks

kamath

Re: Delete entry from Database table

Former Member — Thu, 16 Jul 2009 04:38:20 GMT

Hi,

this entry does not exist in Maintenance Table only exist in DB table and without deletion mark.

thanks

Re: Delete entry from Database table

Former Member — Thu, 16 Jul 2009 06:34:56 GMT

Hi,

You can also check if in the table maintenance generator of your table the table is defined as 'Automatically Adjustable' If not then you have to manually adjust the table and its entries.