04-20-2007 8:44 AM
hi all
how to read fields from hr related the table pa000 and how to join the pernr field
in pa000 with other hr table pa0105-pernr can u provide any syntax.
thanks
04-20-2007 8:47 AM
YOu can just write a select as you normally do for a table.
select * from pa0000 into table itab where <condition>.
or you can use the FM: RH_READ_INFTY
Regards,
Ravi
04-20-2007 8:50 AM
Hi,
Are you using the Logical database PNP or not
If you don't use LDB you can write select statements like how we write select statements for General tables in other modules
if you use LDB's then it is different.
Infotypes:0000, 0105.
get pernr.
rp-Provide_from last 0000 ' ' pnpbegda pnpendda.
rp-Provide_from last 0105 ' ' pnpbegda pnpendda.
this will fetch all data from 0000 and 0105 infotypes.
take the required fields into an internal table and display.
other wise write select statement using the link PA0000-Pernr = pA0105-Pernr.
reward points if useful
regards,
ANJI