Extract organization by sorting date

33 Views

hi

An employee in an org. can be in different units in different time.I want to extract the employees organization in which he is currently working with.

 MANDT PERNR ENDDA      BEGDA      UNAME  PERSK    ORGEH    PLANS    STELL

  200       3 31.12.9999 24.02.2009 122910 11    10100519 50001466 80000301
  200       3 23.02.2009 01.11.2008 106953 11    10100519 50001466 80000301
  200       3 31.10.2008 01.10.2008 106953 10    10100463 50000005 80000002
  200       3 30.09.2008 04.09.2008 106953 10    10100008 50002108 80000404

I have to extract ORGEH corresponding to latest DATE i.e. ENDDA

How to sort the date ?

Sachin