topic Re: dump error in Application Development and Automation Discussions

dump error

Former Member — Thu, 30 Aug 2007 05:03:26 GMT

Hi experts

I am using the following code for retriving the total sales order stock for the material. but it goes for dump, how to correct this query.

loop at itab1.

select matnr

kalab

KAINS

kaspe

from mska

into

(itab1-matnr , itab1-kalab , itab1-KAINS , itab1-kaspe)

where matnr = itab1-matnr.

modify itab1.

endselect.

endloop.

Pls advise me on the same.

Thanks in advance.

Regards

Rajaram

Re: dump error

Former Member — Thu, 30 Aug 2007 05:10:39 GMT

loop at itab1.

select matnr

kalab

KAINS

kaspe

from mska

into <b>ITAB!</b>

where matnr = <b>u can't pu itab1 value here put some value or selection screen parameters .</b>

modify itab1.

endselect.

endloop.

reward if usefull

Re: dump error

Former Member — Thu, 30 Aug 2007 05:11:23 GMT

hi,

try changing the modify statement to:

modify itab1 index sy-tabix.

regards,

Navneeth K.

Re: dump error

Former Member — Thu, 30 Aug 2007 05:29:55 GMT

good

the where condition that you r given in your select statement is not correct,go through the code and change that accordingly,

go through the dump details properly ,you can understand the detail error.

thanks

mrutyun^

Re: dump error

Former Member — Thu, 30 Aug 2007 05:30:01 GMT

problem is wid modify statement

use sy-tabix

or use

modify wid from addtion

Re: dump error

Former Member — Thu, 30 Aug 2007 05:31:37 GMT

Hi,

What is the dump? Please let us know.

It may be a performance issue. If possible take the table out of loop and join with previous table.

also you are using itab1-matnr in where clause as well as into clause this may be reason for dump.

if u can post the details about the dump, then it will be clear.

Re: dump error

Former Member — Thu, 30 Aug 2007 05:33:39 GMT

your where condition is also not right

as u r fethchig data into itab1-matnr and in the next line u r comparing it

but itab1-matnr wil contain data after the append or modify statement

or tell us that is there any data in itab1-matnr?????

if yes then y r u modifying this in the select statement

chk ur where condtion it wil resolve ur prob

Re: dump error

Former Member — Thu, 30 Aug 2007 05:50:45 GMT

Try this.Reward poits if useful.

data : my_tabix type sy-tabix.

loop at itab1.

clear my_tabix.

my_tabix = sy-tabix.

select matnr

kalab

KAINS

kaspe

from mska

into

(itab1-matnr , itab1-kalab , itab1-KAINS , itab1-kaspe)

where matnr = itab1-matnr.

modify itab1 index my_tabix.

endselect.

endloop.

Re: dump error

Former Member — Thu, 30 Aug 2007 05:51:23 GMT

HI,

short dump may be of 2 reasons

1. the internal table fields order and fields in the select statement which u gave may be of different order.

2. ur selecting data from database table to internal and in where condition u gave internal table field. that internal table field is empty bcoz it doesnt have any data.

check that one also.

Select matnr

kalab

KAINS

kaspe

from mska

into

(itab1-matnr , itab1-kalab , itab1-KAINS , itab1-kaspe)

where matnr = itab1-matnr. // only this statement works if u have data in internal table other wise declare a parameter and compare with matnr in where copndition of select statement as

Select matnr

kalab

KAINS

kaspe

from mska

into

(itab1-matnr , itab1-kalab , itab1-KAINS , itab1-kaspe)

where matnr = p_matnr // parameter declared.

if helpful reward some points.

with regards,

Suresh Aluri.

Re: dump error

Former Member — Thu, 30 Aug 2007 06:21:55 GMT

select matnr

werks

lgort

charg

sobkz

vbeln

posnr

kalab

KAINS

kaspe

from mska

into corresponding fields of table i_mska

for all entries in itab1

where matnr = itab1-matnr.

Please look this query, i think ur first point may be the reason for my case.

this is the order am retriving data but in the table also same order, pls clarify why it goes to dump.

Regards

Rajaram

Re: dump error

Former Member — Thu, 30 Aug 2007 06:26:57 GMT

Hi ,

there are two problems in code.

1. u cannoot use itab1-matnr for select statement(but this is not the reason for dump.)

2. modify to be used needs index or key to be specified always. without that the program goes to dump.

give index or key with modify and the problem is solved.

PLEASE REWARD ME FOR SUCH CLEAR ANSWER IF HELPFUL

Re: dump error

Former Member — Thu, 30 Aug 2007 06:32:32 GMT

SELECT aufnr

baugr

matnr

meins

bdmng

FROM resb

INTO CORRESPONDING FIELDS OF TABLE itab1

FOR ALL ENTRIES IN itab

WHERE aufnr = itab-aufnr.

but this query is working fine, here i have used itab, then why can't we use itab1 in the first case.

how to use modify with index, should we put a loop , pls explain this.

Regards

Rajaram