topic Re: Table USH04 in Application Development and Automation Discussions

Table USH04

Former Member — Tue, 27 Apr 2010 15:52:02 GMT

Dear Gurus,

The table USH04 is for documenting the changes to user profiles. But I find that the table is not always updated. I have found a few cases wherein the user has been assigned the role and the user comparison also done, yet the USH04 does not document the change.

Are you aware of any reason why the changes dont get registered? One reason that I could find is that users assigned to a role via PFCG are not registered in USH04.

Regards,

Subbu

Re: Table USH04

Former Member — Tue, 27 Apr 2010 16:15:56 GMT

Take a look at report rsusr100n, instead of tables. They changed...

Cheers,

Julius

Re: Table USH04

Former Member — Tue, 27 Apr 2010 16:35:29 GMT

Hello Julius,

Thanks for information.

But can we address this problem for USH04. I shall try to explain the requirement.

We have a program which creates/updates users automatically in a target system based on the trigger from USH04 in the source system. The program checks for updates in USH04 for creating while creating or modifying the users.

Regards,

Subbu

Re: Table USH04

Former Member — Tue, 27 Apr 2010 16:57:47 GMT

Then you are using the wrong trigger. That is always the danger when you do not use releasrd and stable interfaces to data.

The data is now in CDPOS with a foreign key from CDHDR. There are function modules for reading the change documents -rather use them or reconsider a better design for the trigger.

Cheers,

Julius

Re: Table USH04

Former Member — Tue, 27 Apr 2010 20:00:36 GMT

This message was moderated.

Re: Table USH04

Former Member — Wed, 28 Apr 2010 10:13:13 GMT

Hello Julius,

Thanks a lot, I could find the data in in CDPOS for table name AGR_USERS, change document object PFCG.

I am also trying to find out the function modules which read the change documents. Do you have an idea which are the ones that could be of help in this scenario?

I would definitely reconsider the design as the current one is not yielding accurate results. Thanks for your help.

Regards,

Subbu

Re: Table USH04

Former Member — Wed, 28 Apr 2010 10:58:35 GMT

RSUSR100N uses function group SU_USER_CHANGE_DOC.

Why don't you just submit the report itself with a variant using dynamic dates in the selection variables?

Cheers,

Julius

Re: Table USH04

Former Member — Wed, 28 Apr 2010 11:50:13 GMT

Hello Julius,

Yes RSUSR100N seems to be a viable option. I shall check with my developer all these options and see which one fits best.

Thanks for all your help.

Regards,

Subbu