Issue with Adhoc queries

[Former Member]

Hi,

Background: 3 additional fields were added to infotype 0023 to capture the position at the previous organization, Years of exp and Months of previous exp.

The year and Month of previous exp gets populated automatically if you save the start date and end date.

Issue: We try to populate a repot using adhoc query but it doesnot give proper data. example if 0023 has been updated for 100 employees the output would reflect only for 20 odd numbers.

There is no authorization problem

Can anyone suggest why we are facing this issue and if this can be resolved also is there any standard SAP reprot which can give a listing of 0023 for a list of employees

RB

[paul_davidson · Accepted solution]

Hi RB,

Dates, dates, dates....you are looking at infotypes with past dated start and end dates. If your selection screen is "Today", then these records will not appear. Change date to "Past" or "All". You may also want to include a start date date range as a selection field. This should also help to bring in the past dated records.

Paul

[Former Member · Accepted solution]

Also, if the dates of IT23 are before hire date (as they often are), you need to set the switch for time-dependency. You do this in "extras" -> "Code". The syntax is shown below, and the *$ is part of the syntax

*$HR$ [P0022,P0023]

*$HR$ TIME_DEPENDENCE = 'INDEPENDENT'

You still need to ask for period all, but then it should work.

Hope this helps.

Kirsten

[Former Member · Accepted solution]

PS - the infotypes should be in square brackets. Lost in the formatting here.

There is a real good paper out there about switches - hope you can get a hold of it.

Kirsten

[Former Member]

There might be multiple possiblities

1. Query join issues, then check the joins

2. Query was create in PNP logical DB. Then recreate the query with PNPCE LogicalDB.

3. Infoset might be need to regenerated.

Please try in your QA first and later in production. If generation fails then other queries using the infoset cannot be executed.

[Former Member]

Hi,

Are you giving any conditions in the selection? also check the date intervels in the selection screen.

Once you select all the selection options, hit the HIt list button where we come to know how many records will get generated accoding to that we can plan.

Regards,

Vasu.