topic Re: pernr in Application Development and Automation Discussions

pernr

Former Member — Tue, 22 Apr 2008 14:26:38 GMT

Hi,

can u tell me what is difference between pernr in pa0001 table & pernr in pa0000 table?

thanks a lot.

Re: pernr

Former Member — Tue, 22 Apr 2008 14:30:28 GMT

There is no difference ..

PA0000 is to store Actions and

PA0001 is to store Org. Assignment ...

U'll relate both these infotypes using pernr ...

Re: pernr

Former Member — Tue, 22 Apr 2008 14:30:59 GMT

Hi,

There is No difference between PERNR in 0000 infotype and 0001 infotype.

PERNR means Personnel Number(Employee Number)

<REMOVED BY MODERATOR>

raam

Edited by: Alvaro Tejada Galindo on Apr 22, 2008 11:11 AM

Re: pernr

Former Member — Tue, 22 Apr 2008 14:35:43 GMT

all 'pernr ' for processing i want to store it into itab .so i can get it from either 0000 or 0001?

or i have to get it from particular table only.

Thanks.

Re: pernr

venkat_o — Tue, 22 Apr 2008 14:39:19 GMT

Hi Rani, In HR module, in Personal Administration submodule tables from PA0000 to PA0999. Not all existed. Key fields for all these tables are PERNR SUBTY OBJPS SPRPS ENDDA BEGDA SEQNR There is no difference Pernr in PA0000 with pernr in PA0001. I hope that it helps u. Regards, Venkat.O

Re: pernr

Former Member — Tue, 22 Apr 2008 15:06:30 GMT

Hi,

we can get thr PERNR from any INFOTYPE.

Deppending on the requirment u choose the infotype. If u want the ACTIONS data u go for PA0000. If u want the ADDRESS details then u go for PA0006. Like that we use different INFOTYPES (Tables) for different information. But the PERNR in all then tables are same.

raam

Re: pernr

Former Member — Tue, 22 Apr 2008 15:09:32 GMT

Hi,

In PA0000 for pernr(eg. 10451) there is begda & endda (2001 )

but in crt table i m looking pay-date for 2006.

so what is relation between begda-endda in pa0000 (or pa0001) and pay-date in crt?

Thanks.

Re: pernr

Former Member — Tue, 22 Apr 2008 15:14:46 GMT

Hi,

BEGDA is the starting date of the employee and ENDDA is the last date of the employee in the company/organisation.

PAY DATE is the payrole run date

raam

Re: pernr

Former Member — Tue, 22 Apr 2008 15:17:46 GMT

i know that .

but if begda & endda is < paydate what is that mean?

Re: pernr

Former Member — Tue, 22 Apr 2008 15:19:30 GMT

hi ,

generally the status of employee fetch from the table pa0000 ie stat2 field...and after ..the payroll data will be maintained in tables pa0003 and pa0007(working time) .there is no relation between the begda and the crt date you specified.. i think you are working in the payroll or in the time management..

regards,

venkat.

Re: pernr

Former Member — Tue, 22 Apr 2008 15:25:03 GMT

Hi,

begda & endda is < paydate

U are just checking wheather the date is less than pay date or not.

can u give me the correct equation.

raam

Re: pernr

Former Member — Tue, 22 Apr 2008 15:30:17 GMT

Hi Rani,

Check the below code.

tables pa0000.

select-options: s_pernr for pa0000-pernr.

data: it_rgdir like pc261 occurs 0 with header line.

data: begin of it_0000 occurs 0,

pernr like pa0000-pernr,

begda like pa0000-begda,

stat2 like pa0000-stat2,

end of it_0000.

data: begin of it_0001 occurs 0,

pernr like pa0001-pernr,

begda like pa0001-begda,

ename like pa0001-ename,

end of it_0001.

start-of-selection.

select pernr stat2 from pa0000 into table it_0000

where pernr in s_pernr.

if sy-subrc = 0.

sort it_0000 by pernr begda descending.

delete adjacent duplicates from it_0000 comparing pernr.

select pernr ename from pa0001 into table it_0001

for all entries in it_0000

where pernr = it_0000-pernr.

if sy-subrc = 0.

sort it_0001 by pernr begda descending.

delete adjacent duplicates from it_0001 comparing pernr.

endif.

loop at it_0001.

read table it_0000 with key pernr = it_0001-pernr.

if sy-subrc = 0.

if not it_0000-stat2 = '3'.

continue.

endif.

CALL FUNCTION 'CU_READ_RGDIR'

EXPORTING

PERSNR = it_0001-pernr

TABLES

IN_RGDIR = IT_RGDIR

EXCEPTIONS

NO_RECORD_FOUND = 1

OTHERS = 2

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

loop at it_rgdir.

process what ever you want here.

endloop.

Re: pernr

Former Member — Tue, 22 Apr 2008 17:10:21 GMT

can u tell me how to wxit from program which is in running .

I have thousands of data at each step it is showing me error. so i want to quit from program.

I did not set any break point.

Thanks.