Database Inconsistency of Employee with Infotype 0001

[Former Member]

Hi

I have couple of questions:

1. I want to delete few of the Employees Records who are having Gaps in IT0001.

2. Few of the Employees' EARLIEST Records are having End Date as 12/31/9999. This data has got loaded into the System through Batch input. How to Delete those Records?

For both of the above things, the System is giving Weird messages or going to Dump; When I try to either Delete the Record (which doesn't have similar dates as of IT0000) or Change the End Date.

Any kind of help would be highly appreciated.

Thanks in advance,

HR_Guy.

[Former Member]

Hi Suresh,

It doesn't look like, I have any other Solution except writing some Logic. The Program - RPUFIXDS, doesn't identify these Employees. I ran the Program for all the Employees with wrong data and it didn't display anything in the Output. Do you have any other solution/alternative to fix this?

Thanks in Advance,

HR_Guy.

[suresh_datti]

I'm not aware of any option other than a direct db delete..ie

delete pa0001 where bega le <ref_dt>

and endda eq '99991231'.

~Suresh

[Former Member]

Hi Guys,

Thanks for all of your Inputs.

Manoj Kumar,

Basically, I'm running a Report using the FM - 'HR_INFOTYPE_OPERATION to Update Infotype Records and got stuck into this. The problem in using this FM is, Few of the Employees are having this problem with their EARLIEST Records and few of them have problem with in-between Records. So, Logic would be difficult. I want to delete them manually.

Manoj Shakya,

I do have a list of all those Employees whose is having this problem. Now, I'm finding the ways to Delete them.

Nalla,

You are right, there won't be any Gaps in IT0001. In fact, there shoudln't be. But, due to Batch-Input Process, they got Loaded into Infotypes like that. You said, "if u want change the end date there is a report for new end date". Can you please provide the Report Name?

Devika,

I don't want to delete the Employees, instead, I just want to delete some of their Records. I will check this Report.

Suresh,

One of my Options was the same what you mentioned. But, when I go to SM30 in the Maintain Mode, the Time Constraint Field is not Enabled in any way, It's been Grayed out always. I guess, since IT0001 is a Master Data Infotype, So SAP doesn't allow to modify/change it's Time Constraint? Am I correct?

Guys, My questions is still unresolved. Can you please provide more inputs

[suresh_datti]

Since it is bad data anyway, I woudln't mind deleteing it deirectly from the database with an SQL statement.. Did you try RPUFIXDS? What is the outcome of this report?

~Suresh

[devika_coelho]

Hi,

If you want to delete all the data for this person you can use transaction code PU00. This will delete the entire PERNR and all infotypes.

If you just want to repair the data inconsistencies, please use report RPUFIXDS.

Devika.

[suresh_datti]

IF running the Std Program RPUFIXDS doesn't fix the inconsistencies, you can try changing the TC of 0001 from 1 to 2.. delete the unwanted 0001 records & then switch the TC back to 1.

~Suresh

[Former Member]

hai

i dont think there will be gaps in the records for IT0001 as it has got time constraint-1

according to this there should be a continuos record if i am not wrong.

secondly the next one has 12/31/9999

if u want change the end date there is a report for new end date.

regards

nalla

[Former Member]

Hi

Exactly what you want , first you have to find the employees who are having gaps in there master data fo rinfotype 1 then after searching it you have to delete the same ?

If this is a requirement then ask abaper to make a report it will work as there is some std reports through which you can delete then you have to search for those employee better what i suggest is ask for report that is the easieast and best way to do this.

Manoj Shakya

[Former Member]

Hi,

You can Use the function Module 'HR_INFOTYPE_OPERATION ' and pass the record.

Regards,

Manoj