Error consulta movimiento de inventario SAP BO SQL

[jtriana6591]

hola a todos alguin que me ayude con este error tengo esta consulta y me sale un error perro no logro identificarlo lo raro es que en el sql no me lo marca en rojo ni nada
}
gracias

------------codigo-------------------

select 
       a."ItemCode",
       d."ItemName",
       a."DocDate",
       YEAR(a."DocDate") as "Año",
       MONTH(a."DocDate") as "Mes",
       a."TransNum",
        e."ItmsGrpCod" ,
        e."ItmsGrpNam" ,
       a."StkIni",
       a."InQty" as "Entradas",
       a."OutQty" as "Salidas",
       (a."StkIni" + a."InQty" - a."OutQty") as "StkFin"
FROM (select 
       x."DocDate",
       x."TransNum",
       x."ItemCode",
       x."InQty", 
       x."OutQty",
     (SELECT isnull(SUM(isnull(b."InQty",0) - isnull(b."OutQty",0)),0)  FROM OINM b 
                    WHERE (b."ItemCode" = x."ItemCode") AND
                     ((b."DocDate"  < x."DocDate") OR (b."DocDate" = x."DocDate" and b."TransNum"  < x."TransNum"))
                     
     ) as "StkIni" 

FROM OINM x 

WHERE ((x."InQty" > 0 ) or (x."OutQty" > 0 )) 

) a

INNER JOIN OITM d ON a."ItemCode" = d."ItemCode"
INNER JOIN OITB e ON d."ItmsGrpCod" = e."ItmsGrpCod"

---------------Error--------------------

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ‘’.

[Willy_Caldero]

Tu SAP es sobre HANA o SQL Server?

[juliancab]

estas intentando correr un script de HANA en SQL?

[pcarrasco]

Hola @jtriana6591

Intenta con el siguiente codigo

Select 
    a."ItemCode",
    d."ItemName",
    a."DocDate",
    YEAR(a."DocDate") as "Año",
    MONTH(a."DocDate") as "Mes",
    a."TransNum",
    e."ItmsGrpCod" ,
    e."ItmsGrpNam" ,
    a."StkIni",
    a."InQty" as "Entradas",
    a."OutQty" as "Salidas",
    (a."StkIni" + a."InQty" - a."OutQty") as "StkFin"
   FROM (select 
            x."DocDate",
			x."TransNum",
			x."ItemCode",
			x."InQty", 
			x."OutQty",
               (SELECT isnull(SUM(isnull(b."InQty",0) - isnull(b."OutQty",0)),0)  
			        FROM OINM b 
                       WHERE (b."ItemCode" = x."ItemCode") 
					     AND((b."DocDate" < x."DocDate") OR (b."DocDate" = x."DocDate" and b."TransNum" < x."TransNum")
						    )
                     
                ) as "StkIni" 
          FROM OINM x  
            WHERE ((x."InQty" > 0 ) or (x."OutQty" > 0 )) 
        ) as a
INNER JOIN OITM d ON a."ItemCode" = d."ItemCode"
INNER JOIN OITB e ON d."ItmsGrpCod" = e."ItmsGrpCod"