02-24-2006 1:29 PM
Hi all,
Can any one explain me how to find the relation between infotypes.
Thanks in advace
02-24-2006 1:32 PM
Hi,
Which infotypes ? PA or PD? if PD, the relationships for an Object are maintained in HRP1001 table.
Regards,
Suresh Datti
02-24-2006 1:32 PM
Hi,
Which infotypes ? PA or PD? if PD, the relationships for an Object are maintained in HRP1001 table.
Regards,
Suresh Datti
02-24-2006 1:45 PM
02-24-2006 1:49 PM
Hi Charan,
The information units used to enter the data of an employee are called infotypes.
The infotypes are used to group related data fields together.
E.g.. IT0006.(address)
Why Infotype
As HR is related to time , we require old data as well as new data. The data we enter into the infotypes are automatically checked for accuracy and against the table entries.
In simple, HR data is huge and to access data easily we require infotype.
Master data in HR is stored in infotypes.
Each infotype pertains to a specific type of data.
Each infotype has a database table associated with it.
Example : For Infotype 0000, the corresponding
database table associated with it is PA0000.
Get back if U still want any more info.
Regards,
GSR.
02-24-2006 10:54 PM
Ravicharan,
If you are refering to PA infotypes and you have a record from one infotype (i.e. IT0001), and you want to find the corresponding record(s) from another infotype (i.e. IT0006), you can use this type of statement:
select * from pa0006
where pernr eq pa0001-pernr
and endda ge pa0001-begda
and begda le pa0001-endda.
endselect.
Of course, you can really simplify things by simply using a keydate to get a snapshot of data for a date in time:
select * from pa0006
where pernr eq pa0001-pernr
and endda ge sy-datum
and begda le sy-datum.
endselect.
Hope this helps,
Paul
02-25-2006 4:32 AM
Hi ravicharan,
1. Can any one explain me how to find the relation between infotypes.
What exactly do u mean
2. In fact, there is no relation
between infotypes,
apart from the personnel number they share.
3. There are some infotypes like
7 (working hours) and 8 (salary)
which are linked because
of business requriement.
4. Infotype is nothing but :
a) there is lot of master information about
a employee.
b) its divided / bunched into logical groups
c) sap has given this logical groups
the nomenclature as 'INFOTYPE'.
d) dividing into logical groups serves
purpose of distribution rights,
and other maintenance prolbmes in real business.
regards,
amit m.