topic Re: reports in Application Development and Automation Discussions

reports

Former Member — Mon, 14 Jan 2013 13:26:11 GMT

suppose I have 100 entries of student information in my database , so I want to write a select query such that if I press A* then all the entries of student's name starting with char A...... should display, can anyone suggest the select query.

Re: reports

Former Member — Mon, 14 Jan 2013 13:31:17 GMT

Hi, you can use LIKE statement in your select

for example:

SELECT * FORM ABC WHERE USER_ID like "A%"

Re: reports

Former Member — Mon, 14 Jan 2013 13:32:56 GMT

This is a very basic concept...you would supply a parameter or select-options statement for the name (last name ?). the user would input A* and execute.. Your Open SQL would do a select where last name eq (for parameters) or IN (for select options), into an internal table. You would then loop over that table and write the content or use SALV (see demo programs named like SALV*) to display what you had retrieved.

However, note that these forums are not intended to be basic ABAP training classes. There are many good materials on how to wite ABAP code, available from a variety of sources, including SAP Press.

Re: reports

former_member491621 — Mon, 14 Jan 2013 13:39:15 GMT

Hi Kaladhar,

You can use the below code

SELECT data

from DBTAB

into ITAB

WHERE <field> LIKE var.

where var = 'A*' or 'A%'