topic Re: Dynamic where condition in Application Development and Automation Discussions

Dynamic where condition

Former Member — Thu, 06 Jan 2005 06:11:29 GMT

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

Re: Dynamic where condition

Former Member — Thu, 06 Jan 2005 07:01:38 GMT

Hi,

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

Regards

Re: Dynamic where condition

andreas_mann3 — Thu, 06 Jan 2005 11:08:27 GMT

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