Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SQL table to query the HCM staging area identity store


I'm pretty new to IDM and need help please.

I'm trying to locate which table view in SQL would give me the manager details brought from HCM into the HCM staging area identity store.

I was advised that this information would be in the SAP_MASTER IS but I'm confused as I only have 2 IDs - one productive & the other the HCM staging area

Please could you give me some info on this.

IDM 7.2 SP9

Database - SQL




The manager in IdM is a reference between two IdM records, the mx_manager in SAP Master Id Store would contain MSKEY of the manager record.

HCM doesn't know what is the MSKEY of manager in IdM (as MSKEY is autonumber) so you get the Personnel Number of Manager to Staging Id Store in order for you to build the reference between the manager and subordinate records in IdM.

regards, Tero

2 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question