Cross-Application Time Sheet (Old)

Technical name: 0CATS_1

For BW 3.0B, this InfoCube will be replaced by two new InfoCubes, 0CA_TS_C01 (Time Sheet Data (Approved)) and 0CA_TS_C02 (Time Sheet Data (for Approval)).


This InfoCube contains all the actual times recorded in the Cross-Application Time Sheet that were uploaded from the source system(s). The data is transferred to the InfoCube via the Time Sheet Data InfoSource (0CATS_IS_1).

You can use this InfoCube to run reports on activities performed, such as the amount of time worked on particular projects. You can evaluate the data according to various attributes, such as:

·        Employees’ organizational assignment (personnel area, master cost center, employee grouping...)

·        Time type for reporting

·        Receiver account assignment

·        Sender account assignment (purchase order, purchase order item, and activity number are not available)

You can use calendar day, calendar year/month, calendar year/quarter and so on as time dimensions.

The InfoObject Time Type for Reporting (0REPTT) can be supplied by attendances and absences and wage types from the R/3 source system. You define the assignment of attendances/absences and wage types in OLTP Customizing for InfoSource 0HR_PT_2 (Employee Actual Times). Note that 01 must always be used as the rule group for all employees. Time evaluation results cannot be used in this InfoCube for the InfoObject Time Type for Reporting.  

For more information, see the documentation on the Time and Labor Data InfoCube (0PT_C01).

Hierarchies are supported for various InfoObjects, such as the master cost center, receiver cost center, organizational unit, receiver WBS element.

In the Business Information Warehouse, the InfoObjects Employee (0EMPLOYEE) and Person (0PERSON) differ in their attributes. The personal attributes of Gender (0GENDER), Nationality (0NATION), and Language (0PERSLANGU) are included in the InfoCube 0PT_C01 as navigation attributes. The most important attributes assigned to the employee as “contract partner” of the employer must be provided by the InfoSource, so that working times are distributed proportionally (prorated) to the corresponding master data if the employee’s master data changes within the same month (a change in cost center, for example).

The system also reads the InfoObjects Project Definition (0PPROJECT) and Person Responsible (PS_RESPNO) from the master data of InfoObject Receiver WBS Element (0RECV_WBS_E).