Using a variable on select

[Former Member]

Hi guys, i need to delete some entries from different tables like 20,

i want to do something like this:

IF dumy = x.

table = 'PA0001'.

ELSE.

table = 'pa2001'.

ENDIF.

DELETE FROM TABLE.

WHERE BEGDA = '99991231'

AND ENDDA = '99991231'.

any ideas?

Edited by: javier santana on Mar 19, 2008 12:33 AM

[Former Member]

Hi Javier,

It is not recommended that you delete the data from standard table using ABAP code. Use the standard transactions, BAPI provided to do the same.

Regards,

Atish

[Former Member]

Atish,

its only for Z tables, i wrote standards in order to made the example.

tks anyway.

[Former Member]

Hi,

Refer to the code snippet below.

Code Snippet

DATA: l_dummy TYPE char1,

l_table TYPE tabname.

l_dummy = 'X'.

IF l_dummy EQ 'X'.

l_table = 'PA0001'.

ELSE.

l_table = 'PA2001'.

ENDIF.

DELETE FROM (l_table)

WHERE begda = '99991231'

AND endda = '99991231'.

Regards,

Farheen

[Former Member]

data: tab(10) type c,

l_pernr type pa0001-pernr value '00000002'.

if l_pernr eq '00000002'.

tab = 'PA0001'.

else.

tab = 'PA2001'.

endif.

delete from (tab) where pernr = l_pernr.

if sy-subrc eq 0.

write:/ 'Done'.

endif.

Reward if useful............