Skip to Content
0
Jun 18, 2021 at 08:05 AM

SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "END"

551 Views

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;