Upload of Time attendance data to SAP for Payroll Process.

[Former Member]

Dear SAP Gurus,

Kindly let me know the process of Upload of Time attendance data to SAP for Payroll Process.

The process should be based for End user.

Thanks in advance.

Arun

[sikindar_a · Accepted solution]

Time Attendence

if it for mass go for BDCs as ur ABAPER to Create the Recording for IT 2002 so that the user Updates the record useing the BDCs

[Former Member · Accepted solution]

It is for mass but as a monthly process.

[sikindar_a · Accepted solution]

Even though it is monthly

the time data will be MASS for the Employees

right u need to upload for 200 to 300 people atleast right

[Former Member · Accepted solution]

Yes Its right. We have different manufacturing locations and one corporate office. We are required to upload the time attendance data functionally from all the manufacturing locations.

In and all, the employee count will be above 3000 employee frm all over locations.

[Former Member · Accepted solution]

One more thing, a HR person can collect the time attendance data from attendance data capturing software. Which is in an Excel sheet. What would be the steps for upload the same through LSMW ?

Kindly note that, our company is not havning ESS.

Thanks in advance

Arun

[sikindar_a · Accepted solution]

As and fucntional

Shd ask ur ABAPER to design the Programme to fetch the data from time machine software into Excel

and import that result into SAP

daliy basis , or monthly basis BDCs or LSMW is best for LSMW

check the LAST Four steps iam giveing the full LSMW

. TCode : LSMW.

2. Enter Project name, sub project name and object name.

Execute.

3. Maintain object attributes.

Execute

select Batch Input recording

goto->Recording overview

create

recording name.

enter transaction code.

start recording

do recording as per ur choice.

save + back.

enter recording name in lsmw screen.

save + back

Now there will be 14 steps.

2. MAINTAIN SOURCE STRUCTURES.

Here you have to enter the name of internal table.

display change

create

save + back

3. MAINTAIN SOURCE FIELDS.

display change

select structure

source_fields->copy fields.

a dialogue window will come .

select -> from data file

apply source fields

enter No. of fields

length of fields

attach file

save + back

4. MAINTAIN STRUCTURE RELATIONS

display change

save + back

5. MAINTAN FIELD MAPPING & CONVERSION RULE

display change

click on source field, select exact field from structue and enter

repeat these steps for all fields.

save+back

6. MAINTAIN FIXED VALUES, TRANSACTION, USER DEFINED

execute

save + back

7. SPECIFY FILES.

display change

click on legacy data

attah flat file

give description

select tabulatore

enter

save + back

8. ASSIGN FILE

execute

display change

save + back

9. IMPORT DATA.

execute

display change

save + back

10. DISPLAY IMPORTED DATA

enter ok, it willl show records only.

back

11. CONVERT DATA

execute

display change

save + back

12. DISPLAY CONVERTED DATA

execute

display change

save + back

13. CREATE BATCH INPUT SESSION

tick keep batch input folder

F8

back

14. RUN BATCH INPUT SESSION.

sm35 will come

Object name will be shown here

select object & process

[Former Member · Accepted solution]

Dear Sikindar,

That's fab. Thankyou very much.

Regards

Arun

[Former Member]

Hi

I there any way, how to import attendance data (for many employers) from external attendance system to SAP? (How file typu for import are supported? Is there some pattern file?)

Or I must create my own program for this?

Thank you

[former_member223911]

Dear

did you find any solution regarding this ?? cause I need to know to transfer attendance data (clock in and out from attendance system to SAP )

[Former Member]

Hi

I  create own program for this.

Best regards

[former_member223911]

thanks dear for your support

do you mean its ABAP work not HCM functional ?? cause I need to know to transfer the data from the machine to SAP (for example into infotype 2011)

thanks in advance

[Former Member]

Hi,

Functionally it is possible but it will be very complex and it may include IDOC.

Now a days no one uses that standard functionality to upload machine punches.

Hence, You may develop a custom report to fetch the raw punch details from either application server or FTP server and upload it to TEVEN using standard Function Module.

PS: DO NOT user HR_INFOTYPE_OPERATION.

Thanks,

Ketul

[former_member223911]

Dear

really I don't know how to thank you for your support

but i'm HCM functional consultant that's why I don't know what's my role exactly and what's the ABAP and Basis roles

if you can clarify the solution for me how to transfer the clock in and out from the machine server to SAP ( in infotype 2011 or even any other solution ) i'll be thankful

thanks in advance
muhammed azim

[Former Member]

hi

go with BDC as sikindar said

[Former Member]

Kindly provide me step by step process.

[Former Member]

Hi,<br> You have to prepare PPT based on the time entry point - CATS or Time manager Work place or PA ITs - 2001 ,2002 ,2010, etc or upload time data in SAP from the interfaces through BDC program. Refer to the below links and prepare PPT. [Link 1|http://www.authorstream.com/Presentation/akhileshdubey-92422-time-management-sap-hr-hr007-mgt1-business-finance-ppt-powerpoint/] [Link 2|http://help.sap.com/bp_serv603/BBLibrary/Documentation/266_Scen_Overview_EN_DE.ppt] [Link 3|help.sap.com/bp_dbmv1600/DBM_DE/Documentation/AB0_Scen_Overview_EN_DE.ppt -] [Link 4|http://www.insightcp.com/res_11.html] [Link 5|http://www.polk-fl.net/staff/technology/helpdesk/documents/SAPPAY_CATSCrossApplicationTimeSheetPositiveTime.pdf] [Link 6|http://help.sap.com/bp_dbmv1600/DBM_DE/Documentation/AB0_Scen_Overview_EN_DE.ppt#562,12,Slide 12] Good luck<br><br> Thanks, Amosha <br><br>"Known is a drop & unknown is an OCEAN!"