Select query error.

Hello All,

I get this error:

"Program ZTEST

Field "HRP1000-OBJID" unknown."

when I run this query:

REPORT ZTEST.

data: end_date type sy-datum,

pos(40) type C,

user(12) type C.

select single stext from hrp1000 into pos

where hrp1000-objid = hrp9007-objid

and plvar eq '01'

and istat eq '1'

and begda le sy-datum

and endda ge sy-datum

and reqnr eq '297006'

and status eq '99'.

write pos.

Can anyone tell me whats the syntax in complex queries.

Regards.

Srinivas