Dynamic where condition

[Former Member]

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

[Former Member]

Hi,

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

Regards

[andreas_mann3]

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