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: 

Dynamic where condition

Former Member
0 Kudos

Hi all,

I am using dynamic where condition in an internal table as shown below.

SELECT * FROM ztprppk10

INTO CORRESPONDING FIELDS OF TABLE ldt_ztprppk10

WHERE eflg EQ lcf_e

AND err GE lcf_5

AND rflg EQ space

AND dflg EQ lcf_c

AND bwart EQ lcf_202

AND (ldt_selection).

The internal table contains a filed of type c and maximum length of 72.The probelm is when the lines of internal table exceeds 1000(in my senario it was around 6000 lines), i am getting dump. But if the number of lines less than 1000 like 600 i am able to execute the program.

Pls tell what could be the probelm.

Regards,

Sunil

2 REPLIES 2

Former Member
0 Kudos

Hi,

Take a look at and SAP Note 635318 regarding SIZE LIMIT issues.

Regards

andreas_mann3
Active Contributor
0 Kudos

Sunil,

6000 lines in a where-clause ?!

-that's brutal for the DB.

-> so plz use <i>for all entries</i>

or <i>loop at ldt_selection</i>

Andreas