Actual Time and Labor Times

Technical Name: 0HR_PT_2

Available from OLTP Release: 4.0B

Use

This DataSource contains actual time and labor data from Time Management. Data is extracted from the following Time Management infotypes and tables:

  • Absences (2001)
  • Attendances (2002)
  • Employee Remuneration Information (2010)
  • Cluster B2

You cannot distribute the data of this DataSource among several InfoPackages for the initial transfer to the Business Information Warehouse (BW).

Delta Update

This DataSource is able to deliver delta records. In delta update mode, however, it supports only the personnel number as a selection criterion. This applies even if the system displays other selection criteria. In the full update mode, the DataSource also supports the other selection criteria displayed by the system.

Technical Data

Field in Extract Structure

Description

Table of Origin

Field in Table of Origin

PERNR

Personnel number

PA0001

PERNR

ORG_UNIT_WP

Organizational Unit

PA0001

ORGEH

JOB_WP

Job

PA0001

STELL

POSITION_WP

Position

PA0001

PLANS

PERS_AREA_WP

Personnel Area

PA0001

WERKS

PERS_SUBAREA_WP

Personnel Subarea

PA0001

BTRTL

EMPL_GROUP_WP

Employee Group

PA0001

PERSG

EMPL_SUBGROUP_WP

Employee Subgroup

PA0001

PERSK

CO_AREA_WP

Master Cost Center Controlling Area

PA0001

KOKRS

COSTCENTER_WP

Master Cost Center

PA0001

KOSTL

COMP_CODE_WP

Company Code

PA0001

BUKRS

BUS_AREA_WP

Business Area

PA0001

GSBER

TIME_STATUS_WP

Employee Time Management Status

PA0007

ZTERF

BUKRS_CO

Debited Company Code

ASSOB_HR,
PA0001,
PA0027

BUKRS

GSBER_CO

Debited Business Area

ASSOB_HR,
PA0001,
PA0027

GSBER

KOKRS_CO

Controlling Area

ASSOB_HR,
PA0001,
PA0027

KOKRS

KOSTL_CO

Debited Cost Center

ASSOB_HR,
PA0001,
PA0027

KOSTL

AUFNR_CO

Order (Debited)

ASSOB_HR,
PA0001,
PA0027

AUFNR

PS_POSID_CO

Debited PSP Element

ASSOB_HR,
PA0001,
PA0027

POSNR

NPLNR_CO

Debited Network

ASSOB_HR,
PA0001,
PA0027

NPLNR

VORNR_CO

Debited Transaction

ASSOB_HR,
PA0001,
PA0027

VORNR

LSTAR_CO

Debited Activity Type

ASSOB_HR,
PA0001,
PA0027

LSTAR

KOSTL_AR

Receiver Cost Center

ASSOB_HR,
PA0001,
PA0027

KOSTL

AUFNR_AR

Receiver Order

ASSOB_HR,
PA0001,
PA0027

AUFNR

CO_PRZNR_AR

Receiver Process

ASSOB_HR,
PA0001,
PA0027

PRZNR

BUKRS_AR

Receiving Company Code

ASSOB_HR,
PA0001,
PA0027

BUKRS

GSBER_AR

Receiving Business Area

ASSOB_HR,
PA0001,
PA0027

GSBER

PS_POSID_AR

Receiver PSP Element

ASSOB_HR,
PA0001,
PA0027

POSNR

NPLNR_AR

Receiver Network

ASSOB_HR,
PA0001,
PA0027

NPLNR

VORNR_AR

Receiver Activity

ASSOB_HR,
PA0001,
PA0027

VORNR

LSTAR_AS

Sending Activity Type

ASSOB_HR,
PA0001,
PA0027

LSTAR

BUKRS_AS

Sending Company Code

ASSOB_HR,
PA0001,
PA0027

BUKRS

GSBER_AS

Sending Business Area

ASSOB_HR,
PA0001,
PA0027

GSBER

KOSTL_AS

Sender Cost Center

ASSOB_HR,
PA0001,
PA0027

KOSTL

ALP_POSITION

Different Position

PA2002, PA2003, PA2010, PCL2 (B2)

PLANS, ALP-PLANS

ALP_RATE

Different Valuation Basis

PA2002, PA2003, PA2010, PCL2 (B2)

BWGRL

REPTT

Time Type for Reporting

PA2001, PA2002, PA2010, PCL2 (B2)

AWART, LGART, ZL-LGART, ZES-ZTART

KMONTH

Cal. Year / Month

KDAY

Calendar Day

UNIT

Unit of Measure

ALP_CURRENCY

Currency Key

PA2001, PA2002, PA2010, PCL2 (B2)

WAERS, ALP-WAERS

DUR_ACTUAL

Actual Time

DUR_VALUE

Account-Relevant Time

ALP_AMOUNT

Wage Type Amount For Earnings

PA2001, PA2002, PA2010, PCL2 (B2)

BWGRL, ALP-BWGRL