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: 

run time error

sastry_gunturi
Active Participant
0 Kudos

My program is ending with run time error..... SAPSQL_STMNT_TOO_LARGE what does it mean.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Post your SELECT statement here

The WHERE clause could be too large or you have included lots of large ranges.

9 REPLIES 9

Former Member
0 Kudos

Hi,

Just Check the SQL statement,I mean the SELECT Query you have written,

Runtime Error is occuring from that Section.

According to SAP it occurs duu to System is unable to handle the Number of Objects you have selected through the SELECT Query.Diviode the data into smaller chunks and Seclect accordingly.

The ABAP runtime environment does not support large WHERE conditions (> 64 KB).

Regards,

Sujit

Former Member
0 Kudos

Post your SELECT statement here

The WHERE clause could be too large or you have included lots of large ranges.

0 Kudos

Here is my select query ...

SELECT LIPS~VBELN

LIPS~POSNR

LIKP~LFART

LIPS~WERKS

LIPS~MATNR

LIPS~CHARG

LIPS~LFIMG

LIPS~BWART

LIPS~VKGRP

LIPS~MATKL

LIKP~KUNNR

LIPS~VRKME

LIKP~KUNAG INTO TABLE GT_LIPS

FROM ( LIPS INNER JOIN LIKP

ON LIPSVBELN = LIKPVBELN )

WHERE LIPS~VBELN IN R_VBELN AND

LIKP~LFART IN ('YLF','ZLSB','ZLSR') AND

LIPS~WERKS = P_PLANT AND

LIPS~SPART = '17' AND

LIPS~VTWEG = '9E' AND

LIPS~ERDAT GE GV_START AND

LIPS~ERDAT LE GV_END AND

LIPS~LFIMG > 0.

0 Kudos

R_VBELN is probably filled in somewhere else in the program and has too many entries for the database to handle. You can correct this by using another JOIN or FOR ALL ENTRIES.

Rob

former_member181962
Active Contributor
0 Kudos

Hi Karthik,

Check SAP Note: 434625.

also see this thread:

http://www.sapfans.com/forums/viewtopic.php?p=118964&sid=40cc28887cb425484f244922868682b5

Regards,

ravi

Former Member
0 Kudos

Check the SELECT statement.

You might have moving the data into Workarea instead of table.

change SELECT

FROM

INTO TABLE

WHERE conditions.

Regards

Kannaiah

Former Member
0 Kudos

Hi kratik,

This has occured because the number objects selected by the selection screen are not handled by the system.

Regards

Sravanthi.

Former Member
0 Kudos

Hi Karthik,

Are you using select-options, if that is the case then 'IN' statement of your select query used has a limitation that if the no. of entries are large ( may be more than 3000 ) then you

will get a short dump .

With luck,

Pritam.

former_member181995
Active Contributor
0 Kudos

Karthik,

Just refer:

this is exactly same what you are facing.

Amit.