Hi Experts, I have been developing the below query in the aim to pull through a query based on a date range of one month however SAP just seems to crash each time no matter what i change the WHERE parameters too, Please can you advise:
SELECT DISTINCT
T3.[DocNum] AS 'SO Number', T3.[DocDate] AS 'SO Date', T0.[DocNum] AS 'INV Number', T0.[DocDate], T0.[CardCode], T0.[CardName], T0.[SlpCode], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T1.[Price], T1.[LineTotal],T2.[ItmsGrpNam] FROM OINV T0 INNER JOIN INV1 T1 ON T0.[DocEntry] = T1.[DocEntry], OITB T2, ORDR T3
WHERE T3.[DocDate] >=[%0] and T3.[DocDate] <=[%1]