inner join

hi,

can any one tell me where i went wrong..

if not matnr is initial.

wa_matnrrange-sign = 'I'.

wa_matnrrange-option = 'EQ'.

wa_matnrrange-low = MATNR.

APPEND wa_matnrrange to r_matnrrange.

endif.

• if sales order number is the selection criteria

if not salesorder_no is initial.

if ( not date_from is initial and not date_to is initial ).

wa_daterange-sign = 'I'.

wa_daterange-option = 'BT'.

wa_daterange-low = date_from.

wa_daterange-high = date_to.

APPEND wa_daterange TO r_daterange.

elseif ( not date_from is initial and date_to is initial ).

wa_daterange-sign = 'I'.

wa_daterange-option = 'EQ'.

wa_daterange-low = date_from.

• wa_daterange-high = date_to.

APPEND wa_daterange TO r_daterange.

endif.

select a_{vbeln a}auart b_{posnr c}ettyp

into table t_vbak

from vbak as a

inner join vbap as b

on a_{vbeln = b}vbeln

inner join vbep as c

on b_{vbeln = c}vbeln

where a~vbeln = salesorder_no

and a~erdat in r_daterange

and a~kunnr = partner_number

and b~matnr in r_matnrrange

and b~abgru EQ ' '

and c~etenr = lv_etenr_0001.

there is no syntax error..

here i'm not passing any date,matnr..

there is data in vbak,vbap,vbep against vbeln...but when i debug i dont find any data in t_vbak..

please help me in resolving thhis...

thanks,

Challa.