HR Infotypes

[Former Member]

Hi all,

I am working on HR Reports.

I have the following fields on selection screen:

1) Name

2) Mail Id

3) Employee No.

4) Master/Child Project

5) Sub Unit/Dept.

6) Extension No.

7) Direct No.

😎 Mobile No.

9) Voice/IP No.

10) base Location

11) Current Location

12)Current Country

13)Current State

14) Current City

15) Development Center No.

16) Geo Cluster

17) Vehicle No.

18) Cubicle ID

19) Asset ID

I tried searching in all the infotypes but could find only few of those fileds.

Please provide the infotype and the fields for all these selection screen fields.

My requirement is when I fill any of these fileds or a combination of these fields in the selection screen and click on execute,the details of all the employees pertaining to those selection screen options need to retrieved.

I tried to use function modules and also logical databases.But I am unable to write the code for all the selection screen options.

Please provide the step by step procedure as to how I should go about writing the code.

And provide the actual code if possible.

Regards,

Kashyap Ivaturi

[Former Member]

Steps to create a HR Infotype:

1) Go to Transaction PM01.

2) Enter the custom Infotype number which you want to create (Should be a 4 digit number, start with 9).

3) Select the 'Employee Infotype' radio button.

4) Select the 'PS Structure Infotype'.

5) Click on Create... A separate table maintenance window appears...

6) Create a PS structure with all the fields you want on the Infotype

7) Save and Activate the PS structure

😎 Go back to the initial screen of PM01.

9) Click on 'All' push button. It takes a few moments.

10) Click on 'Technical Characteristics'. Infotype list screen appears

11) Click on 'Change'(pencil) button

12) Select your Infotype and click on 'Detail' (magnifying glass) button

13) Give 'T591A' as subtype table

14) Give 'T591S' as subtype txt tab

15) Give your subtype field as subtype field

16) Save and come back to PM01 initial screen

17) Click on 'Infotype Characteristics' ... Infotype list screen appears

18) Click on 'Change' (pencil) button

19) Click on 'New Entries'

20) Enter your Infotype number and short text

21) Here we have to set different Infotype Characteristics as per the requirement. (Better open another session with some standard Infotype's infotype characteristics screen and use as the reference to fill yours)

22) Save your entries.

23) Now the Infotype is created and ready to use.

24) If you want to change the layout of the Infotype as per your requirement...

25) In the PM01 initial screen...Select 'Screen' radio button and give 2000 as the screen name, then click on edit.

26) In the next screen.. Select 'Layout Editor' and click 'Change'.

27) Screen default layout appears...here you can design/modify the screen..change the attributes of the fields..etc.

28) Save and activate. (Don't forget to 'Activate at every level)

Subtype Creation :

Transaction PM01 Goto Subtype Characteristics. Click on Append and then subtype. Enter the name and description of subtype on screen.

Then goto technical Characteristics and maintain the details of subtype there. I.e name of subtype i.e. component name defined in PSnnnn. Subtype table is T591A.

Subty.text tab is T591S and time const tab is T591A.

See:

http://help.sap.com/saphelp_46c/helpdata/en/4f/d5268a575e11d189270000e8322f96/content.htm

HR related site:

http://www.sapdevelopment.co.uk/hr/hrhome.htm

Enhancement of Infotype

Check the following

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/PAXX/PYINT_INFOTYP.pdf

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/60a7586d-edd9-2910-68a8-82043038...

Reward if useful.

[Former Member]

Hi,

Searched for the fields and got few.

1) Name - pa0002-cname

2) Mail Id -pa0105-usrid_long

3) Employee No. - pa0000-pernr

4) Master/Child Project -

5) Sub Unit/Dept. -pa0000-orgeh ( dept is the organisational unit )

6) Extension No. - pa0006-com01, pa0006-num01

7) Direct No.

😎 Mobile No. - pa0006-telnr

9) Voice/IP No.

10) base Location

11) Current Location

12)Current Country -pa0006-land1

13)Current State -pa0006-state

14) Current City -pa0006-ort01

15) Development Center No.

16) Geo Cluster

17) Vehicle No. -pa0032-anlnr

18) Cubicle ID

19) Asset ID

For extension/direct/mobile/voice nos, can use communication type & comm no fields( it0006-com1, it0006-num01).

Further, u can search for specific infotype in t582s table which gives list of infotypes and texts.

Can put condition as

select ( field1 field2 ) from tables

where field1 in s_field1

and field2 in s_field2...

reward points if useful...

regards

cs

[amit_khare]

You can get most of the information in IT0001, 0006 & 0015 except for

15) Development Center No.

16) Geo Cluster

17) Vehicle No.

18) Cubicle ID

19) Asset ID

You need to check with your functional consultant for these fields.

Use Logical Database PNP and get all the other information and then based on key fields extract the other from the corresponding tables.

Regards,

Amit

Reward all helpful replies.

[Former Member]

Hi Sravan,Cs and Amit,

Thanks for your valuable responses.

I tried to get the values using the logical database PNP.

When I tried writing the code,I had to make all the selection screen fieds mandatory.

However,the problem is that all the mentioned fields in the selection screen are optional.

So filling in the details in any one of these fields/a combination of more than one field should retrieve the corresponding entries on clicking execute button.

Kindly help me on this logic as to how I need to wite the code and also please provide some sample code if any.

Regards,

Kashyap Ivaturi