how do we get the latest record that was created..... for example
i want a select query which should get teh latest created record for this following logic
Retrieve the Cond. Record no KONH- KNUMH from table KONH by the condition : Where KONH-KOTABNR = u2018509u2019 and KONH-KSCHL = u2018JCEPu2019 and compare the first 16 characters of value of field KONH-VAKEY with concatenated value of MARC-HERKL &MARC-WERKS &MARC-STEUC with the latest created on KONH-ERDAT