01-21-2008 4:23 PM
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.
01-21-2008 4:48 PM
Create a new field in the internal table and move the values there and use it in the SELECT.
Rob
01-21-2008 4:48 PM
Create a new field in the internal table and move the values there and use it in the SELECT.
Rob
01-21-2008 4:50 PM