Posting Documents

Technical name: 0HR_PY_PP_2

Technical Data

Type of DataSource

Transaction 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

Prerequisites

Use

This DataSource provides data that is contained in posted or reversed posting documents. Posting documents are created when payroll results are posted to Accounting. They contain all the information that is transferred by SAP R/3 when data is posted to Accounting.

A posting document is used by Accounting components as a source document for the creation of further documents. These accounting documents include a reference to the posting document on which they are based. However, this DataSource only contains data from the posting document.

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. 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). DataSource 0HR_PY_PP_1 (Auditing Information) enables you to transfer the information contained in the posting index to BW.

The reversal document is a special type of posting document. Its structure is the same as that of the posting documents created for a regular posting. SAP R/3 creates reversal documents if you reverse the posting documents of a posting run. This DataSource can include data from posting documents and reversal documents.

SAP R/3 groups posting documents together to form posting runs. All activities relating to posting documents can only ever be performed for all of the posting documents that belong to a posting run. Therefore, the status of a posting run applies to all of the posting documents that it contains. The DataSource contains data from posting documents that are included in posting runs with the following statuses:

Status

Meaning

40

Documents transferred

Note: this status is assigned to posting runs if you use Human Resources and Accounting in separate systems that communicate with each other via an ALE connection. This status has the same meaning as the Documents posted status.

50

Documents posted

63

Reversal documents posted

64

Reversal documents transferred

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

DOCNUM

Document number

PPDHD/PPDIT

DOCNUM

DOCLIN

Line number of document

PPDIT

DOCLIN

TYPE

Run type

PPDHD

TYPE

BUKRS

Company code

PPDHD/PPDIT

BUKRS

KTOPL

Chart of accounts

derived by BAPI from field BUKRS (company code)

KOKRS

Controlling area

derived by BAPI from field BUKRS (company code)

PERIV

Fiscal year variant

derived by BAPI from field BUKRS (company code)

FISCAL_YEAR

Fiscal year

PPDHD

FISCAL_YEAR

FISCAL_MONTH

Fiscal period

PPDHD

FISCAL_MONTH

BUDAT

Posting date in the document

PPDHD

BUDAT

HKONT

General ledger account in G/L accounting.

PPDIT

HKONT

KUNNR

Customer number 1

PPDIT

KUNNR

LIFNR

Account number of the vendor or creditor

PPDIT

LIFNR

GSBER

Business area

PPDIT

GSBER

PERNR

Personnel number

PPDIT

PERNR

KOSTL

Cost center

PPDIT

KOSTL

AUFNR

Order

PPDIT

AUFNR

KSTRG

Cost object

PPDIT

KSTRG

POSNR

WBS element

PPDIT

POSNR

NPLNR

Network

PPDIT

NPLNR

VORNR

Operation

PPDIT

VORNR

KDAUF

Sales order number

PPDIT

KDAUF

KDPOS

Item number in sales order

PPDIT

KDPOS

LTLST

Activity type

PPDIT

LTLST

FIKRS

FM area

derived by BAPI from field BUKRS (company code)

FISTL

Funds center

PPDIT

FISTL

GEBER

Fund

PPDIT

GEBER

MENGE

Payroll: number

PPDIT

MENGE

MEINS

Base unit of measure

PPDIT

MEINS

WRBTR

Payroll: amount

PPDIT

WRBTR

WAERS

Currency key

PPDIT

WAERS

TRANSFERDATE

BIW: date on which document or reversal document transferred to FI/CO

PEVSH

CREADATE

FIPEX

Commitment item

PPDIT

FIPEX

FKBER

Functional area

PPDIT

FKBER

GRANT_NBR

Grant

PPDIT

GRANT_NBR

AWTYP_PRE

Preceding document: reference activity

FUND

AWTYP

AWKEY_PRE

Preceding document: object key (AWREF_REV and AWORG_REV)

FUND

AWKEY

AWPOS_PRE

Preceding document: reference document activity

FUND

AWPOS

Features of Extractor

The extractor is dependent on the release of the SAP R/3 source system. The overview of fields in the extraction structure shows all of the fields included in the extraction structure of SAP R/3 Enterprise. If the SAP R/3 source system has a lower release status, individual fields may be empty or unavailable.