How to delete entries in SAP table through transport?

[Former Member]

How can I delete an entry or block of entries in a SAP table and transport to PW?

[Former Member]

Firstly Check if you have authorization to delete data from SAP Tables?

Why do you need to delete it? Data will be deleted automatically via transactions like when you create a document no , you can also delete the doc no using the transaction which you created.

Please elaborate your requirement.

Thanks,

Anita

[Former Member]

Hi Franks,

Go to SE11, enter your table name and press F7. In Display Table screen go to Utilities -> Table Maintenance Generator. In Generate Table Maintenance Dialog

Authorization Group &NC&

Function group Give a new function group

Maintenance type Select Two step radio button

Give Overview screen & Single screen numbers(As your wish).

Select Standard recording routine radio button under Dialog Data Transport Details. At last save the changes in the same screen and go to SM30 and try to create a new entry in the table then in the next screen it asks for request number.

Regards,

Satish

[Former Member]

Hi,

Deleting Table Entries

To delete a table entry or a block of entries, first select the entry (entries). After it has been deleted, a selected entry is assigned a deletion indicator in an internal buffer and no longer appears in the list of the table entries in the overview screen. As long as you have not yet saved your deletion, you can display and retrieve the entries which are buffered internally.

Procedure:

Select the table entry or the block you want to delete.

Choose Edit ® Delete.

Check that you really want to delete the table entries concerned.

Choose Selection ® Display deleted entries.

This takes you to the internal buffer (the Overview of Deleted Entries screen).

If you find table entries that you do not want to delete, select them in this internal buffer.

To retrieve the table entries that you selected in Step 4, choose Retrieve.

To definitively confirm your deletions, save the contents of the internal buffer in the Overview of Deleted Entries screen.

You can now no longer retrieve the deleted table entries.

When you delete table entries in a view cluster, the R/3 System checks whether the table entry to be deleted contains dependent table entries. If it does, the dependent table entries are deleted too.

When you retrieve entries in a view cluster, the R/3 System also retrieves the dependent and higher-level table entries automatically.

thanks

Jgds

[former_member404244]

Hi,

Create a zprogram where u have to write

the statement

DELETE FROM ztable CLIENT SPECIFIED WHERE mandt EQ sy-mandt.

now attach the porgram to a request and then release it..

Reagrds,

Nagaraj

[raymond_giuseppi]

First the entries to delete must not exist on the source system. (Delete them if necessary, if so defined in maintenance generator a transport request may be created there, else)

Create a transport request and insert an object :

R3TR TABU <filename>

Select the line created and go to Key List, and add the keys to be deleted (you can use wildcard at the end of keys)

Then release and transport the order.

Regards

[Former Member]

Hi Raymond,

Thanks! and this is exactly what I was looking for.

Happy Holidays!

[Former Member]

Thanks, Raymond! Great instruction...

[kiran_k8]

Frank,

First and foremost what kind of data you intend to delete ? Master data or Transaction data ? For deleting transaction data it is always advisable to do it through a program rather than creating a table maintenance and then deleting it or rather I say should only be through a program and not through Table maintenance.

K.Kiran.