topic Re: Dynamic delete stmt in Application Development and Automation Discussions

Dynamic delete stmt

Former Member — Thu, 23 Aug 2007 18:57:51 GMT

Hi All,

How can i write dynamic delete stmt. please give example.

I have internale table contains the 4 fields IT_SET. depends on IT_SET i want to delete the data from IT_FINAL_DATA.

HOw can i write the delete stmt dynamically.

regards,

Re: Dynamic delete stmt

Former Member — Thu, 23 Aug 2007 19:30:53 GMT

Hi Ajay,

I would say Loop thru ur it_final_data and within the loop read ur it_Set table and if the condition satisfies delete the entry from it_final_data. I don't understand what you mean by dynamic delete.

I hope it helps you.

David.

Re: Dynamic delete stmt

Former Member — Thu, 23 Aug 2007 19:38:57 GMT

Hi David,

I want wriite delete stmt dynamically on the IT_FINAL_DATA.

regards,

Re: Dynamic delete stmt

Former Member — Thu, 23 Aug 2007 19:54:53 GMT

Hi,

try this...

loop at IT_SET.

if it_set-field1 = 'X' and it_set-field3 = 'Y' . "(for example)

delete IT_FINAL_DATA where f1 = 'Z' and f2 = 'W'.

endif.

endloop.

(suppose field1 and field3 are fields of it_set and f1 and f2 are fields of it+final_data)

regards,

Ravi

Re: Dynamic delete stmt

Former Member — Thu, 23 Aug 2007 20:01:43 GMT

Hi Ajay,

Use this statement

Loop thru it_final_data.

Read table it_set into wa_set with key cond1

cond2.

If sy-subrc EQ 0.

Delete it_final_data where field1 = wa_set-field1.

Endif.

Endloop.

Hope it helps you.

Thanks,

David.

Re: Dynamic delete stmt

Former Member — Thu, 23 Aug 2007 22:22:32 GMT

Something like this....


DATA: WHERE_STRING TYPE STRING.

WHERE_STRING = 'FIELD1 NE SPACE AND FIELD2 EQ ''2'''.

DELETE MYTABLE WHERE (WHERE_STRING).

Greetings,

Blag.

Re: Dynamic delete stmt

Former Member — Fri, 24 Aug 2007 05:32:06 GMT

I don't think you can use a (where_cond) for deleting from an internal table, only from a DB table.

Another solution is using field symbols:

loop at it_final_data into final_data.

loop at it_set into set.

assign component set-fieldname of structure final_data to <field>.

if set-value ne <field>.

delete it_final_data.

exit.

endif.

endloop.

michael