InfoCube: 0PT_C01
This InfoCube represents the consolidated data basis used for reporting time data in the SAP Business Information Warehouse that reflects non-cumulative values, not cumulative values such as time balances. The OLTP time data is differentiated using time types for reporting, regardless of the source of the data (such as database table, function module). You have to define these time types in Customizing for OLTP. The standard system contains the following predefined time types with fixed semantics, to provide business-related context for queries and key figures:
Time Type |
Description |
00000001 |
Leave |
00000002 |
Illness |
00000003 |
Planned Time (Work Schedule Used for Time Evaluation) |
00000004 |
Overtime |
00000005 |
Productive Time |
00000009 |
Planned Time According to Personal Work Schedule |
You can assign time management data to time types and define your own additional time types in the SAP system. Possible sources of data are the time management infotypes Absences (2001), Attendances (2002), and Employee Remuneration Information (2010), and the results of time evaluation (DB PCL2 Cluster B2). The times are transferred to the SAP Business Information Warehouse using the 0HR_PT_2 InfoSource (Personnel Actual Times).
If you assign the OLTP subtypes to only a few BW time types, the OLTP data is then summarized, which results in a reduction in the amount of data transferred. If, however, the time data is transferred in its most detailed level (subtype level), you can achieve multi-level summarization rules with corresponding drilldown in the hierarchy report in the SAP Business Information Warehouse. This assumes that the hierarchies for time types have been created in the SAP Business Information Warehouse. One exception is the time type 00000009, Planned Time According to Personal Work Schedule. The origin of data records with the time type 00000009, Planned Time According to Personal Work Schedule, is always the personal work schedule. This time type does not have a corresponding database object in the HR system; the personal work schedule is always created dynamically at runtime. This also occurs during the extraction process during which the 0HR_PT_1 InfoSource, Personnel Planned Times, is supplied with data. The times in the personal work schedule are transferred to the 0PT_C01 InfoCube by the 0HR_PT_1 InfoSource under the time type 00000009. The personnel planned times and the above-mentioned personnel actual times are represented separately by the various key figures in the InfoCube (see 0PLHRS, 0WRHRS, 0DUR_VALUE, 0DUR_ACTUAL).
The InfoCube stores cumulated time data monthly in units of days and hours. Both hourly values (overtime) and daily values (leave) are required for reporting. Required key figures are derived from the raw data stored in the InfoCube. Standard derivations are available as restricted key figures (for example, Unit = Hour) and as templates along with the InfoCube (see also Restricted Key Figures). The extractor also permits daily totals to be transferred. This InfoCube is designed for key figure reports where monthly totals are sufficient. An additional summarization based on quarterly and annual key figures occurs automatically in the InfoCube. If, within a particular month, an employee’s assignment changes in the SAP HR System (a change in master cost center, for example), and the InfoCube contains the corresponding InfoObject as a characteristic, then the times are distributed to the individual areas for the relevant day and then presented separately in the report in the characteristics section.
0HR_PT_1 Personnel Planned Times
0HR_PT_2 Personnel Actual Times
Note
In addition to the InfoSources listed above, you can also use the 0HR_PT_3 InfoSource, Quota Transactions, for reports on time data. It provides time quotas and employee data from Personnel Time Management. The Quota Transactions InfoSource is not, however, linked by update rules to the Time and Labor Data InfoCube. The Quota Transactions InfoSource (0HR_PT_3) currently has no InfoCube of its own. If you want to evaluate information on time quotas, you have to create your own InfoCube.
End of the note.If external hierarchies exist for the organizational unit, 0ORGUNIT, and master cost center, 0MAST_CCTR, then you can activate one hierarchy for each column of the report by choosing the Properties option in the menu bar. This enables you to represent multi-level aggregations in hierarchy. You can also activate a hierarchy for the time type for reporting InfoObject, 0REPTT . However, you have to create it manually in the SAP Business Information Warehouse; it cannot be loaded from the OLTP. In the SAP Business Information Warehouse, the employee, 0EMPLOYEE, and person, 0PERSON, InfoObjects are differentiated by their attributes. The personal attributes that are contained in the 0PT_C01 InfoCube as navigational attributes are gender, 0GENDER, nationality, 0NATION, and language, 0PERSLANGU. The most important attributes assigned to the employee as “contract partner” of the employer (these are the first twelve entries in the characteristics table above) must be provided by the InfoSource, so that working times are distributed proportionally to the corresponding master data if the employee’s master data changes within the same month (due to a change in cost center, for example).
The personnel costs associated with the time data entered in the HR System are assigned in Payroll. If there is no explicit account assignment information accompanying the time data, then the costs are distributed according to the employee’s master data in the Organizational Assignment (0001) and Cost Distribution (0027) infotypes. Similarly, the account assignment objects 0DEBT_xxxx that can be posted to are also marked as debited in the InfoCube. If an activity assignment has taken place in the HR system, the sender (0SEND_xxxx) and receiver object (0RECV_xxxx ) are indicated accordingly. If not, then the corresponding fields are left blank.
The amount (0ALP_AMOUNT) is calculated from one of the valuation bases entered explicitly in the OLTP during time data recording, which is then multiplied by the actual hours (0DUR_ACTUAL with 0UNIT = hours). If no valuation basis is entered, the field is left blank in the OLTP. In addition, data in this field can be entered or changed using a customer enhancement of the extractor of the 0HR_PT_2 InfoSource. The actual time (0DUR_ACTUAL) acts as a container for the attendance/absence hours or days in the Absences (2001) and Attendances (2002) infotypes. The extent to which hours from time wage types or time accounts are subtotaled is specified in OLTP Customizing.
An absence of two hours can cause a time credit to be debited by a half day. For a working day of eight planned hours, this results in an account-relevant time of four hours. This derived key figure is available in reporting through the account-relevant time InfoObject (0DUR_VALUE). The extent to which hours from time wage types or time accounts are subtotaled is specified in OLTP Customizing.
Restricted key figures are derived from the key figures in an InfoCube by filtering one or more of the characteristics in an InfoCube. The illness hours (0R_SICK_HRS) result from the value of the 0DUR_ACTUAL key figure; the conditions Unit of Measurement = Hours and Time Type = Illness must be fulfilled. If they are not, the result is zero illness hours. The formulation of the condition in a customer system may have to be adjusted in line with the InfoObject characteristics and their semantics. In particular, the filter values for the units Hours and Days will deviate from the standard filter values (where STD = Hours and T = Days). The queries can only provide correct key figures when consistent conditions are formulated that conform to the InfoCube data provided.
Object Type | Name | Technical Name |
|---|---|---|
InfoObject | Wage type amount for payments | 0ALP_AMOUNT |
InfoObject | Alternative Position | 0ALP_POSTN |
InfoObject | Business area | 0BUS_AREA |
InfoObject | Calendar Year/Month | 0CALMONTH |
InfoObject | Calendar Year/Quarter | 0CALQUARTER |
InfoObject | Calendar Year | 0CALYEAR |
InfoObject | Change Run ID | 0CHNGID |
InfoObject | Company code | 0COMP_CODE |
InfoObject | Controlling area | 0CO_AREA |
InfoObject | Controlling Area of Master Cost Center | 0CO_MST_AR |
InfoObject | Currency Key | 0CURRENCY |
InfoObject | Debited Activity Type | 0DEBT_ACTT |
InfoObject | Debited Activity | 0DEBT_ACTVY |
InfoObject | Debited Business Area | 0DEBT_BUSA |
InfoObject | Debited Cost Center | 0DEBT_CCTR |
InfoObject | Debited Company Code | 0DEBT_CMPC |
InfoObject | Debited Functional Area | 0DEBT_FAREA |
InfoObject | Debited Fund | 0DEBT_FUND |
InfoObject | Debited Grant | 0DEBT_GRANT |
InfoObject | Debited Network | 0DEBT_NETW |
InfoObject | Debited Order | 0DEBT_ORDER |
InfoObject | Debited WBS Element | 0DEBT_WBS_E |
InfoObject | Actual Time | 0DUR_ACTUAL |
InfoObject | Account-Relevant Time | 0DUR_VALUE |
InfoObject | Employee Group | 0EMPLGROUP |
InfoObject | Employee | 0EMPLOYEE |
InfoObject | Employee Subgroup | 0EMPLSGROUP |
InfoObject | Financial management area | 0FM_AREA |
InfoObject | Debited FM Area | 0FM_AREA_CO |
InfoObject | Functional area | 0FUNC_AREA |
InfoObject | Fund | 0FUND |
InfoObject | Grant | 0GRANT_NBR |
InfoObject | Position | 0HRPOSITION |
InfoObject | Job | 0JOB |
InfoObject | Master Cost Center | 0MAST_CCTR |
InfoObject | Organizational Unit | 0ORGUNIT |
InfoObject | Person | 0PERSON |
InfoObject | Personnel Area | 0PERS_AREA |
InfoObject | Personnel Subarea | 0PERS_SAREA |
InfoObject | Planned Time According to Personal Work Schedule | 0PLHRS |
InfoObject | Record type | 0RECORDTP |
InfoObject | Receiver Activity | 0RECV_ACTVY |
InfoObject | Receiver Business Area | 0RECV_BUSA |
InfoObject | Receiver Cost Center | 0RECV_CCTR |
InfoObject | Receiver Company Code | 0RECV_CMPC |
InfoObject | Receiving Functional Area | 0RECV_FAREA |
InfoObject | Receiving Fund | 0RECV_FUND |
InfoObject | Receiving Grant | 0RECV_GRANT |
InfoObject | Receiver Network | 0RECV_NETW |
InfoObject | Receiver Order | 0RECV_ORDER |
InfoObject | Receiver Process | 0RECV_PROCS |
InfoObject | Receiver WBS Element | 0RECV_WBS_E |
InfoObject | Reporting Time Type | 0REPTT |
InfoObject | Request ID | 0REQUID |
InfoObject | Sender Activity Type | 0SEND_ACTT |
InfoObject | Sender Business Area | 0SEND_BUSA |
InfoObject | Sender Cost Center | 0SEND_CCTR |
InfoObject | Sender Company Code | 0SEND_CMPC |
InfoObject | Sending Functional Area | 0SEND_FAREA |
InfoObject | Sending Fund | 0SEND_FUND |
InfoObject | Sending Grant | 0SEND_GRANT |
InfoObject | Employee Time Management Status | 0TIME_STAT |
InfoObject | Unit of Measure | 0UNIT |
InfoObject | Planned Time Without Public Holidays | 0WRHRS |