equipment attributes problem is psa

[Former Member]

Dear gurus,

problem is all about 0equipment_attr, i received errors in logs,

error arises from;

eq number

10000062 to 31.12.9999 start 09.06.2008

10000062 to 09.06.2008 start 30.05.2008.

error message:

The time interval ['20080609'/'20080609'] & (from/to) for the d

records 99 & and 57 & overlaps in characteristic 0EQUIPMENT &.

Whats wrong with that equipment, how can i solve that problem, ican change the data and upload to cube, but need to solve the problem first.

Thanks

[Former Member · Accepted solution]

Hey John,

To extract time-dependent master data correctly, the extract structure of the DataSource must contain the 'DATETO' and 'DATEFROM' fields. The extract structure fields must, in turn, correspond exactly with those of the view from which the data is extracted. Therefore the date fields must already contain the names 'DATETO' and 'DATEFROM' in the view.If the table underlying the view has other field names, these table fields must be assigned to the view fields 'DATETO' and 'DATEFROM' within the view maintenance (SE11).

So, there is a problem in the R3 records. You need to modify it there. You can also modify it in the PSA and upload it. But this will not resolve the problems for ever. If again the same equipment no. is reffered, then it will throw error. So, its better to correct this in R3.

Thanks..

Shambhu

[Former Member]

i have found an oss note about a routine for 0date_from.

[Former Member]

Hi,

Can you tell me the OSS note number. I am facing the same issue.

Thanks.

[Former Member]

Hi Shambu,

I guess there is no problem in R/3 as it is allowed to have data records like this in R/3

EQ1 To 31.12.9999 From 16.06.2008

EQ1 To 16.06.2008 From 10.03.2008

however, when i upload this data to psa it gives error as from and end dates are same in two lines above.

how come?

thanks

jmq

[Former Member]

i guess it happens in all equipments that i have edited.

[Former Member]

thanks shambu,

i could not explain my problem i guess, i have seen why it gives error, but my problem is why it happens in r/3 side? is there a problem in master data record in r3 or a problem in 0equipment that leads to error and how to correct it?

thanks

[Former Member]

eq number

10000062 to 31.12.9999 start 09.06.2008

10000062 to 09.06.2008 start 30.05.2008.

This is because the date interval is overlapping here. In the PSA, for this euipment number, change the start date and end date so that they are mutually exclusive.

Thanks...

Shambhu