Planned Costs per Cost Object (Transaction Data)

Technical name: 0HR_PACP_2

Technical Data

Type of DataSource

Transaction data

Application Component

Personnel Cost Planning and Simulation (PA-CP)

Available as of OLTP Release

SAP R/3 Enterprise HR Extension 2.0

RemoteCube Compatibility

No

Prerequisites

You have made the necessary settings in the source system in Customizing for Personnel Cost Planning and Simulation. You have performed the following:

·        Planning preparation

·        Data collection

·        Cost planning runs

You have performed data collection for the cost objects for which you want to report on the direct cost items in the Business Information Warehouse.

Use

This DataSource retrieves data from data collection for employees and organizational objects. This includes cost items for the cost objects Employee, Position, Job, and Organizational Unit. Cost items for employees are stored in infotype Planning of Personnel Costs (0666) whereas cost items for organizational units are stored in infotype Planning of Personnel Costs (5010). You can transfer the cost items in a calendar month view or in a posting period view.

Delta Update

This DataSource does not support delta updates.

Fields of Origin in the Extract Structure

Field in Extract Structure

Description of Field in the Extract Structure

Table of Origin

Field in Table of Origin

AMOUNT

Amount

PA0666 or HRP5010

BETRG

CURRENCY

Currency Key

WAERS

HCP_CITM

Cost Item

CITEM

HCP_DBAS

Data Basis for Personnel Cost Planning

DATABASIS

HCP_NUMB

Number (Non-Cumulative Value)

ANZHL

QUANTITY

Quantity

ANZHL

UNIT

Unit of Measure

UNIT

CP_EMPLOY

Cost Object Employee

PA0666

PERNR

COUNTRY_ID

Country Grouping

HRP5010

MOLGA

CP_JOB

Cost Object Job

OBJID

CP_ORGUNIT

Cost Object Organizational Unit

OBJID

CP_POSITIO

Cost Object Position

OBJID

HCP_PCON

Planning Context

T77HCP_SCEN

PCONT

HCP_SCEN

Personnel Cost Planning Scenario

SCENARIO

CALMONTH

Calendar Year/Month

Derived from different tables and fields

FISCPER

Fiscal Year/Period

FISCVARNT

Fiscal Year Variant

HCP_STYP

Record Type of Cost Data

Taken from selection

OBJID

Object ID

Only used for selection

OTYPE

Object Type for Predecessor

Features of Extractor

The extractor reads data contained in the fields BETRG, WAERS, CITEM, DATABASIS, ANZHL, and UNIT from the following tables of origin:

·        Table PA0666 for planning data for the cost object Employee

·        Table HRP5010 for planning data for the cost objects Position, Job, and Organizational Unit

From the data contained in the fields BETRG and ANZAHL from table PA0666 or HRP5010, the extractor calculates the values for the fields AMOUNT or HCP_NUMB or QUANTITY in the extract structure. In other words, it does not simply transfer data 1:1 from the origin table to the extract structure. It transfers data from the field ANZHL, from table PA0666 or HRP5010, to either the field HCP_NUMB or QUANTITY. The cost item type, specified in the field CITEM in the tables PA0666 or HRP5010, dictates to which field it transfers data.

The extractor transfers data from the field OBJID in table HRP5010 to one of the following fields in the extract structure:

·        CP_ORGUNIT

·        CP_POSITIO

·        CP_JOB

The object type dictates to which field the extractor transfers data. You specify the object type in the field OTYPE during selection when you extract data.

The field COUNTRY_ID in the extract structure is only filled for the cost object Job.

You only use the following fields in the extract structure when extracting data:

·        CALMONTH (required entry field)

·        HCP_DBAS (required entry field)

·        HCP_PCON (required entry field)

·        HCP_SCEN (required entry field)

·        HCP_STYP (required entry field)

In this field, you specify whether planning data should be transferred in the calendar month view or in the posting period view. Depending on the view you specify, the extractor fills either the field CALMONTH or the fields FISCPER and FISCVARNT in the extract structure:

Ў        If you enter 1 (calendar months) in the field HCP_STYP, the extractor fills the field CALMONTH.

Ў        If you enter 2 (posting periods) in the field HCP_STYP, the extractor fills the fields FISCPER and FISCVARNT.

·        OBJID (optional field)

This field is only for selection purposes.

·        OTYPE (optional field)

This field is only for selection purposes.