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: 

abap hr

Former Member
0 Kudos

Hi all,

Can any one explain me how to find the relation between infotypes.

Thanks in advace

1 ACCEPTED SOLUTION

suresh_datti
Active Contributor
0 Kudos

Hi,

Which infotypes ? PA or PD? if PD, the relationships for an Object are maintained in HRP1001 table.

Regards,

Suresh Datti

5 REPLIES 5

suresh_datti
Active Contributor
0 Kudos

Hi,

Which infotypes ? PA or PD? if PD, the relationships for an Object are maintained in HRP1001 table.

Regards,

Suresh Datti

Former Member
0 Kudos

see check tables to find relation

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

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.