Needed SAP HR Table

[Former Member]

Hi all,

Please tell me SAP HR tables for storing the following data for sap

- Education i.e. education name , degree,start date,end date,branch of study (major) etc ( Infotype - 0022 )

- Employments i.e. employer,title,description,start date,end date etc ( Infotype -0023 )

- Qualification i.e.skills,potentials,languages spoken etc ( Infotype -0024 )

- Personal data i.e. First name, Last name , email address etc ( Infotype -0002 )

- Address i.e. State,city,postal code, phone number ( Infotype -0006 )

- Payroll i.e. basic pay ,net pay , start date , end date etc

Any help is useful.

Thanks,

@Navdeep: You have been around for quite some time &
should have known better. i.e.to search before posting.
@Everyone: Please stop responding to such posts.
This is not a Q&A forum!

Edited by: Suresh Datti on Aug 24, 2009 2:55 PM

[Former Member]

Hi,

The corresponding transparent tables are PA followed fy infotype number.

Like for personal data (0002) it is PA0002,

Basic pay Pa0008.

There are also some function modules to read data for It0008,IT0024.

Thanks,

Sutapa.

[Former Member]

Hi,

Check this functiopn module.

RP_FILL_WAGE_TYPE_TABLE

It fetches data for many of the infotypes.

Many infotype maya have data records which are indirectly evaluated.So direct query from tables won't give you data.Amount may come as blank.

You can use this function module in those cases.

Thanks,

Sutapa

[Former Member]

Thanks Sutapa, for quick reply.

If i needed Infotype and then subtype table name then how i get it like in Skills there is qualification tab .

Is there any FM that is RFC enabled that helps me a lot.

Regards,

[Former Member]

Hi,

For qualification data read you can use this function module

RHPP_Q_PROFILE_READ.

See if this helps.

Thanks,

Sutapa.

[Former Member]

Thanks , I am unable to get details as it asks for parameters like start date , end date but not fetching any data.

Is there any BAPI / IDOC we use to get all details of any infotype.

Regards,

Navdeep Singh

[Former Member]

Hi,

Check if data are maintained in your infotype.

Goto SE11 and check for any employee number if any data is maintained or not.

you can maintain them through PA30 tcode.

You can wrire select queries on the tables and get the data.

RP_FILL_WAGE_TYPE_TABLE function module is also very useful.

Thanks,

Sutapa.

[Former Member]

I am checking the data from txn PA30 but unable to get the data from the FM - RP_FILL_WAGE_TYPE_TABLE for infotype (0023,0022,0024,0006) etc.

Please provide me more details may be i am missing some steps.

Regards,

Navdeep Singh

[Former Member]

Hi,

The above function module is not for all infotypes.

It is for 1,7,8,14,15,52,230,267.

for 24 use RHPP_Q_PROFILE_READ.

For 22,23,6 you can use simple select statements.Need to check if function modules for these are availavle or not.

Or in your code if you are using LDB then you can declare the infotypes and when you do GET PERNR all infotype records will be populated for each employee.

Thanks,

Sutapa.