select statements

[Former Member]

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]

kindly paste also your internal table declaration.

regards,

Mon Magallanes

[Former Member]

hi,

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

use ( ) in inner join conditions

thanks.

[Former Member]

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