on 06-13-2008 1:39 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
i have found an oss note about a routine for 0date_from.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
i guess it happens in all equipments that i have edited.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
61 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.