Hi.
I want to retrieve 5 fields from table pa0169.
The problem is I also need to check if the Company Code field (pa0001-bukrs) for the employee is one of the specified values.
The company code values are maintained in range r_division with low values.
The Plan_ID values are maintained in range r_plan_id with low values.
Initially I was getting multiple entries for a pernr in the resulting table. Hence I have added the SORT and DELETE DUPLICATES commands.
The Function spec snippet :
Select all employee's where Benefit Plan (P0169-BPLAN) equals Custom Parameter 'Plan ID' Low
Value as of the Parameter 1 date and where Company Code (P0001-BURSK) equals Custom Parameter 'Division
Name' Low Value,
Please tell me if this will work? Also tell me the performance of this query.
SELECT A~pernr
A~bplan
A~begda
A~endda
A~aedtm
FROM pa0169 as A
INNER JOIN pa0001 as B
ON Apernr = Bpernr
AND Abegda >= Bbegda
AND Aendda <= Bendda
INTO TABLE oi_0169
WHERE A~pernr IN r_pernr
AND A~bplan IN r_bplan
AND B~bukrs IN r_division
AND A~begda <= v_parm1date
AND A~endda >= v_parm1date.
SORT oi_0169 BY pernr ASCENDING begda DESCENDING.
DELETE ADJACENT DUPLICATES FROM oi_0169 COMPARING pernr.
Thanks & Regards
Edited by: SUD239492 on Feb 11, 2011 5:17 AM