Skip to Content
author's profile photo Former Member
Former Member

History of all the installations for a particular equipment

Hello,

How to get the installations with history (with dateFrom dateTo) for a particular equipment.

I have found one thread that finds the data the reverse way:

Query

Can anyone please help to help for the following points....

does the reverse way gives the correct data? I am doubtful because I don't know how the LOGIKNR in the equipment tables work

Which dates (for the Installation) can we use to decide the validity range? (movein, moveout?)

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Jan 08, 2008 at 06:13 PM

    I think the data you are looking for is in the tables EASTL and EGERH.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2008 at 06:16 PM

    Thanks Srinivas,

    But can you help me finding out more about the logiknr?

    are you sure the view will give me the information I am looking for?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2008 at 06:27 PM

    Thanks, But I was looking if the logiknr can be safely used here.

    Sorry if the question is silly, I am new to this area.

    I need to know if a logiknr is assigned to one and only one eqnr, and also vice versa.

    Please let me know if I am missing here something.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2008 at 07:35 AM

    At some rare places I am seeing the logiknr assigned to different equipments at different date intervals.

    Also some places, I am seeing equipments having different logiknr at different date intervals.

    Seems the data could be retrieved but there is a chance that assignment is not correct for the history records.

    Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.