run time error

[SG141]

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

[Former Member]

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]

Post your SELECT statement here

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

[SG141]

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 LIPS_{VBELN = LIKP}VBELN )

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.

[Former Member]

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

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]

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]

Hi kratik,

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

Regards

Sravanthi.

[Former Member]

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

Karthik,

Just refer:

this is exactly same what you are facing.

Amit.