SAP C4C - Field "External ID" of Employee needed in the data source

[former_member657155]

Hello,

I would like to create a report where I will show all employees with their External codes (standard External ID field on Employee object) .

Is it possible at this moment? I went through all data sources related to Employees and could't find it..

Any tip is very welcome.

Thank you

Kind regards

Stay safe! 🙂

Sylwia Jurczenko

[former_member226]

Hello,

Since external ID is always dependant on "System Instance ID" hence they are not part of the "Data Source" exposed by the standard. However, SAP offers another data source "Object ID Mapping"(FNDOIMB) which contains the external ID for each of the business objects like employee, account etc against each business system instance.

Therefore, you can design a new Inner Join Data Source with "Employee Master Data" on the left side(or anchor) Data Source and join it with "Object ID Mapping" Data Source. Here you need to define the condition as

FNDOIMB.LOCAL_OBJECT_UUID = CODHCMEMPB.EE_UUID

This means that "LOCAL_OBJECT_UUID" of the "Object ID Mapping" Data Source is the employee UUID of "Employee Master Data" data source.

Hope that helps!