Time and Labor Data

InfoCube 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.

InfoSources
  • 0HR_PT_1 Personnel Planned Times

  • 0HR_PT_2 Personnel Actual Times

Note 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.
Additional Information About the Characteristics

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.

Additional Information About the Key Figures

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.

Additional Information About the Restricted Key Figures

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.

Data Modeling

Requires

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