topic Re: to delete data from z table in Application Development and Automation Discussions

to delete data from z table

Former Member — Thu, 05 Jun 2008 09:31:53 GMT

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

Re: to delete data from z table

prasanth_kasturi — Thu, 05 Jun 2008 09:34:06 GMT

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

create a table maintenance generator

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

delete those record

regards

prasanth

Re: to delete data from z table

Former Member — Thu, 05 Jun 2008 09:35:37 GMT

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

Re: to delete data from z table

Former Member — Thu, 05 Jun 2008 09:35:44 GMT

Hi,

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

Re: to delete data from z table

Former Member — Thu, 05 Jun 2008 09:36:10 GMT

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

Re: to delete data from z table

Former Member — Thu, 05 Jun 2008 09:41:17 GMT

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

Re: to delete data from z table

Former Member — Thu, 05 Jun 2008 09:43:14 GMT

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.

Re: to delete data from z table

Former Member — Thu, 05 Jun 2008 09:43:15 GMT

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

Re: to delete data from z table

Former Member — Thu, 05 Jun 2008 09:43:54 GMT

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

Re: to delete data from z table

Former Member — Thu, 05 Jun 2008 09:49:14 GMT

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