Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

query to retrieve data from action infotype based on particular actiontype

Former Member
0 Kudos

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

1 REPLY 1

Former Member
0 Kudos

No responses. The thread is closed.

VG