How to delete recs from 'Z' table using SE11.

[Former Member]

Hi,

I have a client specific 'Z' - table but have no rights to insert / update / delete records in SE11.

Is there any other transaction code through which I can do so?

Thanks.

[Former Member]

Hikumar,

if its a ztable you can change. go and release the lock for it in sm01.

if its a sap standard table you cant change it.

thanks

karthik

[Former Member]

if the table has table maintenaince created for it then u can do all the activities thru se16. or u can create one small z-program as per your requirement.

[Former Member]

Hi,

if you don't have the rights to do what you want/need, ask you basis to get it.

Regards, Dieter

[Former Member]

Hi,

I think you should write a progarme to delete records from ZTABLE.

Regards

jana

[Former Member]

Hi,

This can be done by wriitng a program either in SE38 or SE80

plz look into a piece of code that deletes 12 month old data from a z table.

" Deleting 12 months old data.

  SELECT mandt
         representative
         selection_id
         sub_date
         sub_time
         superior
         team
         status
  FROM zo9_user_status
  INTO TABLE g_t_zo9_user_status_d
  WHERE sub_date LT g_outdate.

  IF sy-subrc = 0.

    DELETE zo9_user_status FROM TABLE g_t_zo9_user_status_d.
    IF sy-subrc = 0.
      MESSAGE i029 WITH sy-dbcnt text-002 .
    ENDIF.
  ENDIF.
  REFRESH g_t_zo9_user_status_d.

endif.

In similar with help of program we can insert update etc.

hope this helps.

thanx.

[naveen_inuganti2]

Hi...

1. Goto se11 or se16 excute the table...

2. Double click on the record, which you want to delete.

3. give /H in command field and press ENTER.

4. You will get debug screen there check variable CODE

5. It contains SHOW as value, now change that to 'edit'.

6. Click on excute (F8)

7. you will get previous screen with delete icon.

Remember edit should be lower case to delete the record, uppercase to modify the non key fields.

Or...

From se38,

delete from ztable where field1 = 'AAA'.

Here dont forget to give where condition, otherwise it will clears your table..

Thanks,

Naveen.I

[Former Member]

Hi Naveen,

I went in debug mode and checked for variable CODE. It works in development server in which it goes to main program SAPLSETB and source code LSETBF01 (using se11).

But that is not the case with quality server. In quality server, it goes in main program SAPLKKBL and source code LKKBLF01.

What should I do here?

Thanks.

[naveen_inuganti2]

Hi....

What ever the sever it may be... here what is the value for the variable CODE.

It will be SHOW,

So change it as 'edit'.

Even i do the same thing if i want to delete the record, where i have no access, it will works...

get back here with the problem, which you face..

Try this,

Naveen.I

[mohammed_moqeeth]

Hi Kumar,

If you dont have authorisation to insert/update/delete records in SE11.

Then you can create a z-program to delete records from z-table.

Ex:

DELETE FROM <z-table>

WHERE <field_name> = "field value".

Regards,

Moqeeth.

.

[mohammed_moqeeth]

Hi Kumar,

If you dont have authorisation to insert/update/delete records in SE11.

Then you can create a z-program to delete records from z-table.

Ex:

DELETE FROM <z-table>

WHERE <field_name> = "field value".

Regards,

Moqeeth.

[Former Member]

If you want to update few records in ZTABLE you can use SE16N (check you are authorised or not)

steps :

SE16N

enter table name ZTABLE

enter &SAP_EDIT in command line and press Enter

you'll see message 'SAP editing function is activated'

then press F8.

Now you can edit table entries.

[Former Member]

Go to Transaction SM30 and try doing the same....

Regards,

Kunjal

[former_member202957]

Hi Kumar,

Generate table matiance generator for the Ztable then using tcode SM30 u can make necessary changes.

regards,

Sunil kairam.

Edited by: sunil kairam on Sep 8, 2008 4:20 PM

[Former Member]

simple write a program

in which

write the statement

Delete <ztablename>

[Former Member]

-

[Former Member]

Hi...

1. Goto se11 or se16 execute the table...

2. Double click on the record, which you want to delete.

3. give /H in command field and press ENTER.

4. You will get debug screen there check variable CODE

5. It contains SHOW as value, now change that to 'DELE'.

6. Click on excute (F8)

7. you will get previous screen with delete icon.