topic Re: getting runtime error while using hash table in Application Development and Automation Discussions

getting runtime error while using hash table

Former Member — Mon, 23 Mar 2009 06:11:50 GMT

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.

Re: getting runtime error while using hash table

Sm1tje — Mon, 23 Mar 2009 06:13:52 GMT

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

Re: getting runtime error while using hash table

Former Member — Mon, 23 Mar 2009 06:15:42 GMT

Hi,

In your table u r getting duplicate entry of VBELN.

So check that.

Thanks & Regards,

Anagha

Re: getting runtime error while using hash table

Former Member — Mon, 23 Mar 2009 06:25:43 GMT

Hi Micky,

Then how to solve this....

Re: getting runtime error while using hash table

Sm1tje — Mon, 23 Mar 2009 06:27:57 GMT

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