How to fetch the from different HrR 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:
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.