Run Time Error

Hi Experts,

I m creating a report related to notification summary.

i have plant and notification fields on screen.I want to fetch notification types,status(nopr,osno,noco) so i m using viqmel and jest tables.

my query is this.

select a~qmnum

a~qmdat

a~qmart

a~iwerk

a~objnr

b~stat from viqmel as a inner join jest as b

• on a_{mandt = b}mandt and

on a_{objnr = b}objnr

into table it_viqmel

where a~iwerk = p_werks

and a~qmdat = p_date.

and ( b_{stat = 'I0068' OR b}stat = 'I0070' OR b~stat = 'I0072' )

AND b~inact <> 'X'.

select txt04

txt30

from tj02t

into table it_tj02t

for all entries in it_viqmel

where istat = it_viqmel-stat

and spras = 'E'.

but it is giving DBIF_RSQL_INVALID_RSQL error.

Please suggest me where i m doing mistake.and are the tables correct for this.