topic Re: Better Delete Logic?? in Application Development and Automation Discussions

Better Delete Logic??

former_member194669 — Wed, 22 Aug 2007 17:39:35 GMT

Hi All,

I have requirement to write a function module to delete records from 125 Y(custom) tables

This is my scenario.


delete from y100 where docno eq v_docno.
if sy-subrc eq 0.
  delete from y101 where docno eq v_docno.
  if sy-subrc eq 0.
     ......... " Keep this loop all remaining 125 tables
  else.
    rollback.
else.
  rollback.
endif.

I know i can do this using lot of IF statements, I want know any other better way to do this?

Please don't suggest to use lot of IF statements.

a®

Re: Better Delete Logic??

Former Member — Wed, 22 Aug 2007 17:48:32 GMT

Hi ARS,

May we can do this way.

v_table = 'Y100'.

do 25 times.

delete from v_table where docno eq v_docno.

if sy-subrc ne 0.

flag = 'X'.

exit.

endif.

v_table = v_table + 1.

enddo.

if flag = 'X'.

rollback.

endif.

Ali.

Re: Better Delete Logic??

former_member194669 — Wed, 22 Aug 2007 17:59:45 GMT

Quadri

Thanks for your reply.

Here table names are not unique. Some times delete for table name go like

Y100, Y101, Y106, Y123 ....... like that

I am getting the table name to delete in a import parameter table.

a®

Re: Better Delete Logic??

Former Member — Wed, 22 Aug 2007 18:06:47 GMT

ARS,

You can append all the table in one internal table and loop it.

This is one of the way.

Again it depends on your requirement.

Ali

Re: Better Delete Logic??

former_member194669 — Wed, 22 Aug 2007 18:11:41 GMT

Hi,

From your reply i understood, that i need to write dynamic delete, dynamically assign the table name something like this way

delete from = v_docno.

I think i need to field-symbol for this.

Anyway thanks for your help.

a®