ARQ: Problem while mapping "VALID TO" Access Request Field with HR System's "End Of Contract"???

[former_member184114]

Hi,

I have a business requirement where the role validity for a user should be mapped with his contract date in HR system.

For this, I asked HR person to maintain the "End of Contract" date to 31.12.2014 for testing purpose for one of the test users. Of course, HR system is the user data source system.

For mapping this field, I performed below activities:

1. In SPRO->GRC->AC->Maintain Mapping for Actions and Connector Groups, I selected SAP_R3_LG Logical Group and selected connector for test HR system where the testing data is maintained. The Action is 4 for that connector (The same connector is maintained as one of the HR systems for user data source).

In "Assign group field mapping" I added new entry like this:

AC Field Name     : VALIDTO

System Fld Name : Empty (not sure about this field what to enter)

Table Name          : P0019 (This table I got from HR team)

Subtype                 : Empty

The date is not reflected in the Access Request page. Am I missing anything?

Please advise.

Regards,

Faisal

[alessandr0 · Accepted solution]

Dear Faisal,

I never created a field mapping for a table but it seems that you are missing the system fieldname from the table P0019. A table has several columns and you have to define from which column it should read.

Also check if the batch user has authorization to read from a P table, as mostly such tables are restricted due to HR restrictions.

Regards,

Alessandro

[former_member184114 · Accepted solution]

Hi Alessandro,

Thanks for your reply and again nice communicating with you 🙂

Now let us go step by step.

Is this business requirement normal and feasible? My next lines presume that it is.

I think I have picked up correct AC Field above. System Fld Name has possible values displayed when I press F4. I am not sure what to pickup from them!

I believe (correct me if I am wrong) the rest of the 2 fields are referring to table/field in SAP HR system. As I have communicated earlier, I got this table and field  (TERMN) from HR team. But when I enter "TERMN" as the "Subtype", system shows error message that: Field is too long.

This means that only maximum 4 characters/numbers are allowed. For example, 0001.

Is this the way we normally map fields from SAP HR system? We may have such requirements in future also to map other required fields from SAP HR system.

May you please advise me on this?

Regards,

Faisal

[alessandr0 · Accepted solution]

Dear Faisal,

great to hear from you again.. I hope you could recognize me this time

As mentioned I've never mapped HR fields but from my point of view it might be similar than mappings with other systems like LDAP. See the following printscreen as a reference with LDAP:

I assume you have to put it like that:

Did you try that way?

Regards,

Alessandro

[former_member184114 · Accepted solution]

Dear Alessandro,

Yes, of course! I recognize you now .

It is always pleasure to communicate with you as it is very useful and informative!

Thanks again for your reply.

Yes, I have the same configuration for LDAP mapping. If I press F4 on field "System Fld Name" for "PROVISIONING" Scenario, I get all available fields to be selected. For LDAP, I could select this field from the list.

I have seen all the fields starting with "VALID TO". I could find 11 entries for this system field. But it is showing some different structures like: ADDRESS:BAPITEL****. I could not decide which one to select. But I had selected one of them but did not help me.

I also checked table GRACFIELD in SE16 and there I found entries for action "PROVISIONING". I could not find any field with TERMN".

I tried with table:P0019 and subtype:TERMN (got error "field value too lone").

I will try to follow your suggestion once I am at my system.

Will update you.

Regards,

Faisal

[former_member184114 · Accepted solution]

Hi Alessandro,

May I ask you if I can consider using "Custom Fields".

First of all, I think that the field I am trying to map from HR is not standard field (Please correct me,  I an not sure and this is just my guess).

If lets say it is not standard, then I think custom field is to be used. Next question is that, if I use custom field, then how I can make 'validity to' of roles to this custom field?

Please suggest/advise.

Regards,

Faisal

[former_member297605 · Accepted solution]

Hi Faisal ..... I think the SAP table is PA0019 and there is a field TERMN in there. Hope this helps.

Ran