How to write multiple quries in WDDOINIT method .what i wrote is it worng.
where i am doing worng. please see the below code.
method WDDOINIT .
data:
node_sflight type ref to if_wd_context_node,
Itab_sflight type standard table of SFLIGHT.
Itab_sflight1 type standard table of SFLIGHT.
data: begin of i_spfli occurs 0,
carrid type spfli-carrid,
connid type spfli-connid,
end of i_spfli.
select carrid connid from SpFLI into table I_spfli.
select * from SFLIGHT into table Itab_sflight.
for all entries in I_spfli
where carrid = i_spfli-carrid
and connid = spfli-connid.
loop at I_spfli.
read table i_spfli with key carrid = Itab_sflight-carrid.
Itab_sflight = Itab_sflight1.
append Itab_sflight.
clear Itab_sflight.
endloop.
node_sflight = wd_context->get_child_node( name = 'NODE_SFLIGHT' ).
node_sflight->bind_table( itab_sflight ).
endmethod.
Thanks
rama