Skip to Content
0
Feb 12, 2011 at 06:47 AM

How to Link or Jiont Tables by using SAP Query.

36 Views

Dear Hcm Gurus:

I have developed query report by using selection and output criteria, i have assigned T-Code "ZHR_STAFF" by using transaction "SE93" So report selection is accurate as it is based on one table while output of report is based on multiple tables

e.g in out put we required following info type

0000 Action info type

0001 Organizational Assignment

0002 Personal Data

0032 Internal Data

9209 Staff Expense

so when i execute report then it display only one info type 9209 records while others ignoring ,thatwhy ,i have to establis

jiont between these table,

Kindly clarify the whole process that how we make joint between these tables so that report display whole info type data in out put.

so unique key between these tables is "Personnel Number " for employees

so joint will be establish by using "perner"

is it establish through se11?

Kindly clarify the procedures for enlisted issue,

Kind Regards

Barket Ali Zafar

SAP HCM Consultant

SIEMENS

+92-300-5521524