Select FOR ALL ENTRIES statement cannot get duplicates entries

Hi all,

t_yxapy_fields consist of

inty field

0001 kostl

0002 perid

0008 ansal

0008 preas

0008 trfst

The following is the code for me to transfer the contents of t_yxapy_fields into t_pa_fields.

SELECT dbtab

FROM t777d

INTO TABLE t_pa_fields

FOR ALL ENTRIES IN t_yxapy_fields

WHERE infty = t_yxapy_fields-infty.

And t_pa_fields just ended up with

field infty

pa0001

pa0002

pa0008

Question:The first table have 3 similar infotype 0008 but the result table only have one pa0008. I need to filled up acordingly as what table 1 have. I need another 2 pa0008 in my 2nd table. What is wrng with my Select for all entries statement here?

Edited by: Siong Chao on Mar 27, 2010 10:35 AM