Skip to Content

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

Need query help

Hi Experts

i had created a query, in which i need to filter it via, year wise for example , FY2014 and dept wise, in which dept is already working

how is it possible

the below attached is the query 

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

SELECT distinct T3.[Name] as 'Worker Category', max(T0.[U_Rate]) as 'Current Rate',

max(T1.[U_Rate]) as 'Revision Rate' ,T2.[Name]as 'Department'

FROM OHEM T0  INNER JOIN AHEM T1 ON T0.empID = T1.empid

INNER JOIN OUDP T2 ON T0.[dept]=T2.[Code]

INNER JOIN OHPS T3 ON T0.[position]=T3.posID

WHERE (T1.[U_IQId] <> T0.[U_IQId] OR T1.[U_IQId] is null ) and T0.[dept]='11'

group by T3.[NAME],T0.[U_Rate],T1.[U_Rate],T2.[Name]

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Regards

Former Member
Former Member replied

Hi,

You may try using AHEM.updatedate to filter.

Thanks,

Gordon

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