[500] in sapr3-soft

home help back first fref pref prev next nref lref last post

Re: deleting tables

daemon@ATHENA.MIT.EDU (Bitpsycho)
Mon Oct 13 11:37:43 1997

To: sapr3-soft@MIT.EDU
Date: 11 Oct 1997 18:48:48 -0500
From: "Bitpsycho" <bitpsycho@ping.be> (by way of SAP Moderator <sap-request@realtimeusa.com>)

Hi,

You will have to use the DELETE FROM <table> with the option that your
<deletion keys> are in an internal table.
Then leave that internal table empty.  This will delete all rows.
I don't remember the right syntax here (all my manuals are at work).
Just press F1 on the DELETE in the ABAP/4 editor
It should be something like this:

DELETE FROM ZNEWS WHERE  ... IN TABLE <internal table>

Don't forget to lock your table if that table is accessed a lot ...

If any more questions, just reply to this one ...

Bye,

Bitpsycho


Frode R=F8ed (by way of) wrote in article
<61iios$uat$1@photon.netconcepts.com>...


>My question is:  how do I delete the contents of a table ?

----------------------------------------------------
comp.soft-sys.business.sap is a moderated newsgroup.
Postings are archived and available from the
Realtime USA web site at http://www.realtimeusa.com
----------------------------------------------------

home help back first fref pref prev next nref lref last post