help in dump

[Former Member]

hi,

i do this select and when i have in range table (pro_tab) lot of recoreds

above 1000 i have dump .

how can i avoid that?

SELECT dimybproject COUNT(*) AS cnt

FROM /bic/0czempl

INTO CORRESPONDING FIELDS OF TABLE it_em

WHERE dim0calmonth GE res_per

AND dim0calmonth LE st_date

AND dimybproject IN pro_tab

GROUP BY dimybproject.

Regards

[Former Member]

Hello,

You need to change ur select statment like this.

loop at pro_tab.
SELECT dimybproject COUNT(*) AS cnt
FROM /bic/0czempl
INTO CORRESPONDING FIELDS OF TABLE APPENDIND it_em " CHECK HERE
WHERE dim0calmonth GE res_per
AND dim0calmonth LE st_date
AND dimybproject EQ pro_tab-low " Check here
GROUP BY dimybproject.
endloop.

[Sm1tje]

the only way to avoid this is to limit the number of entries in your select options.

[Former Member]

ranges or select options cannot have a lot of records in low ..

pro_tab-low ..

U can have them in a range ..

say from 1 to 100000 ... but cannot have values only in low..

If possible give the values in a range ..

[Former Member]

Hi,

avoid LE, GE

handel them after selection, no of records u r saying is not too much it should work with it, try to find out other cause of the dump .

Regards

Bikas

[Former Member]

hi,

Add Package size in your select statement.

so your select query will fatch the data into packages.

[Former Member]

Hello,

You need to change ur select statment like this.

loop at pro_tab.
SELECT dimybproject COUNT(*) AS cnt
FROM /bic/0czempl
INTO CORRESPONDING FIELDS OF TABLE APPENDIND it_em " CHECK HERE
WHERE dim0calmonth GE res_per
AND dim0calmonth LE st_date
AND dimybproject EQ pro_tab-low " Check here
GROUP BY dimybproject.
endloop.

[Former Member]

Thanks Vasanth ,

how i write this commend right?

INTO CORRESPONDING FIELDS OF TABLE APPENDIND

Regards

[Former Member]

Hello,

Sorry, Change the syntax like this.

loop at pro_tab.
SELECT dimybproject COUNT(*) AS cnt
FROM /bic/0czempl
INTO CORRESPONDING FIELDS OF  APPENDING TABLE it_em " CHECK HERE
WHERE dim0calmonth GE res_per
AND dim0calmonth LE st_date
AND dimybproject EQ pro_tab-low " Check here
GROUP BY dimybproject.
endloop.

Cheers,

Vasanth

[Former Member]

Hi,

Thanks it work but the problem that it don't to count

for employee .

the table have 2 field cnt is emplyee

project cnt

e0011 2

e0022 5

what i miss?

Regards

[Former Member]

Hi,

Its better to debug the code. Put a breakpoint at the select statement and check.

See if u can give any other conditions for the selection criteria.

According to my knowledge there wont be dumps for jus 1000 records. when we had this kind of situation the records were crossing 750000 or so entries. There were some select queries where in the condition had not been mentioned accordingly..so corrected those mistakes n it was all fine.

Hope this small piece of info helped u....

Regards,

Ramya