Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

to read data from hr related tables

Former Member
0 Kudos

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

2 REPLIES 2

former_member181962
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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