DUMP in Select

[Former Member]

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.

[Former Member]

define like this

data: lc_equnr like EQUI-equnr.

Regards,

Ajay

[Former Member]

Hi,

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

Thanks,

Srinath S

[Former Member]

>

> 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

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Srinath,

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

Are they same ?

Regards,

Nitin.

[Former Member]

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....

[Former Member]

Did you try Thomas' suggestion - run it again?

Rob

[ThomasZloch]

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

[Former Member]

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.

[Former Member]

Try

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

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

[Former Member]

Hi

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

[Former Member]

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