topic Re: dump with BSEG table in Application Development and Automation Discussions

dump with BSEG table

Former Member — Thu, 09 Jan 2014 13:25:00 GMT

i am facing dump with this select query

SELECT bukrs

belnr

gjahr

buzei

shkzg

dmbtr

vorgn

ktosl

vbel2 " Sales Document Number

matnr

menge

meins

ebeln

ebelp

xref3

FROM bseg

INTO TABLE i_bseg

WHERE bukrs EQ p_bukrs

AND belnr IN r_belnr

AND augdt EQ c_date

AND hkont EQ g_account.

suspecting that r_belnr[] contain 16000 entry due to dump DBIF_RSQL_INVALID_RSQL is occur .

Re: dump with BSEG table

mariano_gallicchio2 — Thu, 09 Jan 2014 13:30:33 GMT

That's the problem.

r_belnr contains many entries for a select option.

You should try to do a FOR ALL ENTRIES.

Re: dump with BSEG table

Former Member — Thu, 09 Jan 2014 13:34:51 GMT

Check this

http://scn.sap.com/community/abap/blog/2012/03/26/the-answer-to-the-question-so-why-do-i-get-a-shortdump-when-i-enter-lots-of-select-options

Re: dump with BSEG table

Former Member — Thu, 09 Jan 2014 13:40:48 GMT

Hi,

Use the move-corresponding in table i_bseg!

Check the time of executing the statement! it is taking time to execute 16000 accounting docs, need to check the secondary indexes as per your requirement.

Rg, Kiran

Re: dump with BSEG table

Former Member — Thu, 09 Jan 2014 13:43:53 GMT

A range table have a limit for number of data (approx. 5000 you can consider). You can avoid this using any of this:

1.) Use for all entries in place of range table.

2.) Packet data selection also possible for same select query. Add keyword 'PACKAGE SIZE n' in select statement.

Cheers,

Prakash