Skip to Content
avatar image
Former Member

how to delete records from Ztable

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 20, 2008 at 03:10 PM

    Please press F1 on DELETE.

    Rob

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2008 at 03:15 PM

    Hi Sudeer,

    Use the below statement to delete the database table entry.

    DELETE  dbtab      FROM TABLE itab. 
    

    Thanks,

    Chidanand

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2008 at 03:42 PM

    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

    Add comment
    10|10000 characters needed characters exceeded