SAP Utilities

preventSWEI-Error.sql

-- you must use this syntax to the trick work
-- youre going to select a variable based on the desired field
-- change the line 5 accordingly to your desired table

/* SELECT * FROM OITB x */
DECLARE  @ItemGroup AS VARCHAR(MAX)

-- your variable from SAP becomes a SQL server variable
SET @ItemGroup = '%' + /* x.ItmsGrpNam */ [%0] + '%'

SELECT 
	*
FROM (
  SELECT
    T0.ItemName,
  FROM
    OITM T0
   WHERE
    T0.ItemName LIKE @ItemGroup
) AS TAB