to delete data from z table

[Former Member]

hi experts,

i have one ztable n i wan to delete particular data from this table that had been entered by some endusers..how cud i do that..

regards,

raman

[Former Member]

hi experts,

i have one ztable n i wan to delete particular data from this table that had been entered by some endusers..how cud i do that..

regards,

raman

[prasanth_kasturi]

hi,

if your ztable has field created by(ERNAM),

use that field in where condition to delete the records

delete itab where ernam = <enduser name>.

or

create a table maintenance generator

in the events write the code to capture the user name who entered,

delete those record

regards

prasanth

[Former Member]

Hi,

you can use se16n transaction like this:

start tr. se16n

type the table name and press ENTER.

Then type the string "&sap_edit" into the command line and strike Enter

again.

enter your selection criteria.

run.(F8)

now you can easily delete the lines you want (and then save)

All Changes are noted in the tables

SE16N_CD_DATA and

SE16N_CD_KEY.

Regards,

Jagadish

[Former Member]

Hi,

Create the table maintainance generator.Go to SM30.Enter table name.Delete the table entries.

[Former Member]

i wan to delete data in my production server..can i use sm30 there

[Former Member]

No you cant do the modifications in Production Server from the table maintenance.

Instead you need to create a table maintenance and transport the same to Production.

generally in Production, there wont be authorizations for developers to change the data.

Regards

Kannaiah

[Former Member]

i have never used sm30..plz guide me how cud i use that..or can u plz send me a simple program to delete data from that table

[Former Member]

Hi,

You wants to delete a row or some column in a row.

For row you can use delete statement.

To remove the data of any column you can use update statement with set <column name > = space

-Regards

Ashim

[Former Member]

Deleting entries solely depends the type of access u r having, if u have the access for deleting then u can easily go to SE16

and find that particular entry go to edit mode then Table entry-delete entry.

If u don't have permission to delete go to that entry edit mode and switch onto debugging mode then change the control from edit to delete and then save , then u will be able to delete that entry from database.

[Former Member]

You are left with only two options

1. Write a report program to delete entries.

2. create a table maintainance generater and transport it to procuction.

As far as I can see table maintainance generater will be the best option.

Regards

Bikas