topic Re: delete key fields in a table in Application Development and Automation Discussions

delete key fields in a table

Former Member — Fri, 10 Nov 2006 10:05:34 GMT

Hi,

I use a very simple program to delete an entire table. Like the following:

REPORT z_erase_vcom1.

TABLES /bic/pvcom1.

DELETE FROM /bic/pvcom1.

the data is erased, but the table still contains the key fields. how can i completely erase the table including all fields?

afterwards i want to fill the table with fresh data from another system. so i want this table to be clean.

thanks,

stefan

Former Member — Fri, 10 Nov 2006 10:09:30 GMT

hi,

refrash tablename.

anversha_s — Fri, 10 Nov 2006 10:11:34 GMT

Hi,

chk this.

SELECT * FROM /bic/pvcom1 
INTO CORRESPONDING FIELDS OF TABLE it_tab. 

 
DELETE /bic/pvcom1 FROM TABLE it_tab
 
CALL FUNCTION 'DB_COMMIT'.

regards

Anver

<i><b>if hlpe pls mark points</b></i>

Former Member — Fri, 10 Nov 2006 10:13:47 GMT

Hi,

DELETE statement will delete records in internal table.

CLEAR statement will clear work area. (i.e data stored in header)

REFRESH will clear all records including header record in table. And table will be empty.

For your requirement REFRESH is appropriate.

*MARK all helpful answers

Former Member — Fri, 10 Nov 2006 10:16:17 GMT

Hi thank you all,

good work:)

this rewarding system does not work sometimes...

Former Member — Fri, 10 Nov 2006 10:17:27 GMT

hai ,

do this way.

data : i_/bic/pvcom1 like /bic/pvcom1 occurs 0 .

select * from /bic/pvcom1 into i_/bic/pvcom1 .

delete /bic/pvcom1 from table i_/bic/pvcom1 .

roberto_tagliento — Fri, 10 Nov 2006 10:20:06 GMT

DELETE FROM /bic/pvcom1 WHERE condition.

Find the condition that is true for all lines.

For example, a numeric field that is always positive the condition is:

DELETE FROM /bic/pvcom1 WHERE field GT -1.