Short dump on bseg table

[Former Member]

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

[Former Member]

use corresponding fields of table it_bseg.. and check.

[Former Member]

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

[Former Member]

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

[Former Member]

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]

Hi,

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

Regards

Abhijeet

[ThomasZloch]

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

Thomas

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Vijay,

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

Thanks

Sudharshan

[Former Member]

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]

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.

[Former Member]

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

[Former Member]

and u need mor clarification

Refer OSS notes 374079 and 358282

Regards,

K.S.Kannan

[Former Member]

>

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

not answered