How we know that in SAP HR Tables that record is newly created or modified

[Former Member]

Dear All,

I have a problem that suppose we created new emplyoee then one record is created in database table and suppose we made some changes in that then also same record is updated in data base table.

i have to know that the particular record is newly created or modified .

Thanks in advance.

Santosh Kumar

[former_member508729]

Hi,

After you create a new record into database table you will have key field values for that record with you..

then after creating the record use commit work and then put one select query on that db table for that key value and if sy-subrc eq 0 then you can say like record is created into the database.

Regards

Ashutosh

Reward points if helpful

[Former Member]

You can check the table log (if it is enabled), or many tables have date n time stanp you can use that values to check the record.

[Former Member]

table name is CACS_HRLOG - Logging of HR Master Data Changes..

but it will contain no data as for the sap standard tables in Technical setting the checbox logging shud be checked..

otherwsie it will not log changes..

hope this helps..

amit

[Former Member]

We had a similar requirement where we needed to extract new starters for a interface into a third-party payroll system.

We implemented BADI HRPAD00INFTY, and used the IN_UPDATE method to write out the payroll number to a Z table. Then the extract program updated the record with an extract date.