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