12-03-2007 3:11 AM
Hi to all
I am modifying a standard report pp6b HR report.
I added a field Employee group. But it is not coming with updated seniority.
select single * from pa0001 where pernr = data_tab-hidden_pernr and
ygroup ne ' ' .
I am unable to find out exactly what is the date field in standard report.
I have to compare begda and endda .
plz guide me....
12-03-2007 4:21 AM
Hi,
Check for begda <= sy-datum
and endda >= sy-datum
in your select query and try.
Note:Pls reward suitbale points.
Regards,
IFF
12-03-2007 4:43 AM
Hi,
If PNP logical database is used in the program, then try using macro
rp-provide-from-last p0006 space pn-begda pn-endda.
12-03-2007 5:12 AM
Hi,
Try to get the latest record by comparing the Begin date and End date.
As per the system dte if u want to get the seniority, use
begda LE sy-datum and endda GE sy-datum.
If for any particular month, u want to get the seniority,
Ex: 11th month ( p_date)
use like this
begda LE p_date and endda GT p_date.
Regards,
Vani