How is the Interaction between Data and Person selection period, and Selections in reports based on HR logical databases PNP/PNPCE? When using logical databases PNP/PNPCE, it’s important to distinguish between the person selection period and the data selection period: Person Selection period: the system will select all the objects for which […]
Duplicate lines do not displayed in query (Ex. Infotype 0015, 0014)
Symptom Duplicate lines do not displayed in query (Ex. Infotype 0015, 0014) Cause When running queries that extract information about wage types, like for example with infotype 0015 additional payments, it could happen that employee has two identical records. When running the query for a period when these two identical […]
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. […]