Skip to Content
0
Former Member
Jun 14, 2005 at 07:34 AM

Problem in working with Native SQL

47 Views

HI all,

when i run the attached native sql query i have written in my program i get a dump error can anyone help me.

*******************************************************

exec sql.

select ( select bdmng from resb

where bdter = lk_wk1_1 )

( select bdmng from resb

where bdter = lk_wk2_1 )

( select bdmng from resb

where bdter = lk_wk3_1 )

( select bdmng from resb

where bdter = lk_wk4_1 )

( select bdmng from resb

where bdter = lk_wk5_1 )

( select bdmng from resb

where bdter = lk_wk6_1 )

( select bdmng from resb

where bdter = lk_wk7_1 )

( select bdmng from resb

where bdter = lk_wk8_1 )

from resb

into :l_powk1,:l_powk2,:l_powk3,:l_powk4,

:l_powk5,:l_powk6,:l_powk7,:l_powk8

where BDART = 'F'

and matnr eq it_mard-matnr

and werks eq it_mard-werks

and aufnr eq space.

endexec.

******************************************************

Regards

Guhapriyan