topic Re: Extract organization by sorting date in Application Development and Automation Discussions

Extract organization by sorting date

Former Member — Thu, 18 Jun 2009 05:05:09 GMT

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

Re: Extract organization by sorting date

GauthamV — Thu, 18 Jun 2009 05:11:55 GMT

use this.

SORT itab BY pernr endda DESCENDING.

Re: Extract organization by sorting date

Former Member — Thu, 18 Jun 2009 05:17:13 GMT

Hi,

Sort itab by ENDDA in descending order and read the first record. You will get what you required.

Thanks,

Rakesh.

Re: Extract organization by sorting date

Former Member — Thu, 18 Jun 2009 05:19:50 GMT

i am using the query

SELECT orgeh from pa0001 INTO lv_emp_org UP TO 1 rows

WHERE pernr = 00000003 and

????????????????

ENDSELECT.

I want sort the endda in descending order and than want to extract the first record,,,??

Re: Extract organization by sorting date

Former Member — Thu, 18 Jun 2009 05:20:35 GMT

Hi,

After fectching the records from infotype 0001.

if not itab[] is initial.

Sort itab by pernr begda descending.

delete adjacent duplicates from itab comparing pernr.

endif.

So you will get latest record for each pernr.

Regards,

Kumar Bandanadham.

Re: Extract organization by sorting date

Former Member — Thu, 18 Jun 2009 05:49:50 GMT

> SELECT orgeh from pa0001 INTO lv_emp_org UP TO 1 rows

> WHERE pernr = 00000003

> ORDER BY date_field DESCENDING.

> ENDSELECT.

Try like this.

Regards

Karthik D