topic Re: Report in Application Development and Automation Discussions

Report

Former Member — Wed, 01 Mar 2006 06:04:59 GMT

Hi Experts,

now how to active employees list Report.

Hamad

Re: Report

Former Member — Wed, 01 Mar 2006 06:10:23 GMT

could u explain ur problem more clearly.

Regards

Deepak

Re: Report

Former Member — Wed, 01 Mar 2006 06:14:41 GMT

Hi,

select all the employees whose status is ACTIVE,

you can find the status of employee in PA0000, field is STAT2 (if STAT2 is 3 then employee is active).

is the above one you are looking or some thing else..

Regards

vijay

Re: Report

Former Member — Wed, 01 Mar 2006 06:14:51 GMT

Dear Deepak,

now am create report to Employees list ok but not in group

now i need how to create any group in employees list.

thanks for any help.

Hamad

Re: Report

Lakshmant1 — Wed, 01 Mar 2006 06:18:56 GMT

Hi Hamad,

Use report RPLMIT00 and in parameter "Employment status" specify '3' for active employees.

Hope this helps.

Thanks

Lakshamn

Re: Report

Former Member — Wed, 01 Mar 2006 06:19:19 GMT

Hi Vijay,

now am a newbie really i need helpful please if you can.

Hamad

Re: Report

Former Member — Wed, 01 Mar 2006 06:28:50 GMT

Hi Hamadelnil,

As Mr.Laxman Suggested you can check the Program <b>RPLMIT00</b> , in selection screen give employee status as 3 for active employees. it will list all the active employees.

or else you can use.

<b>slect *

from pa0000

into table it_pa0000

where stat3 = '3'.</b>

you need to give BEGDA and ENDDA also in your where condition, if you want to see for a particular period.

Regards

vijay

Re: Report

Former Member — Wed, 01 Mar 2006 06:30:46 GMT

Hi Hamad,

U can get the employment status of an employee from PA0000 table(Infotype 0000) and the field is STAT2.

If the value for this field is 3..then ihe is active employee in the org.

When u want to show the list those are in active state..then go ahead this.

select pernr from pa0000 into table i_pa0000

where stat2 = '3' by checking begda and endda also.

Thanks

Eswar