Material not Received Below 7 days
CREAte PROCEDURE EA_ACC_ShipDate
@shipdate Datetime
as
SELECT distinct T0.[DocEntry], T0.[Project] AS 'STYLECODE', T0.[ItemCode], T0.[Dscription],T2.[ItmsGrpNam],T0.[Quantity], T0.[OpenQty] AS 'OPEN_QTY',T0.[Quantity]- T0.[OpenQty] as 'GRPOQTY', T0.[ShipDate] FROM POR1 T0 INNER JOIN OITM T1 ON T0.[ItemCode] = T1.[ItemCode] INNER JOIN OITB T2 ON T1.[ItmsGrpCod] = T2.[ItmsGrpCod] WHERE T0.[OpenQty]>='1'
and t0.shipdate<=dateadd(DAY,7,@shipdate) ORDER BY T0.[ShipDate]
Add User Query in Testing Company [SAP Query Window] /* SELECT FROM [dbo].[POR1] T0 */
DECLARE @shipdate AS datetime
/* WHERE */
SET @shipdate = /* T0.ShipDate */ '[%0]'
EXEC EA_ACC_ShipDate @shipdate