Welcome Notes

Welcome Viewers

01 January 2016

Material not Received Below 7 days

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