topic Re: ABAP Query in Application Development and Automation Discussions

ABAP Query

Former Member — Tue, 05 Dec 2006 07:16:48 GMT

How can we create interactive ABAP Query?

How can we develop secondary lists in an ABAP Query?

Former Member — Wed, 06 Dec 2006 08:31:39 GMT

Please have a look at SQ01 & SQVI; you will some thoughts about it.

Regards,

Ramki.

Former Member — Wed, 06 Dec 2006 08:34:03 GMT

Please check the following thread

prasanthi_chavala — Mon, 18 Dec 2006 05:00:45 GMT

Hi,

By using event handlers we can create interactive abap queries.

Here is the sample code for creating secondary lists:

Tables: spfli.

Start-of-selection.

write: 'Basic-list:',sy-lsind.

Data itab like table of spfli with header line.

At line-selection.

case sy-lsind.

when 1.

select * from spfli into table itab.

loop at itab.

write: / itab-carrid,itab-connid.

endloop.

when 2.

write: 'list-level :',sy-lsind.

select.........

..........ur required code...

when others.

Leave program.

endcase.

Sy-lsind: It is a s/y variable which will carry the current list level.

This sy-lsind hold basic list which hold 20 sub-lists.

By seeing this code u will get some idea on creating secondary lists.

Cheers,

Prasanthi.