topic Re: delete table in Application Development and Automation Discussions

delete table

Former Member — Thu, 16 Jun 2005 11:31:03 GMT

HI!

Is there a function to delete table entries from a non sap table.

thanks

Re: delete table

athavanraja — Thu, 16 Jun 2005 11:39:27 GMT

before answering your question a request

can you close/reply/reward point to the anwers which were helpful, this would encourage many people to join SDN to help each other .

e.g of you unclosed thread

mark your posts as question.

Now to your question:

you can write a simple porgram to do this job. i dont think that you will find a FM for this job.

Regards

Raja

Re: delete table

Former Member — Thu, 16 Jun 2005 12:17:49 GMT

Hi,

U can use

1. DELETE itab.

2. DELETE TABLE itab WITH TABLE KEY k1 = v1 ... kn = vn.

3. DELETE TABLE itab [FROM wa].

4. DELETE itab INDEX idx.

5. DELETE itab FROM idx1 TO idx2.

6. DELETE itab WHERE logexp.

7. DELETE ADJACENT DUPLICATES FROM itab.

Re: delete table

eddy_declercq — Thu, 16 Jun 2005 12:34:13 GMT

Have also a look at http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/delete02.htm

Re: delete table

Former Member — Thu, 16 Jun 2005 15:55:59 GMT

If you need to execute SQL commnads on external database...depending on the database, you will have to use native SQL stms in ABAP.

using

EXEC SQL.

connect to :lv_connection_name.

DELETE .. " Native SQL of external database

ENDEXEC.

But then you need to do some settings to connect to the external database.

for example , in case of MSSQL you need to have a connection name entry in table DBCON.

Get in touch with your basis team.

Thanks,

Ram

Re: delete table

eddy_declercq — Mon, 27 Jun 2005 11:42:14 GMT

Pls don't forget to assign reward points when you feel that the answers to your questions are valuable.

Re: delete table

jayanthi_jayaraman — Mon, 27 Jun 2005 12:08:33 GMT

Hi,

FM is not needed.The following will do.

exec sql.

truncate averi_clnt

endexec.

Kindly reward points,if your problem is solved.Otherwise,get back.