topic Clear customize table data manually in Application Development and Automation Discussions

Clear customize table data manually

Former Member — Mon, 31 Mar 2008 03:14:26 GMT

I've create an add-on table. I would like to know how can I clear the table table in production environment. Thanks!

Re: Clear customize table data manually

Former Member — Mon, 31 Mar 2008 03:20:22 GMT

Should you have the maintenance object generated, you can try using transaction SM30 for manipulating the entries.

Re: Clear customize table data manually

Former Member — Mon, 31 Mar 2008 03:23:22 GMT

Create a Z_Transaction for Maintaining Table entries via SM30 bold specifically for this tablebold . This way you will be granted authorization just for this Z T.code and you can maintain entries for only this custom table.

Most of the clients do not give you authorization for SM30 in Production . That's why you need Z*transaction for one table,

Re: Clear customize table data manually

Former Member — Mon, 31 Mar 2008 03:26:59 GMT

Hi,

If table has less records,Goto tcode SE11--~~>Display(F7)~~->Press on content button(CtrlShiftF10)~~>F8~~->Select all records by clicking on check box~~>on command button enter "/h" for debugging~~->Enter ~~->(display)F7~~->again press F7-->system will go in debugg mode there will be avariable called "code"

In below field names enter 'CODE' -->press enter button it shows the value --->'SHOW' --->change that value to "DELE" on the same row there will be change button.Press that.Now press F6 .One by one record will get delete.

Re: Clear customize table data manually

Former Member — Mon, 31 Mar 2008 03:32:06 GMT

Hi,

If u know the Customizing table name.

in the development system.

Goto ~~> SE11~~>TABLE --> <TABNAME>.

SE11~~>VIEW~~><VIEWNAME>.

Delete or Change Entries it will prompt for a Request.

Transport the Request to Production system.

Changes will be reflected.

Regards,

Morris Bond.

Reward Points if Helpful.

Re: Clear customize table data manually

Former Member — Mon, 31 Mar 2008 03:32:21 GMT

better to do via Z . as transporting could create major issues with Admin guys . But can be used as an option.