topic DUMP in Select in Application Development and Automation Discussions

DUMP in Select

Former Member — Tue, 02 Dec 2008 12:39:00 GMT

Hi All,

When i execute the below select query it goes for a dump and i have given the dump analysis also. Please tell me what is going wrong?

data: lc_matnr like mara-matnr,

lc_equnr like afih-equnr.

select single matnr into lc_matnr from equi

where equnr = lc_equnr.

DUMP:

Data type "EQUI" was found in a newer version than required.

*Error analysis:*

The data type "EQUI" was reloaded from the database while the program

was running.

However, the system found a version of the type that was newer than

the one required.

Re: DUMP in Select

Former Member — Tue, 02 Dec 2008 12:41:05 GMT

define like this

data: lc_equnr like EQUI-equnr.

Regards,

Ajay

Re: DUMP in Select

Former Member — Tue, 02 Dec 2008 12:43:47 GMT

hi, do like this

data: lc_matnr like mara-matnr,

lc_equnr like equi-equnr.

select single matnr into lc_matnr from equi

where equnr = lc_equnr.

thanks

Re: DUMP in Select

Former Member — Tue, 02 Dec 2008 12:44:06 GMT

Hi,

Both the fields share the same dataelement EQUNR char 18. This could not be the problem.

Thanks,

Srinath S

Re: DUMP in Select

Former Member — Tue, 02 Dec 2008 12:44:19 GMT

Hi Srinath,

Just check for the data elements for afih-equnr and equi-matnr.

Are they same ?

Regards,

Nitin.

Re: DUMP in Select

ThomasZloch — Tue, 02 Dec 2008 12:46:07 GMT

Sounds like there was a change to table EQUI imported into the system while your program was running. Did you try running it again, does the error still occur?

Thomas

Re: DUMP in Select

Former Member — Tue, 02 Dec 2008 12:47:23 GMT

Hi,

lc_equnr should have some value ( either through parameter on internally in the program ) as u r using lc_equnr in where condition.

data: lc_matnr like mara-matnr,

lc_equnr like afih-equnr value 'XYXY'.

select single matnr into lc_matnr from equi

where equnr = lc_equnr.

Re: DUMP in Select

Former Member — Tue, 02 Dec 2008 12:47:49 GMT

Please have look at the error analysis... it says some thing as newer version found while reloading... but when i checked the versions of the table EQUI there is no new change has happened from past one year....

Re: DUMP in Select

Former Member — Tue, 02 Dec 2008 12:49:50 GMT

Try

data: lc_matnr like mara-matnr,
lc_equnr like afih-equnr.

select single matnr into (lc_matnr) from equi
where equnr = lc_equnr.

Re: DUMP in Select

Former Member — Tue, 02 Dec 2008 19:05:53 GMT

I took the same code from the question (post),

When i compiled it and executed, it ran successfully.

Am in ECC 6.0

Regards

Raj

Re: DUMP in Select

Former Member — Tue, 02 Dec 2008 19:14:47 GMT

Did you try Thomas' suggestion - run it again?

Rob

Re: DUMP in Select

Former Member — Tue, 02 Dec 2008 19:33:23 GMT


> Both the fields share the same dataelement EQUNR char 18. This could not be the problem.

EQUNR and MATNR do not share the same data element. They do not even share the same domain. What's more, the two domains do not use the same converision exit. I'm not sure this is the source of the problem, but you might want to look into it.

Rob

Re: DUMP in Select

Former Member — Tue, 02 Dec 2008 20:09:52 GMT

I think he is saying that about afih-equnr and equi-equnr; as someone asked him to change the variable to equi-equnr.

But surely it is a one time issue, and should be fine if he run it again.

Re: DUMP in Select

Former Member — Tue, 02 Dec 2008 20:24:35 GMT

That's waht I thought at first, but the different conversion exits made me suspicious. On the other hand, if that's the problem, then it should probably just not find a matching record. Re-running it should be the first thing to do.

Rob

Re: DUMP in Select

Former Member — Wed, 03 Dec 2008 04:25:25 GMT

I meant EQUNR field of AFIH and EQUI tables share the same dataelement.

Re: DUMP in Select

Former Member — Wed, 03 Dec 2008 04:33:19 GMT

Hi All,

Thanks for your help.

As suggested I ran the program several times but always it goes for a dump. Later i copied the program to new one, there everything is working fine.

The surprise is still the old program is going for dump and the copied program is working fine(Both has the same code) but i dont know the reason why it is happening.

But at last the issue is solved.

Once again i thank all of you for the ehlp.

Thanks,

Srinath S