Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

ABAP Query

Former Member

‎12-05-2006 7:16 AM

0 Kudos

How can we create interactive ABAP Query?

How can we develop secondary lists in an ABAP Query?

3 REPLIES 3

Former Member

‎12-06-2006 8:31 AM

0 Kudos

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

Regards,

Ramki.

prasanthi_chavala
Active Contributor

‎12-18-2006 5:00 AM

0 Kudos

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.

        • Reward helpful answers.