how to delete the table entries (created data )

[Former Member]

in which table the created data will be get stored i need to delete it programitically can any one help me out in this, plz tell me the table name where the created data will be get stored.

[Former Member]

Hi

Rocky

use the delete statement

the information regarding delete is

DELETE dbtab

Syntax

DELETE { {FROM target [WHERE sql_cond]}

| {target FROM source} }.

Effect

The statement DELETE deletes one or more rows from the database table specified in target. The rows that are to be deleted are specified either in a WHERE condition sql_cond or with data objects in source.

System Fields

The statement DELETE sets the values of the system fields sy-subrc and sy-dbcnt.

sy-subrc Meaning

0 A least one row was deleted.

4 At least one row could not be deleted, since it was not found in the database table.

The statement MODIFY sets sy-dbcnt to the number of deleted rows.

Note

The rows are deleted permanently from the database table in the next database commit. Until then, you can cancel the deletion in a database rollback.

plzz reward if helpfull dont forget to reward if helpfull..

for any further quiries my mail id is

mutyalasunilkumar@gmail.com

[former_member386202]

Hi,

use delete statement to delete the data from table

delete mara index 10.

Regards,

Prashant

[Former Member]

Hi,

Don't delete the data from the table directly until unless if it is a stand alone table (no relationship exist with any other table).

if that table is updating from any Tcode then you have to delete the data from Tcode only, even though you have a facility to delete from the table, in real time there may be a chance of dependency, which will not suggestible.

if it is a Ztable which was created by you, then make sure that there is no relationship with another table, then only go for "Delete from table where coditions XXXXXX", even this is not suggestible, if it is a Ztable create table maintenance for that then do the operations you want.

Reward if useful.

Thanks,

Sreeram.

[Former Member]

Hi Rocky,

If u have ABAP editor then type "delete".place the cursor on it and click on help(F1) ,u can get the all options regarding delete.

if u want to delete the table

DELETE FROM MARA.

if u want to delete the table entries.

DELETE MARA FROM WA.

here WA contains the entries which u want to delete.

DELETE MARA FROM TABLE ITAB.

here ITAB contains the entries which u want to delete from the table MARA.

reward points if it is useful

thank you

chandu