Skip to Content
0
Mar 24 at 03:20 PM

AR SALES ORDER VS AR INVOICE WITH ITEM DETAILS

52 Views

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]