2008 Sep 24 9:16 AM
I am Getting Short Dump at this statement
SELECT bukrs
belnr
gjahr
buzei
kostl
hkont
lifnr
prctr
FROM bseg
INTO TABLE it_bseg
WHERE bukrs IN s_bukrs
AND belnr IN r_belnr
AND gjahr IN r_gjahr
AND prctr IN s_prctr.
Short dump Error :
DBIF_RSQL_INVALID_RSQL
RSQL error 0 when accessing table "BSEG ".
Please Help
2008 Sep 24 9:17 AM
2008 Sep 24 9:20 AM
Hi Vijay,
One of your field in internal table has spelled wrongly,check the fields one by one with the fields used in SELECT statement.
Thanks
Sudharshan
2008 Sep 24 9:44 AM
no way ...tell me which field ..i have all fields ..its correct
2008 Sep 24 9:21 AM
Whats the structure if IT_BSEG?
It should have following fileds in the same order.
bukrs
belnr
gjahr
buzei
kostl
hkont
lifnr
prctr
Otherwise use INTO CORRESPONDING FILEDS OF IT_BSEG
in the select query.
2008 Sep 24 9:22 AM
Hi,
Check the fields in your internal table. It seems your internal table is not compatible with your select query.
Regards
Abhijeet
2008 Sep 24 9:22 AM
The section "error analysis" of the short dump provides more detail. Please paste this here.
Thomas
2008 Sep 24 9:25 AM
Hi Vijay,
Make sure that your internal table it_bseg has all the fields and also in the same order you are selecting them.
Regards,
Chandra Sekhar
2008 Sep 24 9:45 AM
2008 Sep 24 9:47 AM
Hi Vijay,
Paste your internal table declaration and the select statement from the program.Just Copy and Paste
Thanks
Sudharshan
2008 Sep 24 9:26 AM
Hi,
To my idea you might have missed some field in your structure declaration check it out back or else post the error analysis.
Cheers!!
2008 Sep 24 9:44 AM
Hi,
First you have to declare itab properly and see the following code.
tables:bseg.
data:begin of itab occurs 0,
bukrs type bukrs,
belnr type belnr_d,
gjahr type gjahr,
buzei type buzei,
kostl type kostl,
hkont type hkont,
lifnr type lifnr,
prctr type prctr,
end of itab.
selection-screen begin of block bk1 with frame title text-001.
select-options:so_bukrs for bseg-bukrs,
so_belnr for bseg-belnr,
so_gjahr for bseg-gjahr,
so_prctr for bseg-prctr.
selection-screen end of block bk1.
select bukrs belnr gjahr buzei kostl hkont lifnr prctr from bseg
into table itab where bukrs in so_bukrs
and belnr in so_belnr and gjahr in so_gjahr and prctr in so_prctr.
loop at itab.
write 😕 itab-bukrs,
itab-belnr,
itab-gjahr,
itab-buzei,
itab-kostl,
itab-hkont,
itab-lifnr,
itab-prctr.
endloop.
2008 Sep 24 9:48 AM
yaar my code works well if we specify vendor numbers in selectio screen
am getting short dump only if i specify '*' in vendor number space
2008 Sep 24 10:23 AM
and u need mor clarification
Refer OSS notes 374079 and 358282
Regards,
K.S.Kannan
2008 Sep 24 2:32 PM
>
> yaar my code works well if we specify vendor numbers in selectio screen
> am getting short dump only if i specify '*' in vendor number space
Well, I don't see the vendor in your SELECT. I suspect that the problem is that the SELECT is returning too much data or running too long. If you post more details of the dump (the exact error), it would help.
Rob
2010 Feb 02 5:20 AM