03-23-2009 6:11 AM
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 vbrpvbeln = vbrkvbeln
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.
03-23-2009 6:13 AM
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
03-23-2009 6:25 AM
03-23-2009 6:27 AM
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
03-23-2009 6:15 AM
Hi,
In your table u r getting duplicate entry of VBELN.
So check that.
Thanks & Regards,
Anagha