Skip to Content
0
Former Member
Jan 08, 2008 at 05:11 AM

Run Time Error

36 Views

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 amandt = bmandt and

on aobjnr = bobjnr

into table it_viqmel

where a~iwerk = p_werks

and a~qmdat = p_date.

and ( bstat = 'I0068' OR bstat = '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.