01-06-2005 6:11 AM
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
01-06-2005 7:01 AM
01-06-2005 11:08 AM
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