There are items in SSI 4R4 for Cortefiel group that are not existing in JDA Cortefiel 7.5. This is the reasons why sales data are not tally with 4R4 vs 7.5. To be able to correct this we add this case statement to get the correct UPC of these items. This is already ok by Del of SysOps. 

CASE WHEN SUBSTRING(U.IUPC,1,1)=1 THEN CONCAT(8,SUBSTRING(U.IUPC,2,13))
     WHEN SUBSTRING(U.IUPC,1,1)=2 THEN CONCAT(8,SUBSTRING(U.IUPC,2,13))
     ELSE U.IUPC END 