topic select statements in Application Development and Automation Discussions

select statements

Former Member — Wed, 11 Feb 2009 02:11:18 GMT

hi experts,

why this select statement is going to run time erroer...

[ select vbrk_{kunag vbrk}fkart vbrk_{fkdat vbrk}waerk vbrk_{bukrs vbrk}kurrf

vbrk_{xblnr vbrk}expkz vbrk~knumv

vbrp_{matnr vbrp}prodh vbrp_{arktx vbrp}vbeln vbrp_{netwr vbrp}fkimg vbrp~vrkme

kna1~name1

into table itab1 from vbrp

inner join vbrk on vbrp_{vbeln eq vbrk}vbeln

inner join kna1 on vbrk_{kunag eq kna1}kunnr

where vbrk~bukrs = so_bukrs and

vbrp~matnr in so_matnr and

vbrk~fkart in so_fkart and

vbrk~fkdat in r_date and

vbrk~sfakn eq '' and "cancel bill doc.

vbrk~fksto eq '' and "cancel status

vbrp~fkimg ne '0.00'. ]

Thanks & Best Regards,

Praveen.

Former Member — Wed, 11 Feb 2009 02:51:39 GMT

kindly paste also your internal table declaration.

regards,

Mon Magallanes

Former Member — Wed, 11 Feb 2009 03:05:51 GMT

hi,

check that the order of select is same as in the internal table iab1.

use ( ) in inner join conditions

thanks.

Former Member — Wed, 11 Feb 2009 03:26:26 GMT

Hi,

check this statement in your query whether u properly assigned or not..

vbrk~sfakn eq '' and "cancel bill doc.

vbrk~fksto eq '' and "cancel status

vbrp~fkimg ne '0.00'.

Regards

Kiran

Edited by: Kiran Saka on Feb 11, 2009 4:26 AM