Auditing Information

Technical name: 0HR_PY_PP_1

Technical Data

Type of DataSource

Transaction data (movement data)

Application Component

Payroll/Posting to Accounting

PY-XX-DT

Available as of OLTP Release

SAP R/3 4.0B

Available as of plug-in Release

2001.2

RemoteCube compatible

No

Use

An important aspect of posting payroll results to Accounting is the ability to trace individual line items, especially when audits take place. The following concept applies:

SAP R/3 summarizes the information in the posting documents so that they do not contain any information on the personnel number level. In this way, it ensures that Accounting components are only provided with the information they require while simultaneously preventing unauthorized persons from accessing personal data. DataSource 0HR_PY_PP_2 (Posting Documents) exists for information that reaches Accounting components in this manner.

Even though postings are summarized, it is always possible to break them down again because SAP R/3 creates a posting index of processed payroll results when posting data is summarized (tables PPOIX and PPOPX).

Note that the posting index contains account assignment objects from employees’ payroll results. If SAP R/3 replaces account assignment objects when data is posted to Accounting (such as when data is posted to the substitute cost center), the new account assignment object is only included in the posting document. This means there is little point in comparing account assignment objects in DataSource 0HR_PY_PP_1 (Auditing Information) with account assignment objects in DataSource 0HR_PY_PP_2 (Posting Documents).

SAP R/3 only allows you to trace line items back to a specific employee’s payroll result if you have special authorization to do so. You must take the appropriate steps to ensure that this data is also protected from unauthorized access in the BW System.

DataSource 0HR_PY_PP_1 (Posting Index) enables you to transfer the information contained in the posting index to BW. This DataSource only supports run type PP (Payroll Posting).

For more information on posting payroll results to Accounting, access the SAP Library and choose Human Resources ® Payroll ® Payroll <country> ® Subsequent Activities ® Posting to Accounting.

Delta Update

This DataSource supports delta updates. The source system fills table HRMS_BIW_PPDELTA with the date and time of the first data transfer (initialization) and the date and time of all subsequent data transfers. This information enables the system to perform a delta transfer. It only selects posting runs with the above statuses whose last changed on date is after the date in table HRMS_BIW_PPDELTA.

If you use DataSources 0HR_PY_PP_2 (Posting Documents) and 0HR_PY_PP_1 (Auditing Information), you must transfer data to BW from both DataSources using the same selection criteria.

Origin Fields in the Extraction Structure

Field in extraction structure

Description of field in extraction structure

Table of origin

Field in table of origin

PERNR

Personnel number

PPOIX

PERNR

ACTSIGN

Indicator for status of record

PPOIX

ACTSIGN

RUNID

Number of posting run

PEVSH

RUNID

POSTNUM

Number

PPOIX

POSTNUM

REVDOC

BIW flag (data record created because run was reversed)

This indicator is set internally if the system creates an index line for reversal documents in the extractor.

WERKS

Personnel area

WPBP/DOWP

WERKS

BTRTL

Personnel subarea

WPBP/DOWP

BTRTL

PERSG

Employee group

WPBP/DOWP

PERSG

PERSK

Employee subgroup

WPBP/DOWP

PERSK

PLANS

Position

WPBP/DOWP

PLANS

ORGEH

Organizational Unit

WPBP/DOWP

ORGEH

DOCNUM

Document number

PPOIX

DOCNUM

DOCLIN

Line number of document

PPOIX

DOCLIN

MOLGA

Country grouping

RGDIR

MOLGA

LGART

Wage type

PPOIX

LGART

BUKRS

Company code

WPBP/DOWP

C0/D0C0

C1

BUKRS

KBUNN

BUKRS

GSBER

Business area

WPBP/DOWP

C0/D0C0

C1

GSBER

KGBNN

BUKRS

KOKRS

Controlling area

C1

KOKRS

KOSTL

Cost center

WPBP/DOWP

C0/D0C0

C1

KOSTL

KSTNN

KOSTL

AUFNR

Order

C0/D0C0

C1

AUFNN

AUFNR

KSTRG

Cost object

C1

KSTRG

LTLST

Activity type

C1

LTLST

POSNR

WBS element

C1

C0

POSNR

PSPNN

NPLNR

Network

C1

NPLNR

VORNR

Operation

C1

VORNR

KDAUF

Sales order number

C1

KDAUF

KDPOS

Item number in sales order

C1

KDAUF

KOMOK

Transfer to FI/CO: symbolic account

PPOIX

KOMOK

MOMAG

Transfer to FI/CO: employee grouping for account determination

PPOIX

MOMAG

FIKRS

FM area

FUND

FIKRS

FISTL

Funds center

WPBP/DOWP

C0/D0C0

C1

FUND

FISTL

FISTL

FISTL

FISTL

GEBER

Fund

WPBP/DOWP

C0/D0C0

C1

FUND

GEBER

GEBER

GEBER

GEBER

ANZHL

Payroll: Number

PPOIX

ANZHL

MEINS

Basis unit of measure

PPOIX

MEINS

BETRG

Payroll: Amount

PPOIX

BETRG

WAERS

Currency key

PPOIX

WAERS

FPEND

End of the payroll period (for-period)

RGDIR

FPEND

IPEND

End of the payroll in-period

RGDIR

IPEND

PAYDT

Date of payment of payroll results

RGDIR

PAYDT

TRANSFERDATE

BIW: Date of the document or reversal document transfer according to FI/CO

PEVSH

CREADATE

FIPEX

Commitment item

C1

FUND

FIPOS or FIPEX

FIPEX

AUART

Expenditure type

FUND

AUART

ERRORFLAG

BIW flag (error message for payroll results consistency)

is used internally for error handling

FKBER

Function area

WPBP/DOWP

C0/D0C0

C1

C0

FKBER

FKBER

FKBER

FKBER

GRANT_NBR

Grant

WPBP/DOWP

C0/D0C0

C1

C0

FKBER

FKBER

FKBER

FKBER

AWTYP_PRE

Preceding document: Reference procedure

FUND

AWTYP

AWKEY_PRE

Preceding document: Object key (AWREF_REV and AWORG_REV)

FUND

AWKEY

AWPOS_PRE

Preceding document: Reference line item

FUND

AWPOS

SEQNO

Sequence number of the payroll results

PPOIX

SEQNO

Special Features of the Extractor

The extractor is dependent on the release of the SAP R/3 source system. The overview of the fields of the extractor structure shows all fields that are contained in SAP R/3 Enterprise in the extractor structure. If the SAP R/3 source system has a lower release status, individual fields can be empty or not available.