topic Re: select in Application Development and Automation Discussions

select

Former Member — Mon, 25 Feb 2008 14:51:30 GMT

I would like to create this select statement<br />

select * into lw_temp from p0002 where nachn,vorna like lt_header_appraisee -name .<br />

How we can concatenate vorna and nachn in this statement<br />

??<br />

thanks

Re: select

JozsefSzikszai — Mon, 25 Feb 2008 14:54:12 GMT

hi,

you could use FOR ALL ENTRIES, but in this case nachn and vorna have to be separate fields in your internal table:

select *

into lw_temp

from pa0002

FOR ALL ENTRIES IN lt_header_appraisee

where nachn = lt_header_appraisee-nachn

and vorna = lt_header_appraisee -vorna.

hope this helps (some)

Re: select

Former Member — Mon, 25 Feb 2008 14:56:42 GMT

Split lt_header_appraisee -name into nachn and vorna

and use in where condition.

split lt_header_appraisee -name at space into v_nachn v_vorna.

Re: select

Former Member — Mon, 25 Feb 2008 17:24:02 GMT

Srinivas, your answer is most likely correct. But here's my question...

What if it is a compound last name? Depending for wich country he is working this might not be the right way to do it, as there are last names like De la Rosa or Von Saperstein

I think Cartman's choice is better, he need to find a way to separate both fields

Re: select

Former Member — Tue, 26 Feb 2008 08:27:36 GMT

In fact I have a var name which contain last name and vorname (exp met choco jean) and I have another variable which contain the last name (met choco) but I need each var separately (last name ok and vorname alone)? can you give me a function that extract a substring from another in abap. thanks in advance.

Re: select

Former Member — Thu, 15 May 2008 15:52:23 GMT

resolved