Skip to Content
avatar image
Former Member

getting dump SAPSQL_STMNT_TOO_LARGE.

Hello all,

In my report i am calling one FM. in that i nee to pass tcode, date, bname(these all three are range tables). all these 3 range tables formate has, like

sigh = 'I',

option = EQ,

low = value (respective values tcode, date, bname) ,

high = space

Any 2 of these 3 tables contains large no.of records. if i pass like this i am gettin the dump SAPSQL_STMNT_TOO_LARGE.

If i call the same FM from se37 by passing same data, for this i am getting output, but data format like I, BT, Low value & High value.

Plz help on this...

Regards.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 24, 2008 at 08:22 AM

    I think data in your select options are filled only in LOW ..

    U cannot have more than 1500 entries in low .. U can give any range but not only in low ..

    Try to change the select option and fill both LOW and HIGH else restrict your LOW values ...

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 24, 2008 at 08:22 AM

    Hi,

    Create 3 structures and then use the structure for passing to Fm.

    ZZZ_SELECTOPTION Struture:

    SIGN CHAR1 CHAR 1

    OPTION OPTION CHAR 2

    LOW sy-datum

    HIGH sy-datum

    Add comment
    10|10000 characters needed characters exceeded