select Querry

Former Member — Mon, 21 Jan 2008 16:23:04 GMT

Hello friends,

I am having a select query and having problems with it.

Below is the code,

BEGIN OF s_rbkp,

belnr LIKE rbkp-belnr,

bukrs LIKE rbkp-bukrs,

gjahr LIKE rbkp-gjahr,

blart LIKE rbkp-blart,

rbstat LIKE rbkp-rbstat,

xblnr LIKE rbkp-xblnr,

END OF s_rbkp,

BEGIN OF s_vttk,

tknum LIKE vttk-tknum,

exti1 LIKE vttk-exti1,

END OF s_vttk.

SELECT belnr bukrs

gjahr blart rbstat

xblnr

INTO TABLE t_rbkp

FROM rbkp

WHERE belnr IN s_belnr

AND bukrs IN s_bukrs

AND gjahr IN s_gjahr

AND blart = 'RF'

AND rbstat = 'A'.

SELECT tknum exti1

INTO TABLE t_vttk

FROM vttk

FOR ALL ENTRIES IN t_rbkp

WHERE exti1 = t_rbkp-xblnr.

I am having problems in the second select query because

exti1 and xblnr do not have the same characteristics.

Error is - When using the addition "FOR ALL ENTRIES IN itab", the fields "EXTI1"

and "T_RBKP-XBLNR" must have the same type and length.

How can I get this issue solved.

Thanks,

Raju..

Error is - When using the addition "FOR ALL ENTRIES IN itab", the fields "EXTI1"

and "T_RBKP-XBLNR" must have the same type and length.

Re: select Querry

Former Member — Mon, 21 Jan 2008 16:48:45 GMT

Create a new field in the internal table and move the values there and use it in the SELECT.

Rob

Re: select Querry

Former Member — Mon, 21 Jan 2008 16:50:06 GMT

THanks Bob Will try.

Raju.

topic Re: select Querry in Application Development and Automation Discussions

select Querry

Re: select Querry

Re: select Querry