Information missing if only partial authorization exists

Problem: You have information missing only if partial authorization exists. Solution: The infotype-statement in a report based on logical database PNP tells the database to provide all the records of an existing infotype. If the relevant user is not authorized for at least one of those records, the access to […]

Text Identification in SAP Query

Symptom You want to understand how Text Identification is done in SAP Query. Solution As of release 45B a method for identifying text is available in the query. In this release, this method only works in infosets based on logical databases PAP, PCH and PNP. This method determines the field text […]

Repeat fields

What is a ‘repeat field’? A repeat field is an infotype field which exists more than once. The names of these fields all have the same master and are extended with a sequential number. ExampleThe fields ‘date type’ and ‘date’ from infotype 0041 are repeat fields. The repeat field sequence […]

Locked records in query

Problem: When you run a query you receive errors of Locked records. Solution: By default, locked infotype records (those ones with field SPRPS equeal to X) are not selected by the query. If you need to report on these infotypes, then you need to activate this switch (SQ02, edit, GOTO […]

Issue with IT0022

The output of the ad-hoc query doesn’t contain all IT0022 records. Reason: IT0022 records can be created also before the hire date. To receive data the time periods of the selected infotypes must overlap regardless of the reporting period. If we select employees by IT0000 (PA0000-PERNR) the IT0022 records with […]

Issues with infotype 0021 and view infotypes

Symptom Some infotypes like infotype 0021, have infotypes views assigned in table V_T582V. Cause The query is not always aware that infotypes belong together as it is a general tool. Infotypes which we may consider related are not recognized as such by the ad-hoc. We will take as example here […]

While creating a record in IT0585 through PA30 error message comes

Problem Description While creating a record in IT0585 through PA30 An error message comes up “No of entries in table exceeded 21” Cause of the Problem Due to the correction of the note 1706872 no of entries gots limited to 21, So in case of increase of entry, the system […]

Transactions and Reports in PY-IN

List of transaction for India Payroll – Transaction Description Transaction Description PC00_M40_ALR Allowance Restructuring PC00_M40_ANN Payroll annual display – India PC00_M40_BONS Bonus Calculation – India PC00_M40_BSG Basic – General Increments PC00_M40_BSP Basic – Promotions PC00_M40_CALC Payroll program – India PC00_M40_CALC_SIMU Payroll simulation India PC00_M40_CBLIST Cash breakdownlist – India PC00_M40_CDTA Payroll-transfer-prelimProg. […]

Legal Reports in PY-RU

HRULRSV1 – report to prepare form RSV-1 in the format that the Russian Pension Fund requires. HRUL4FSS – report to generate form 4-FSS in the required legal format, which you file with the Russian Social Insurance Fund (FSS) every quarter. HRULSTAT – Statistical Data Preparation / Statistical Data Processing. HRULP4 – Statistic […]

Payroll relevant tables in PY-RU

Tables with payroll objects T52A0 – object types (FU -function, OP – operation) with internal codes (INUMB) and text. Internal object number. Contains names of payroll functions and operations T52B1 – object classes (POTYP i. e. SCHE – payroll schema) T52B2 – object attributes (PATTR) T52B3 – object attributes (PATTR) […]