Skip to Content
0
Former Member
Aug 30, 2007 at 08:24 AM

multiple select quries will in WDDOINIT METHOD

12 Views

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