2006 Nov 02 11:17 AM
hi everybody
im retrieving data from 2 tables febre and febep
data: begin of itab occurs 0,
kukey like febep-kukey,
esnum like febep-esnum,
epfov like febep-epvoz,
kfmod like febep-kfmod,
kwbtr like febep-kwbtr,
pakto like febep-pakto,
partn like febep-partn,
valut like febep-valut,
vgext like febep-vgext,
vgint like febep-vgint,
vozei like febep-vozei,
vwezw like febre-vwezw,
absnd like febko-absnd,
end of itab.
select
akukey aesnum
aepvoz akfmod akwbtr apakto
apartn avalut avgext avgint
a~vozei
b~vwezw
into corresponding fields of table itab
from febep as a
inner join febre as b
on akukey = bkukey
and aesnum = besnum
where a~epvoz = 'H'.
Its giving me a short dump when its being executed, does anybody know how i can avoid this dump?
when im retrieving fewer fields, im not getting the dump but wen i retrieve all the fields , the dump occurs
can sombody help me on that?
2006 Nov 02 11:22 AM
hi Anjali,
In the internal table declaration, you have epfov fields, where as in statement you gave epvoz.
I think that is the problem
regards
Chandra.
Note: please reward if helpful.
2006 Nov 02 11:19 AM
2006 Nov 02 11:20 AM
2006 Nov 02 11:22 AM
Hi,
Your code is working perfactly fine.
NO issue with it.
WHich dump u r getting ?
2006 Nov 02 11:22 AM
hi Anjali,
In the internal table declaration, you have epfov fields, where as in statement you gave epvoz.
I think that is the problem
regards
Chandra.
Note: please reward if helpful.
2006 Nov 02 11:23 AM
absnd field declared in itab but not used, try remove and then check.
2006 Nov 02 11:28 AM
thanks!
yea, the error was the mistyping of the field epvoz! i really could not identify the error
thanks a lot
2006 Nov 02 11:34 AM
HI Anjali,
just after the code make add these lines in case if there are any more errors...
IF SY-SUBRC <> 0.
MESSAGE <WHATEVER YOU WNAT TO DO IF ERROR>
ENDIF.
Regards,
Arnab.
2006 Nov 02 11:23 AM
hi sia,
goto st22 and on user check the dump ..
from the overview u 'll get a list of occurances ..
ser no 1- 20
in that check out 3, 4, 7 and 8 ..
regards,
Vjay
2006 Nov 02 11:24 AM
Hi Anjali,
there in no problem in the given code check with other code.
i checked ur code in my system, iam getting the output.
-Anu.
2006 Nov 02 11:25 AM
Hi,
try like this...
select
akukey aesnum
aepvoz akfmod akwbtr apakto
apartn avalut avgext avgint
a~vozei
b~vwezw
c~absnd
into corresponding fields of table itab
from febep as a
inner join febre as b
on akukey = bkukey
and aesnum = besnum
inner join febko as c
on akukey = ckukey
where a~epvoz = 'H'.
Madhavi
2006 Nov 02 11:26 AM
Hi anjali,
Try while changing the field 'epfov' to 'epvoz' in the internal table itab.
or try with 'INTO TABLE ITAB' option.
Regards
Satya.
2006 Nov 02 11:26 AM
data: begin of itab occurs 0,
kukey like febep-kukey,
esnum like febep-esnum,
*epfov like febep-epvoz,
<b>epfoz like febep-epvoz,</b>
kfmod like febep-kfmod,
kwbtr like febep-kwbtr,
pakto like febep-pakto,
partn like febep-partn,
valut like febep-valut,
vgext like febep-vgext,
vgint like febep-vgint,
vozei like febep-vozei,
vwezw like febre-vwezw,
absnd like febko-absnd,
end of itab.
do this and let us know ..
2006 Nov 02 11:31 AM
anjali,
in case of a short dump, to know which statement exactly in the program triggered the dump, just search for ---> in the dump...it will show the line which triggered the dump...