getting runtime error while using hash table

[Former Member]

Hi,

I have defined an internal table as hash with unique key.But while executng the prog. its giving a dump saying "There is already a line with the same key." My code is

data: begin of wa_rkrp,

vbeln like vbrk-vbeln,

fkdat like vbrk-fkdat,

fkart like vbrk-fkart,

kunag like vbrk-kunag,

knumv like vbrk-knumv,

inco1 like vbrk-inco1,

spart like vbrk-spart,

netwr like vbrk-netwr,

mwsbk like vbrk-mwsbk,

uepos like vbrp-uepos,

werks like vbrp-werks,

lgort like vbrp-lgort,

end of wa_rkrp.

data lt_rkrp like hashed table of wa_rkrp

with unique key vbeln

with header line.

select vbrk~vbeln

vbrk~fkdat

vbrk~fkart

vbrk~kunag

vbrk~knumv

vbrk~inco1

vbrk~spart

vbrk~netwr

vbrk~mwsbk

vbrp~uepos

vbrp~werks

vbrp~lgort

into table lt_rkrp

from vbrk inner join vbrp

on vbrp_{vbeln = vbrk}vbeln

where vbrk~fkdat in s_fkdat

and vbrk~bukrs eq p_bukrs.

Any problem in my select query? or with my table deifnition.

Can anyone pls suggest how to rectify this.

[Sm1tje]

Unique key VBELN!

So after select, there are more than ONE entries with same VBELN!

which makes sense, since VBRP also has POSITIONS (items). So ONE VBELN can have more than ONE items (POSNR).

Edited by: Micky Oestreich on Mar 23, 2009 7:14 AM

[Former Member]

Hi Micky,

Then how to solve this....

[Sm1tje]

define a unique key VBELN and POSNR.

data lt_rkrp like hashed table of wa_rkrp
with unique key vbeln posnr
with header line.

BTW: Stop using the header line!!! Outdated!!

Edited by: Micky Oestreich on Mar 23, 2009 7:28 AM

[Former Member]

Hi,

In your table u r getting duplicate entry of VBELN.

So check that.

Thanks & Regards,

Anagha