I want to update to BEGDA field in 0002 infotype for lakhs of records

[Former Member]

Hi All,

Appreciate your help.  We have a requirement where we need to update begin date (BEGDA) with value '01/01/1900' ( without overlapping)  all records in PA0002 table.  This is beacause BEGDA stores Date of Birth Value and clients do want Date of Birth value to be stored in system. 

I do want to use either Update ABAP SQL statement or do recording (BDC recording).  I do want to use HR_INFOTYPE_OPERATION FM and update records.  

I have tried using FM HR_INFOTYPE_OPERATION with operation 'MOD' but this updates all other fields in PA0002 table but not BEGDA reason being it is a primary key. Please let me the solution how can i update BEGDA record(primary key) using FM HR_INFOTYPE_OPERATION or  any other standard FM/BAPI which i can use.

[Former Member · Accepted solution]

I got the solution.

We can use FM only  'HR_INFOTYPE_OPERATION' for updating primary field (BEGDA) also in 0002/PA0002 table.  The sample code is shown below

p0002-begda = '19000101'.

CALL FUNCTION 'HR_INFOTYPE_OPERATION'
    EXPORTING
      infty         = '0002'
      number        = p0002-pernr
      validityend   = p0002-endda
      validitybegin = p0002-begda
      recordnumber  = p0002-seqnr
      record        = p0002
      operation     = 'INS'
      nocommit      = ' '

    IMPORTING
      return        = ls_return.

The operation INS will overwrite the existing record if record already exists. So here it will just overwrite the existing record with BEGDA(New value).

[Former Member]

Hi,

If you change the Start Date in the IT 0002 which is Employee DOB then your employee is having age more than 100+ years. do you know what is the effect in the system with these changes ?

how you pay the employee statutory and mainly in Form-16 will get problem.

specify your exact client requirement, accordingly suggestions will be given.

Best Regards,

Praneeth kumar

[Former Member]

Hi praneet,

We do have seperate SAP systems for HR master data and HR payroll.

I work in SAP Learning systems, so we dont have any impact by chaging Date of Birth, ultimately we do not want to store date of birth in our system (BEGDA).

So please let us know the solution.

[Former Member]

Hi,

There is no specific report to change Start date for Infotypes like changing of BEGDA for OM Objects, you need to go with LSMW / BDC program only.

[Former Member]

Thank you praneet.

I will just check with others, if any one of you have come across the same requirement, please inform me the solution you had, is it LSMW and BDC only ?

[Former Member]

Hi,

I changed BEGDA with LSMW only

[venkat_polisetty]

Hi,

We have a standard program to change the start date of OM objects.

With using "RE_RHBEGDA0" this transaction we can change the start date of OM objects.

Regards,

Venkat Polisetty

[Former Member]

Hi Venkat,

Reddy want to change the start date of InfoType not the OM Object.

[Former Member]

Thanks praneet.

Yes Venkat, I do want to change Begin Date (BEGDA) for infotype 0002. Not OM object.

[venkateshorusu]

Before doing this analyze all functionalities wrt IT0002 BEGDA.

Since it has been used in many standard programs, Changing can be happened some how but after changing it how system behaves is most important.

Regards

Venkatesh