topic Re: Delete clause clarification in Application Development and Automation Discussions

Delete clause clarification

Former Member — Sat, 15 Oct 2005 07:43:49 GMT

To delete data in one shot from database table...

delete dbtable not working..

IS it necessary to use where clause?

plz help me out

Re: Delete clause clarification

Former Member — Sat, 15 Oct 2005 08:05:01 GMT

You can't use the command DELETE alone, becouse you have to indicate which record you want to delete, so:

SELECT * FROM <TABLE> WHERE...

DELETE <TABLE>.

ENDSELECT.

B) DELETE FROM <TABLE> WHERE ......

C) DATA WA LIKE <TABLE>.

.......

DELETE <TABLE> FROM WA

D) DATA ITAB LIKE STANDARD TABLE OF <TABLE>.

..........

DELETE <TABLE> FROM TABLE ITAB.

Max

Re: Delete clause clarification

Former Member — Sat, 15 Oct 2005 08:27:30 GMT

Max thanks a lot for ur reply.

My requirement is just deletion of total data in one shot from database table thru abap program.

DELETE dbtable ...is for one row delete only?

suggest me query for this requirement...

i award u points also...

thank u

Re: Delete clause clarification

Former Member — Sat, 15 Oct 2005 08:29:48 GMT

and moreover...i dont want to use any itabs...in this issue

Re: Delete clause clarification

Former Member — Sat, 15 Oct 2005 08:35:25 GMT

you use this statatment without where conditions:

DELETE FROM <TABLE>.

Max

Message was edited by: max bianchi

Re: Delete clause clarification

Former Member — Sat, 15 Oct 2005 08:57:37 GMT

Hi Raja,

"delete dbtable" will work if you have defined

"Tables dbtable" and this will delete only record that matches the workarea dbtable.

To delete in one shot -

DELETE FROM DBTABLE.

But if its a client soecific table it will delete data in current client only . If you want to delete data in all clients use "client specified".

Cheers

Re: Delete clause clarification

Former Member — Sat, 15 Oct 2005 09:03:47 GMT

Hi,

If you want to delete all table entries without ABAP coding, go to tr.code SE11 -> Utilities -> Database utility (Transaction SE14).

Svetlin

Re: Delete clause clarification

Former Member — Sat, 15 Oct 2005 09:28:30 GMT

Hi Max & Sanjay,

DELETE from dbtab not working...

Syantax error: delete from itab shud be followed by where clause...

Help me out.

I have to do this programatically..

Re: Delete clause clarification

Former Member — Sat, 15 Oct 2005 09:29:31 GMT

sorry error msg : delete from dbtab shud be followed by where clause...

Re: Delete clause clarification

Former Member — Sat, 15 Oct 2005 09:40:18 GMT

GOT it from documentation.

check the following

To delete all the lines in a table, you must specify a WHERE condition that is true for all lines. You can achieve this with

... WHERE f IN itab

If the internal table itab is empty, such a condition would select all lines.

Re: Delete clause clarification

Former Member — Sat, 15 Oct 2005 10:47:53 GMT

Can anybody suggest me with out using where clause to delete table data in one shot..?

Thanks

Re: Delete clause clarification

Former Member — Sat, 15 Oct 2005 11:02:39 GMT

For non crossclients tables you can try with.

DELETE FROM <DBTABLE> CLIENT SPECIFIED WHERE MANDT = SY-MANDT.

Svetlin

Re: Delete clause clarification

athavanraja — Sat, 15 Oct 2005 11:15:51 GMT

you can use

delete from <dbtable> .

to delete all entries. it works fine. I just tried it out.

we are using 4.7

Regards

Raja

Re: Delete clause clarification

Former Member — Sat, 15 Oct 2005 13:49:45 GMT

I'm using 4.7, in this release you can use thie statament without where condition...I'm sorry, you can try to do:

DELETE FROM TABLE CLIENT SPECIFIED

WHERE MANDT = SY-MANDT.

I try to use this statament in 4.6C and no error has occured.

Max

Re: Delete clause clarification

Former Member — Sat, 15 Oct 2005 14:40:33 GMT

As others pointed out here, you can delete without using the where clause from 47 onwards. Why is that you don't want to use the where clause? It is as simple as

DELETE FROM dbtab WHERE <some key field> <> SPACE.

Re: Delete clause clarification

Former Member — Sat, 15 Oct 2005 15:53:10 GMT

Hi raja,

check this...

http://help.sap.com/saphelp_erp2004/helpdata/en/1e/f5383fe58d5900e10000000a114084/frameset.htm

regards,

venu.