How to write query to retreive the latest record by using PN-BEGDA , PN-ENDDA, SYDATUM,.
I know using RP-PROVIDE.......other method using query i require
it is urgent