on 04-21-2006 2:52 PM
Hi all,
i want to select runid and document number in the report where selection criteria is personnel number, company code and payroll area and payroll period and the status of the document should be 40. kindly tell me which table should i use to link all these selection criteria to select the runid.
Thanks & Regards,
Priti
HI,
It reads tables : pevst.pevsh.
main program for tr.PCP0 ( SAPMPCP0 )
if you see in program :MPCP0F01
e,g
select pevsttype pevstrunid pevstname pevstsimu h1~status
h2creator h2creadate h2~creatime
into corresponding fields of table runtab
from pevst join pevsh as h1 on h1type = pevsttype
and h1runid = pevstrunid
join pevsh as h2 on h2type = pevsttype
and h2runid = pevstrunid
where pevst~type in valid_types
and h1~actual = 'X'
and h2~seqno = '00'
order by pevsttype pevstrunid.
pl..award the points .
Thanks
Saquib khan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Priti,
Check programs
RPCIPP00
RPCIPDEL
RPCIPM00
Hope this provides some inputs.
Thanks
Lakshman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.