Auditing Information and Payroll Data (Per In-Period)

Technical name: 0PY_PP_C1_Q001

Use

This query offers employee-specific information about personnel expenses. To access this query, double-click on a data row in query 0PY_PP2_Q001 (Posting Documents). In the same way, you can analyze employee-specific data from the posting documents that is created when posting personnel payroll results to Accounting.

The existing query displays the wage types from the payroll results of an employee per document number and document line. The data is sorted according to the end date of the in-period.

Note that for the account assignment objects in the auditing information, the account assignment objects are from the payroll results of the employee. If SAP R/3 replaces account assignment objects when posting to Accounting (for example, when posting to the substitute cost center), the new account assignment object is only contained in the payroll document and other BW info objects.

User-Defined Characteristics

Info object

Description

0PERS_AREA

Personnel area

0PERS_SAREA

Personnel subarea

0EMPLOYEE

Employee

0CO_AREA

Controlling area

0COSTCENTER

Cost Center

0EMPLSGROUP

Employee subgroup

0EMPLGROUP

Employee group

0ORGUNIT

Organizational unit

0SYMB_ACCNT

Symbolic Account

0PY_SEQNO

Sequence number of the payroll results

Lines

Info object

Description of the info object (restriction or calculation formula)

0PY_DOC_NUM

Document number

0PY_DOC_LIN

Document line items

0WAGETYPE

Wage type

0COUNTRY_ID

Country grouping

Columns

Info object

Description of the info object (restriction or calculation formula)

0END_INPER

End date of in-period (one column per end date)

0AMOUNT

Amount (per in-period)