Buenas tardes
Soy novato en el uso de SAP y HANA, tengo que hacer un procedimiento almacenado el cual tiene la funcionalidad de ejecutar una consulta.
Al querer ejeciutar recibo el siguiente error:
SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "END"
Me sería de mucha ayuda saber en que estoy fallando
Dejo el código:
CREATE PROCEDURE SP_CERTIFIQUED( IN F_Inicial timestamp, IN F_Final timestamp, Bodega NVARCHAR(10)) LANGUAGE SQLSCRIPT SQL SECURITY INVOKER READS SQL DATA AS BEGIN SELECT T0."U_FacSerie" AS SERIE, T0."DocDate" AS FECHA_DOC, T0."DocTime" AS HORA_DOC, T0."U_FacSerie" AS SERIE, T0."U_FacNum" AS NUM_FAC, T0."U_SO1_01FOLIORETAIL1" AS R1_FOLIO, T0."DocNum" AS SAP_NUM, CAST(T0."U_CAE" AS VARCHAR(200)) AS CERTIFIQUED_NUMBER, T0."DocStatus" AS STATUS_DOC, T0."CardCode" AS COD_CLIENTE, T0."CardName" AS "NOMBRE CLIENTE", T0."U_FacNit" AS NIT_CLIENTE, T0."DocTotal" AS DOC_TOTAL, T1."SlpCode" AS COD_VEN, T1."SlpName" AS "NOMBRE VENDEDOR" FROM OINV T0 INNER JOIN OSLP T1 ON T0."SlpCode" = T1."SlpCode" INNER JOIN INV1 T2 ON T0."DocEntry" = T2."DocEntry" WHERE T2."WhsCode" = Bodega AND T0."DocDate" >= F_Inicial AND T0."DocDate" <= F_Final ORDER BY T0."DocNum" ASC END;