How to insert attendance data in system for Time Mgt and Payroll...

[Former Member]

Dear All,

Plz tell me, how can we insert the data of attendance of 250 emplyees ...the time sheet has came from any other system (bio-metric and can be explored in excel sheet)...for TM and Payroll operations...

If we can do it with CATS then elaborate it from start to end...or suggest any other option which can be done by the end users on monthly basis...

Thanx

Amol

[siddharthrajora · Accepted solution]

You need to make use of the BAPI to update the records in CATSDB for all the employees

BAPI_CATIMESHEETMGR_INSERT

Usually if you have diverse systems, You can use BAPI to post data in the infotypes or in this case

CATSDB, and then you can transfer it to HR using CAT6

Also you can give access to employees to cat2 so that you dont have to do this manually

[Former Member · Accepted solution]

hi...

Is there any coding is required for it...or it is a pretty configered set of programmes by that we can transfer this attadance data from excel sheet to to the system...

Thanks....plz ebaborate the answer...

Amol

Edited by: Amolkumar Patil on May 6, 2009 12:24 PM

[Former Member · Accepted solution]

LSMW is fisible solution if you want it to go to 2011 infotype or any other time infotype but if you are looking at inserting this data in catsdb table then look at writing an upload program using RFC CATS_SAVE_CATSDB.

[Former Member · Accepted solution]

Hi...

From end users point of view...LSMW will be more complecated process...how can we do it in any other easy way...Plz elaborate the answer...

Amol

[Former Member · Accepted solution]

oh do you mean end user meaning ESS user or HR user?

[Former Member · Accepted solution]

oh do you mean end user meaning ESS user or HR user?

[Former Member · Accepted solution]

in that case build a upload pgm using the rfc mentined. that is simple... in any case

Edited by: Barin Desai on May 6, 2009 4:21 PM

[Former Member]

thnx..

[siddharthrajora]

This is the simple way of doing it, BAPI has all the coding, You dont need to do anything except call

it, Please check se37> BAPI_CATIMESHEETMGR_INSERT

and read the docs on it