Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Short dump on bseg table

Former Member
0 Kudos
306

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

15 REPLIES 15

Former Member
0 Kudos
145

use corresponding fields of table it_bseg.. and check.

Former Member
0 Kudos
145

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

0 Kudos
145

no way ...tell me which field ..i have all fields ..its correct

Former Member
0 Kudos
145

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.

Former Member
0 Kudos
145

Hi,

Check the fields in your internal table. It seems your internal table is not compatible with your select query.

Regards

Abhijeet

ThomasZloch
Active Contributor
0 Kudos
145

The section "error analysis" of the short dump provides more detail. Please paste this here.

Thomas

Former Member
0 Kudos
145

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

0 Kudos
145

there is no sysntax problem ..every thg is correct here

0 Kudos
145

Hi Vijay,

Paste your internal table declaration and the select statement from the program.Just Copy and Paste

Thanks

Sudharshan

Former Member
0 Kudos
145

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!!

Former Member
0 Kudos
145

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.

0 Kudos
145

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

0 Kudos
145

and u need mor clarification

Refer OSS notes 374079 and 358282

Regards,

K.S.Kannan

0 Kudos
145

>

> 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

Former Member
0 Kudos
145

not answered