Delete information in a TAble

[Former Member]

I have a table Z99 ( I create it on SAP , se11 ).

When I refresc a TableControl ( table ITAB )... I want to delete all the informaction on Z99 and insert all the information on ITAB ( for update information base).

I try to do :

Refresh z99 .

But error appears because is not an internal table.

[Former Member]

Hi,

When the REFRESH button is pressed..

WHEN 'REFRESH'.

REFRESH ITAB_TC.

SELECT * FROM Z99 INTO TABLE ITAB_TC.

Thanks,

Naren

[Former Member]

But I want the other way ....

When I save, i want to eliminate registers of Z99 and I want to transfer all the information from ITAB( internat table) to Z99 ( se11 created)

[Former Member]

Hi Marc,

Use the statement MODIFY for your requirement.

<b>MODIFY Z99 FROM TABLE ITAB.</b>

Check this link to know more about MODIFY statement

http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/modify_d.htm

Thanks,

Vinay

Message was edited by:

Vinaykumar G

[Former Member]

But the modify only insert and update.

And I delete lines in ITAB, and this lines have to be deleted from Z99 ( database).

I'm testing :

delete Z99.

Transfer all the information ITAB to Z99. I try select * from ITAB into corresponging fields of Z99, but i doesnt work!

because is a internal table, I have to use READ. How is it?

[Former Member]

Hi Marc,

To delete an internal table entries, use the statement

DELETE ITAB.

To delete a databse table entries, use the statement

DELETE Z99.

Thanks,

Vinay

[Former Member]

Hi,

Then you can use the MODIFY statement..

MODIFY Z99 FROM TABLE ITAB.

IF ITAB is of the same structure of the table Z99..

Thanks,

Naren