topic Re: how can i write the bellow code using field symbols in Application Development and Automation Discussions

how can i write the bellow code using field symbols

Former Member — Mon, 15 Sep 2008 13:06:06 GMT

data : it_mara type table of mara.

select * from mara

into it_mara.

delete it_mara where matnr = '100-100'

and meins = 'KG'.

if i do the same by using field symbols

i am getting data into <it_mara>

but

delete <it_mara> where matnr = '100-100'

and meins = 'KG'.

is showing syntax error

how to correct the error ?

Re: how can i write the bellow code using field symbols

Former Member — Mon, 15 Sep 2008 13:09:54 GMT

you can do this...

data : it_mara type table of mara.
types: t_mara type standard table of mara.
field-symbols: <it_mara> type t_mara.

select * from mara
into table it_mara.

assign it_mara to <it_mara>.

 
delete <it_mara> where matnr = '100-100'
and meins = 'KG'.

Re: how can i write the bellow code using field symbols

Former Member — Mon, 15 Sep 2008 13:24:34 GMT

I think, DELETE does not allows to dynamically define the logical expression for the WHERE clausule.

Have you tried by filtering data in SELECT statement??

Something like:


if dataBase = 'MARA'.
append 'MATNR <> '100-100'' to Itab_Where[].
append 'AND MEINS <> 'KG'' to Itab_Where[].
endIf.
...
select * from (dataBase) where (Itab_Where) into table <my_table>.

this is possible, but I don't know if this fits your requirements.

Re: how can i write the bellow code using field symbols

Former Member — Mon, 15 Sep 2008 14:05:59 GMT

its solved