topic Re: Partial field selection in SELECT in Application Development and Automation Discussions

Partial field selection in SELECT

Former Member — Thu, 07 Feb 2008 19:32:59 GMT

Can we do a partial field selection in ABAP SELECT like

For example -

select department first 3 characters < DEPT+0(3)>

from emp_table

where employee first name start with 'A' < EMP_NAME+0(1) = 'A'>

for listing dept first 3 char for Emp name starting with 'A' . How we can implement in ABAP ?

Can we do this without putting in to an internal table ( that is in a single select statement ) ?

Thanks

Mano

Re: Partial field selection in SELECT

former_member156446 — Thu, 07 Feb 2008 19:39:35 GMT

select * from table 
      into itab
      where emp+(3) like 'ABC'  "<< employe starting with ABC.
        and  id+(2)  like '12'.     "<< id number starting with 12.

or you can create a range and use that..

         where emp in ra_emp and
                   id in ra_id.

is it right Rob?

Re: Partial field selection in SELECT

Former Member — Thu, 07 Feb 2008 19:47:32 GMT

Thank you of the answer .. if I want to select only the first 3 character of department , what will be the selection look like ?

Re: Partial field selection in SELECT

Former Member — Thu, 07 Feb 2008 20:19:04 GMT

Use LIKE in the WHERE.

Rob

Re: Partial field selection in SELECT

former_member156446 — Thu, 07 Feb 2008 20:35:17 GMT

you cant get only first three characters of the department... you can select the data based on the first three characters (using offset as per my previous post).. as Rob suggested we need to use LIKE in the where Clause..

thanks Rob.

Re: Partial field selection in SELECT

Former Member — Thu, 07 Feb 2008 20:45:52 GMT

OK - do you mean any department that has 'A' anywhere in the first three characters?

Rob