Question Re: HR Payroll Data Extraction in Technology Q&A

HR Payroll Data Extraction

Former Member — Wed, 20 Apr 2005 08:33:25 GMT

Dear BW gurus,

I am new to BW and currently doing a project. When I try to load payroll data from R/3, I got a message in the monitor screen saying "No data available". I go to R/3 and test extraction for the payroll datasource(0HR_PY_1), the data can be extracted. Can anyone give me some hints why I can't get data in BW. I use standard Business Content without any modification.

Re: HR Payroll Data Extraction

Ashwin — Wed, 20 Apr 2005 09:05:59 GMT

Hi!

have you able to extact any records using the extractionc check RSA3 in the r/3 system.

with regards

ashwin

Re: HR Payroll Data Extraction

somnathkumar — Wed, 20 Apr 2005 12:52:02 GMT

There could be a lot of reasons.

1. Check if the datasource/infosource mappings are correct and activated.

2. Check if the sourcesystem with which the datasource is mapped is the correct one (correct R/3 box).

3. There are no restrictions in the infopackage.

4. The link between the BW and R/3 is active.

5. Try loading only till the PSA. Does it come?

Re: HR Payroll Data Extraction

Former Member — Thu, 21 Apr 2005 01:28:58 GMT

Dear Ashwin,

Thanks for your reply. I can extract data using extraction checker (RSA3) in R/3. But can't extract in BW.

Re: HR Payroll Data Extraction

Former Member — Thu, 21 Apr 2005 01:33:57 GMT

Dear Somnath,

Thanks for your reply.

1. The mapping are correct and infosource is activated

2. I've extracted other HR data (eg. employee) from R/3, so the box is correct.

3. No restriction in infopackage.

4. it's active

5. That's what I did. Only load into PSA but no data available.

I am wondering is it any special ocnfiguration required for payroll since it supports delta (employee master is full upload).

Re: HR Payroll Data Extraction

Former Member — Thu, 21 Apr 2005 06:23:40 GMT

Hi,

Have you checked the foolowing settings are proper or not :-

1)RFC destinations b/w R/3 & BW

2)Logical system names

Some times the changes in the above settings can lead to 'No data available' problem.

With rgds,

Anil

Re: HR Payroll Data Extraction

somnathkumar — Thu, 21 Apr 2005 12:37:54 GMT

Hi,

There is a particular role that needs to be added to the background id that extracts HR data. It contains specific authorizations for extracting HR transaction data.

We implemented this in our previous project. But I am not able to get the role name or the place where I read this.

Maybe this could be of help to you.

Re: HR Payroll Data Extraction

Former Member — Thu, 21 Apr 2005 20:06:39 GMT

Probably your RFC-user running the extraction job has insiffucuent rights to read HR payroll data, When testing the extractor with RSA3, you use your own logon, that probably has enough HR authority.

Re: HR Payroll Data Extraction

Former Member — Fri, 22 Apr 2005 01:48:48 GMT

Dear Somnath and Maik

Great thanks! After adding P_BAS_ALL (Authorization for Personal data) to BW RFC user, I can finally extract Payroll data from R/3 into BW.

Re: HR Payroll Data Extraction

Former Member — Wed, 07 Mar 2007 05:46:11 GMT

Hi,

i am having the same problem, could u please tell me how you added P_BAS_ALL( Authorization for personal data)??????????? its really urgent, would appreciate your quick responce