Skip to Content
0
Former Member
Jul 03, 2009 at 07:45 AM

Find Latest Active Equipment number

302 Views

friends,

I am looking for a way to find latest active equipment number (EQUNR) in the system.

I can fetch multiple equipments agaist a serial number from table EQUI. After getting multiple equipments I am sorting based on "Changed on" <aedat> field and then delete the non recent entires.

I am looking for another way if there exists any. I mean do we have anything called deletion indicator or something like this to differentiate between recent and old equipments.

Any help is highly appreciated.

- Husain