iTime Clock Punch Data

DataStore object: 0ITC_DS05

This DataStore object (DSO) contains the punch data from iTime Clock. Each single punch entered in iTime Clock is registered in the corresponding source table SAPITC_TIME_EVENTS, and is stored in this DSO. The DSO contains, besides a generic handle ID (GUID number); the organization, the employee, the punch date, and the punch time, in the key. To have more flexibility in the reporting, the time characteristics Day and Week are part of the DSO and are filled from Start Date. The data can be used for reporting requirements like Actual punches by employee or employee time sheet.

The DSO object is connected to DataSource 0WFM_ITC_TIME_EVENTS. Because of a missing conversion in iTime Clock, we need to convert the fields Entry Handle, Time Event Work Area, and Created By in the transformation.

Structure

Delta Update

The following delta update is supported for this DataStore object:

Delta update: regular delta in data transfer process
DataSource: 0WFM_ITC_TIME_EVENTS

Data Modeling

Key Fields
Object Type	Name	Technical Name
Characteristic	WFM Employee	0CRM_WFMBP
Characteristic	Organizational Unit	0ORGUNIT
Characteristic	WFM Handle ID	0WFM_HNL_ID
Characteristic	iTime Clock Punch Date	0WFM_PUDT_O
Characteristic	iTime Clock Punch Time	0WFM_PUTM_O

Data Fields
Object Type	Name	Technical Name
Time characteristic	Calendar Day	0CALDAY
Time characteristic	Calendar Year/Week	0CALWEEK
Characteristic	Last Changed on	0CHANGEDATE
Characteristic	Changed by	0CHANGEDBY
Characteristic	Name of person who created the object	0CREATEDBY
Characteristic	Date on which the record was created	0CREATEDON
Characteristic	WFM Work Area	0CRM_WKARA
Data packet characteristic	BW Delta Process: Update Mode	0RECORDMODE
Characteristic	iTime Clock HR Export of Calc. Result	0WFM_HR_EXP
Characteristic	WFM Personnel Number	0WFM_PERNR
Characteristic	iTime Clock Time Event Type	0WFM_TETP_O
Characteristic	iTime Clock Terminal ID	0WFM_TRM_ID