topic Re: Structural Authorization Extraction : not pulling in all users in Application Development and Automation Discussions

Structural Authorization Extraction : not pulling in all users

shivraj_singh2 — Wed, 18 Jul 2012 23:51:33 GMT

Dear Experts,

We have several users in ECC (HR) set up with proper positions, roles & relationships (BADI is active). Table T77UU is getting populated fine. And we are extracting data to BW system.

Issue is, not all the users are getting extracted to 0PA_DS03. Like I mentioned earlier, user-position-relationship mapping is all there in ECC. But many users are not showing up in 0PA_DS03.

However for the same users which are not getting extracted in 0PA_DS03, extraction is working fine for 0PA_DS02. Data is showing fine for these users in /BI0/APA_DS0200

If I go to RSA3, and select a user in 0HR_PA_2, data gets selected but for the same user, if I try it with 0HR_PA_3 - 0 Data gets selected. But the issue is only with few users.

Any idea where I should look for the error.

Regards,

Shivraj

Re: Structural Authorization Extraction : not pulling in all users

wilder_latino — Thu, 19 Jul 2012 14:45:47 GMT

Are all users in table T77UU?

Re: Structural Authorization Extraction : not pulling in all users

shivraj_singh2 — Thu, 19 Jul 2012 15:06:35 GMT

All the users are in T77UU, all the users are getting extracted to BW also, only for few users 0 data is getting extracted in 0HR_PA_3 where as for the same users data is available in 0HR_PA_2.

Re: Structural Authorization Extraction : not pulling in all users

wilder_latino — Thu, 19 Jul 2012 17:06:40 GMT

Dumb question but I have to ask. Do all the users exist in the BW system?

Re: Structural Authorization Extraction : not pulling in all users

shivraj_singh2 — Thu, 19 Jul 2012 18:15:18 GMT

no I don't think that is dumb, that was the first think I checked. And all the users exist in BW.

Re: Structural Authorization Extraction : not pulling in all users

wilder_latino — Thu, 19 Jul 2012 18:33:26 GMT

Open an OSS Message to SAP, but it seems that you have done all the steps correct.

I think you have everything working but you need to execute the "RSEC_GENERATE_AUTHORIZATIONS" program.

Re: Structural Authorization Extraction : not pulling in all users

wilder_latino — Thu, 19 Jul 2012 18:49:33 GMT

One more thing I forgot to mention is to execute program RHBAUS00 in ECC before you do the load. Most likely you did that already.

What infoObject do you have turn for Structural Authorization? 0Employee and 0Person?

Let me know if you find a solution. If I think of anything I will keep you psoted,