DSO to Master Data 0EMPLOYEE

[former_member372548]

Hi,

Sometime HR create employee record in SAP and they Delimit those employee because they don't need it.

Issue- Since it came into BW with previous load and now it is delimited from SAP, still showing in BW. So SAP data and BW data out of sync.

1st Solution: SAP--> PSA-->DSO-->0EMPLOYEE (mapping 0RECORDMODE between DSO and EMP). Still delimited record shows in EMP.

2nd Solution: Delete MD completely and full load- too many manual process

I am using T-code SE14 to delete MD- Not recommended

When I use "Delete Master Data-->Text ->Simulate Mode--> Perform in BKG with Search Mode "One usage is sufficient" and then see from MANAGE tab. I still see all the records in the InfoObject.

What could be best solution?

Please suggest.

Regards

BW Team

[Former Member]

Hello BW team,

Let me clarify, how some employee data is not in sync with ECC and BW based on my expereince.

We found that whenever any HR manager create Employee and put it in draft mode, it creates entry in some of the table HRPA**01/02/etc. Now during this time if 0EMPLOYEE_ATTR brings data in BW, then this draft employee also com to BW. now suppose on next day, HR manager found that he doesn't required this employee master then he delete it from system. But unfortunately it will not send deletion mark in 0EMPLOYEE_ATTR datasource, which result in more data in BW then ECC.

Now, in our case the last step of employee creation was assignment of organization like company code. So for reporting purpose we only used the 0EMPLOYEE with company code, that always match with ECC.

After organization assignment if they want to delete 0EMPLOYEE from ECC, then they have to mark inactive flag instead of deletion.

Please check your case, if it is same as us then use some filter to show validate records in report.

Or else I will suggest to provide report on employee with transaction data source like 0HR_PA_1 - which always bring active employee data. So no need to worry about all above stuff.

Regards,

Ashish

[Former Member]

Dear,

Why are you delete complete set up of data? Your issue is as how to delimit the employees which are no more needed?

You could try to understand the meaning of delimit functionally and then use some indicator when an employee is delimited. Use that field in BW OR enhance the source with this field (Whatever it is standard OR generic).

You could try to use this filter in your query, that way such employee will not be shown. In some times you have to use ABAP to accomplish this. If you don't want such data at all that you could use some custom program that will delete such records from DSO before it goes to your info object.

Thanks & Regards,

M

[Former Member]

Hi,

you can only delete the master data records selectively when they are not used in any other targets.

• first delete the records which you want to from employee master data (display master data -->choose the records and delete
• and if you have access to SLG1 , you can get the where used list of those records (refer the below screen shot )

• delete them accordingly.