Records are getting overwritten in the internal table using Select query.

Hi All,

I have following query :

Loop at i_salesplant.

select mara_{matnr mvke}VKORG mvke_{VTWEG mara}ZZCOEAFE mara_{ZZCOEAFEUOM mvke}ZZALLPOL

into corresponding fields of table i_zallocpol from mara inner join mvke on

mvke_{matnr = mara}matnr

where MARA~zzobjtype = I_ZZOBJTYPE

and MVKE~VKORG = i_salesplant-vkorg

and MVKE~VTWEG = T_VTWEG.

ENDLOOP.

My Que : For example lets say first it selects all the records for Sales Org 1000. Next when you select the records for the Sales Org 2000 the earlier records are getting overwritten.

Please let me know your valuable inputs.

Thanks,

Chandravadan