Clear customize table data manually

[Former Member]

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

[Former Member]

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

[Former Member]

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,

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi,

If u know the Customizing table name.

in the development system.

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

or

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.