Moving Clock-in and Clock-out data into SAP system.

[Former Member]

Requirement:

Time recording data - Clock-in and Clock-out is recorded by a time recording machine. This data (only first-in and last-out events are needed) needs to be moved into the SAP system but there is no requirement to calculate overtime i.e. the actual time recorded is not processed to get overtime details. Therefore the clock-in and clock-out data after loading in SAP system is just used in TM only to determine whether an employee is absent or present and for leave accrual.

Therefore I am trying to move this data into SAP using flat file into CC1TEV table and then post it to 2011 i.e. Time event infotype. But am getting an error because the format of the flat file seems to be incorrect (log displays truncated data in the file columns/fields ).

Need help:

(1) regarding this correct file format (2) Whether the approach taken by me is correct.

[Former Member]

your approach looks fine, but make sure you have the relevant rules in place to get the leave accruals work accordingly. Also, for the flat file, ask your programer/ technical consultant to have a look. They can tell you what went wrong. If you are not able to come up with the correct format, please ask your technical consultant to create your own interface program or a BDC since you have the entries in other system. I would prefer to have an interface extract from the other system and you can schedule a batch job to pick up the interface file and push it to 2011 on a regular basis

[Former Member]

HI,

Approach is correct to enter Time Events in SAP, just check for file format should be in

Perner Date Time event type Time

20002212 20080812 P10 (check-in) 093010

yyyymmdd hhmmss

Check whether this resolves your problem, if yes the award with points.

All the best,

Santosh