select

[Former Member]

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

[JozsefSzikszai]

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)

ec

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

resolved