Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to fetch the data from different HR tables

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.

Not what you were looking for? View more on this topic or Ask a question