10-06-2008 8:04 AM
Hi Experts
I got problem with Oranisational Management Report . please can any one help me out.
I did taken conditions like this.
1 Unlinked Positions
select * from hrp1001 into corresponding fields of table itab where OTYPE = 'S'
and subty ne 'A003'
and sclas eq 'O'.
2 Unlinked Organastions units
select * from hrp1001 into corresponding fields of table itab where OTYPE = 'O'
and subty eq 'A002'
and sclas eq 'O' .
3 Objects with name changes
select * from hrp1001 into corresponding fields of table itab where OTYPE in ('S','P','O','K','C').
4 postions without jobs
select * from hrp1001 into corresponding fields of table itab where OTYPE = 'S'
and subty ne 'B007'
and sclas eq 'C'.
5 jobs without occ. categaries
select * from hrp1001 into corresponding fields of table itab where OTYPE = 'C'
and Infty ne '1633'.
*******
this what i took the conditions . its not pulling the all the data how does it work please help me.
10-06-2008 2:14 PM