Skip to Content
0
Former Member
Jul 22, 2008 at 04:08 PM

query to retrieve data from action infotype based on particular actiontype

29 Views

Hi folks,

I need some help in retrieving data from infotype 0000.

The records for a certain employee id (10035532) for action infotype are as follows.. I trying to retireve the LOA action records

BEGDA-ENDDA-MASSN-MASSG

1. 04/01/2008 - 12/31/9999 - Z7(RLOA) - 02(FMLA).

2. 03/01/2008 - 03/31/2008 - ZB - 03.

3. 02/10/2008 - 02/29/2008 - Z2 - 05

4. 01/20/2008 - 02/09/2008 - ZB - 07

5 01/05/2008 - 01/19/2008 - Z5(Paid LOA) - 05(FMLA)

I have to retrieve the Z5 record for this employee. For every Z7 there is a corresponding Z5 record that links to the LOA records, in most cases the Z5 is immediately followed by Z7 record. I am able to retrieve such records successfully. However for few employees like one here the Z5 record is the fourth or fifth record down from the Z7. How can i retrieve the record in such a case?

Also in some cases the date ranges are missing in between, in such cases can we retirieve data succesfully? For ex:

1. 04/01/2008 - 12/31/9999 - Z7(RLOA) - 02(FMLA).

2. 03/01/2008 - 03/31/2008 - ZB - 03.

3. 02/10/2008 - - Z2 - 05

4. 01/20/2008 - - ZB - 07

5 *01/05/2008 - 01/19/2008 - Z5(Paid LOA) - 05(FMLA)

Need some inputs on the query here.

Thanks in advance,

VG