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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How to fetch the data from different HR tables

Former Member

‎09-19-2008 9:42 AM

0 Kudos

This is a simple query of employee number, name, location and phone number based on selection criteria of Personnel Area (P0001-WERKS), Employee Status (P0000-STAT2) and Key date(P0001-begda) is parameter.

The following Data need to be fetch:

Employee Number(P0709-PERSON_TXT)

Employee Name(P0002-NACHN,VORNA,MIDNM)

Primary Location (SAP Business Area, P0001-GSBER)

Location Description (SAP Business Area Text)

Location Main Phone Number (where P0006-COM0X "Work", return AREAX and TELNX to produce formatted number, ex: 305-882-5300).

Please help me out.

2 REPLIES 2

Former Member

‎09-19-2008 9:45 AM

0 Kudos

Hi

first based on Selection criteria get all the employee numbers into an internal table. then use multiple internal table for different infotypes data to get those details.

Use JOINS / indivual selects with FOR ALL ENTRIES on first internal table.

Former Member

‎09-19-2008 10:46 AM

0 Kudos

use PNP logical database and event get pernr. Selction screen of the program can be modified with report categories.

thnkas,

krishna