Sequence to Load Employee master data Attributes

[srinivas_anilkumar]

Hello All,

We are using the ZEMPLOYEE Infoobject, copy of standard 0EMPLOYEE in our BI HR. We have added some customer specific attributes to ZEMPLOYEE. All these attributes are using different infotypes in HR and loaded to ZEMPLOYEE using different datasources. We also load the standard datasource 0EMPLOYEE_ATTR besides these custom datasources.

I would like to know if we need to follow any sequence to load the attributes to ZEMPLOYEE. I found some peculiar issues that some custom datasource fields are not filled at times in attributes though the record is still valid. Please note that we execute the change run after every datasource is loaded to infoobject.

Thanks for your suggestions.

Regards,

Srinivas

[kr_pavankumar · Accepted solution]

Hi,

As per my understanding, there is no dependency while loading the Master data Attributes of a characteristic even though it has multiple attribute datasources.

This could be of "duplicate" entries are not, in fact, duplicates. But as one entry is placed in Master data by the system to cover time dependent data from the beginning of time =01.01.1000

Ex:

1001    01.01.1000   31.12.2010

1001    01.01.2011    31.12.2011     XX      YY

1001    01.01.2012    31.12.9999     KK      PP

Here the first record doesn't have values which is caused by the time-dependent attributes. So, Check for the time intervals in various infotypes and the data in Master tables.

Focus on time intervals and overwrite functionality of the Master data.

Check whether or not Read Master data or any Routines exists.

If possible provide sample data for better understanding.

[Former Member]

Hi Gurus,

I need help on 0Employee_Attr Datasource.

We are currently on BI 7.x , We are getting duplicate values with End date less than Start Date for two Employees

Datasource            : 0Employee_Attr

Function Module     : HR_BIW_GET_MASTER_DATA

We checked in tables infotypes PA0000, PA0001, PA0007, PA0008, PA0037, PA0006.

We were not able to find records here.

Please find the example below.

Perrno	Start Date	End Date
1001	01.04.2013	31.03.2013
1001	01.04.2013	31.05.2013
1002	01.04.2013	31.03.2013
1002	01.04.2013	31.05.2013

Awaiting response!

Regards

Karthik Kurpad

[kr_pavankumar]

Hi Karthik,

The sample data which u have provided is at which level means at Extractor checker (RSA3) or at PSA.

Is there any enhancements for the datasource in CMOD. If any plz check the logic and share ur findings.

-- KRPK

[Former Member]

Hi Pavan,

Its in BI side.

We are getting error while loading data from PSA to DSO.

No there has been no changes made as it is a standard extractor.

As mentioned above it is based on function module HR_BIW_GET_MASTER_DATA

We checked in tables infotypes PA0000, PA0001, PA0007 and PA0008 at R3 side

Still we were not able to find the source of these records!

As a fix we have added code in start routine to delete records with enddate less than start date.

[Former Member]

Hi Karthik,

Load the same data to an infoobject with PERRNO (time dependent  char) and activate the master data.

and after Master Data activation, your result will be like below.

Perrno	Start Date	End Date
1001	01.04.2013	31.05.2013
1002	01.04.2013	31.05.2013

Thanks

[Former Member]

Hi

Check whether the data is available in PSA tables as Source system data.

If data is available in PSA tables then might be some DTP filters or DTP variables, routines must be there.

vishwa