topic Re: Delete without a where condition in Application Development and Automation Discussions

Delete without a where condition

Former Member — Tue, 31 May 2005 11:14:14 GMT

Hi,

I am giving a delete <tablename> statement in a macro, the table name is passed as a parameter. However while compiling it gives me an error saying that it expects a where condition but I don’t have an where condition I want to delete all the entries in the table. I dont want to use client specified. this problem occurs only if it is a SAP standard table. There is a statement in INFORMIX like delete from <tablename> where 1=1. Is there any statement like this in ABAP.

Regards

Raghu

Re: Delete without a where condition

Former Member — Tue, 31 May 2005 11:19:08 GMT

Hi,

try delete from (tabname).

Additionally check out the F1-help on the keyword delete.

regards

Siggi

Message was edited by: Siegfried Szameitat

Re: Delete without a where condition

Former Member — Tue, 31 May 2005 11:27:54 GMT

Hi,

I tried DELETE (IADR&1). and it did not work, it shows compilation errors

Re: Delete without a where condition

Former Member — Tue, 31 May 2005 11:30:57 GMT

well, not DELETE (IADR&1) but DELETE FROM (IADR&1).

Re: Delete without a where condition

RichHeilman — Tue, 31 May 2005 11:37:34 GMT

This is usually how I delete all records of a database table.



delete from <tablename> client specified 
             where mandt = sy-mandt.

You could also use the following syntax if your internal table has all the database table records that you want to delete.



  delete <db_table> from table <itab>.

Regards,

Rich Heilman

Re: Delete without a where condition

Former Member — Tue, 31 May 2005 11:42:06 GMT

no, that also did not work, i tried it and then only posted it

Re: Delete without a where condition

Former Member — Tue, 31 May 2005 11:43:43 GMT

delete from (tabname) will delete the database table.

Give a condition that will always be +ve.

Like if you r deleting from t_mara...

give delete itab where matnr <> space.

Or still better, use refresh itab. clear itab.

Pls reward proper points to the answer that helped u sovle ur problem.

Re: Delete without a where condition

RichHeilman — Tue, 31 May 2005 11:53:38 GMT

To be clear, are you trying delete data from a database table or an internal table?

Regards,

Rich Heilman

Re: Delete without a where condition

jayanthi_jayaraman — Tue, 31 May 2005 11:56:33 GMT

Hi,

try

delete (tabname).

Re: Delete without a where condition

RichHeilman — Tue, 31 May 2005 12:04:51 GMT

I've just tested the statements which I suggestion above. They both work well. Can you post some of the relevant code. Here is the code that I have tested.



  data: itab type table of zdbtab with header line.
  select * into corresponding fields of table itab
            from zdbtab.
  delete zdbtab from table itab.

Regards,

Rich Heilman

Re: Delete without a where condition

Former Member — Tue, 31 May 2005 12:24:13 GMT

Hi all,

I also have some programs where I have the statment

DELETE FROM (tabname).

It works.

So in this case I think there is an issue with the parameter of the macro. May be you should give it a try to create a subroutine as follows:

form delete_table using p_tabname type c.

delete from (p_tabname).

endform.

I strongly believe that this will work.

regards

Siggi

Re: Delete without a where condition

Former Member — Wed, 01 Jun 2005 04:50:58 GMT

DEFINE SELECT_ADR_S.

SELECT * INTO CORRESPONDING FIELDS OF TABLE IADR&1

FROM ADR&1S

WHERE TRKORR = H_TRKORR.

DELETE ADR&1S from IADR&1.

DELETE ADR&1S.

*. "CLIENT SPECIFIED

WHERE CLIENT EQ SY-MANDT.

END-OF-DEFINITION.

This is the potion of code i have written. Deletion is from a Database Table

Re: Delete without a where condition

Former Member — Wed, 01 Jun 2005 04:58:59 GMT

Hi,

Syntax for delete is

DELETE FROM <Databasetable name>.

DELETE (dbtabname) FROM TABLE itab.

U have missed Table itab

DELETE ADR&1S from Table IADR&1.

Also

DELETE From ADR&1S.

It will work fine.

Also got this info from help docu

DELETE FROM DATABASE dbtab(ar) ... ID key.

Addition:

... CLIENT f

Effect

Deletes the data cluster stored in the table dbtab under the area ar (constant) and the ID key (field or literal) (EXPORT ... TO DATABASE ...).

Example

TABLES INDX.

TYPES: BEGIN OF TAB OCCURS 1,

CONT(30),

END OF TAB.

DATA: FLD(30) TYPE C,

TAB TYPE TABLE OF TAB_TYPE WITH NON-UNIQUE DEFAULT KEY,

WA_INDX TYPE INDX.

...

EXPORT TAB FROM TAB

FLD FROM FLD TO DATABASE INDX(AR)

ID 'TEST'.

You can delete this data cluster with the following statement:

DELETE FROM DATABASE INDX(AR) ID 'TEST'.

Addition 1

... CLIENT f

Effect

Deletes the data cluster in the client specified in the table f (only with client-specific import/export databases).

Example

TABLES INDX.

DELETE FROM DATABASE INDX(AR) CLIENT '001' ID 'TEST'.

Thanks & Regards,

Judith.

Message was edited by: Judith Jessie Selvi

Re: Delete without a where condition

Former Member — Wed, 01 Jun 2005 05:18:21 GMT

Hi,

I get an error saying that "Delete from dbtab" should be followed by a where condition.

Regards

Raghu

Re: Delete without a where condition

athavanraja — Wed, 01 Jun 2005 05:25:46 GMT

Can you copy paste your code here, we can correct it test it and post it back here.

Regards

Raja

Re: Delete without a where condition

Former Member — Wed, 01 Jun 2005 05:25:49 GMT

Hi,

It is not like that the syntax is correct.

Kindly check it once more

or u can try as

DELETE from ADR&1S where TRKORR = H_TRKORR.

that is in the select condition.

Thanks & Regrads,

Judith.

Re: Delete without a where condition

jayanthi_jayaraman — Wed, 01 Jun 2005 05:26:44 GMT

Hi,

Instead of the select & delete statement,I suggest you to write the following.

delete from ADR&iS where TRKORR = H_TRKORR.

In your code,you are selecting the record which satisfies TRKORR = H_TRKORR and then deleting the selected lines from the table.Instead of that this piece of code directly deletes the records from the database table.

Re: Delete without a where condition

Former Member — Wed, 01 Jun 2005 05:47:21 GMT

Hi,

by the way, which release are you working on?

Siggi

Re: Delete without a where condition

Former Member — Wed, 01 Jun 2005 06:13:00 GMT

*----

DEFINE SELECT_ADR_S.

SELECT * INTO CORRESPONDING FIELDS OF TABLE IADR&1

FROM ADR&1S

WHERE TRKORR = H_TRKORR.

DELETE ADR&1S from IADR&1.

DELETE ADR&1S.

DELETE (IADR&1).

*. "CLIENT SPECIFIED

WHERE CLIENT EQ SY-MANDT.

END-OF-DEFINITION.

This is the portion of code

Re: Delete without a where condition

jayanthi_jayaraman — Wed, 01 Jun 2005 06:17:00 GMT

Hi Raghuram,

Have you tried my suggestion?

Instead of the select & delete statement,I suggest you to write the following.

delete from ADR&iS where TRKORR = H_TRKORR.

Reward points for those answers which are useful.