Skip to Content
0
Former Member
Jul 07, 2009 at 03:47 PM

For all entries Where condition character length partilally has to be used

1661 Views

Hi,

I need to fetch all the data reocrds of one internal table into the other with the condition that in one of the field of first internal table only partial length of the character has to be used as a where condition.

Example:

Select xxxx

yyyyy

zzzzz

into it_tab2

for all entries in itab1

where field2 = itab1-field1(4).

where field1 of itab1 has length of 8 and field2 belongs to itab2.

As it throws the error msg :

it will ignore the length restriction mentioned in where condition of the for all entries