on 04-30-2010 4:58 AM
hi..
i want to ask..
is it possible to get data of infotype 0017 (travel privileges) that has not been create for all employee?
any standard from SAP?
let say, we hire 232 new employee.
that new employee hasn't got travel privileges, what is the simplest way to know from what personnel number to start to create it0017?
thx
Hi
Write a simple SAP Query on IT17. this will give u report, for whom all it is maintained, and not maintained.
Regards
...Sadhu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
You can to a comparative analysis here.
Check the number of entries in PA0000 and PA0001 Tables. If the Personnel Number exist here then the person actually exists in the system. Now compare the no: of entries in these two tables with the no: of entires in PA0017 Table.
For all the personnel numbers which exist in PA0000 and PA0001 but not in PA0017, the Travel Privileges does not exist.
Hope this helps.
Harsh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
A short report in ABAP will provide you the information. You just need few lines of code.
Or you start SE16 on table PA0017 and select all your 232 employees. Then on the result you check the employee numbers missing and you have your result.
Hope this help.
Regards,
Christophe
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
In SE16 (PA0017) it shows all the employees, for whom IT0017 is maintained. As you said, there are 232 employees and in SE16 (PA0017) shows 132 employees. Then for the balance 100 employees it is not maintained.
When you download the data, it shows the employees with the employees no and do a VLOOKUP in the excel sheet to find out the remaining employees.
Hope this helps.
Regards,
S.Srikanth
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.