how to delete records from Ztable

[Former Member]

Hi Experts,

i have a requirement like:

i ve a Ztable (YSHR_NRIC) with 10 records, and i ve an internal table itab1 with 5 records, these 5 records from Ztable only.

now i want to delete these(itab1 5 records) records from Ztable.

how can i precede?

thanks in Advance,

sudeer.

[Former Member]

Please press F1 on DELETE.

Rob

[former_member598013]

Hi Sudeer,

Use the below statement to delete the database table entry.

DELETE  dbtab      FROM TABLE itab. 

Thanks,

Chidanand

[Former Member]

Hi Sudeer,

The DELETE statement deletes rows in a table.

Syntax

<delete_statement> ::=

DELETE [FROM] <table_name> [<reference_name>] [KEY <key_spec>,...] [WHERE <search_condition>]

| DELETE [FROM] <table_name> [<reference_name>] WHERE CURRENT OF <result_table_name>

For more information check this link

http://www.sapdb.org/7.4/htmhelp/34/ee7fbd293911d3a97d00a0c9449261/content.htm

Cheers!!

Balu