Query -Error

49 Views

Hi Experts,

I am having a problem in Query....Actually I have Upgraded SAP To 2007.After these upgradation the Queries in which the selection Criteria for Posting Date is given is not working properly.

Example:-

SELECT T0.[DocNum], T0.[Status], T0.[U_Priority], T0.[DueDate], T0.[PostDate], T0.[ItemCode], T0.[PlannedQty], T0.[CmpltQty], T0.[RjctQty], ( T0.PlannedQty-T0.CmpltQty- T0.RjctQty) as 'Open Qty',T0.U_TimeReq, (((T0.PlannedQty-T0.CmpltQty- T0.RjctQty)*T0.U_TimeReq)/60) as 'Total Time Reqd',T0.[U_TimeReq], T0.[U_SHOP], T0.[U_FCName] FROM OWOR T0 WHERE (T0.Series = '31' or T0.Series = '130') AND T0.[Status] = '[%0]' or T0.DueDate >= '[%1]' and T0.DueDate <= '[%2]' or T0.PostDate >= '[%3]' and T0.PostDate <= '[%4]' or T0.[U_SHOP] = [%5] or T0.[U_FCName]=[%6] or T0.[ItemCode] =[%7].

Regards-

Mona.