Delete entry from Database table

[Former Member]

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

[Former Member]

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..

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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..

[Former Member]

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

Thanks

kamath

[Former Member]

Hi,

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

thanks

[Former Member]

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.

[Former Member]

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..