Error calling procedure in query manager sap b1 (hana)

0

I try to call a procedure with an input parameter, at the base of hana it brings me the data but when calling them in the query manager I do not get anything This is my from my query manager

  

/ * Select * from "@ A1A_HSPC" t0 where t0. "U_codpro" like '% [% 0]%'; * /   call "SAP_BELATRIX". "Test_Report02" ('[% 0]');

enter image description here

This is the procedure in hana

    ALTER PROCEDURE "SAP_BELATRIX"."Reporte_Prueba02"(in periodo varchar(20)) LANGUAGE SQLSCRIPT AS BEGIN SELECT TOP 1  (SELECT COUNT(DISTINCT concat("U_codpro", "U_codemp")) FROM "@A1A_HSPC" WHERE ("U_codpro" = :Periodo || 'REG')),  (SELECT COUNT(DISTINCT concat("U_codpro", "U_codemp")) FROM "@A1A_HSPC" WHERE ("U_codpro" = :Periodo || 'LBS')),  (SELECT COUNT(DISTINCT concat("U_codpro", "U_codemp")) FROM "@A1A_HSPC" WHERE ("U_codpro" = :Periodo || 'PRA')), (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE ("U_codpro" = :Periodo || 'REG' AND "U_codcon" IN ('LIQUIDO','DESADE'))),  (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE ("U_codpro" = :Periodo || 'PRA' AND "U_codcon" IN ('LIQUIDO','DESADE'))),  (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE ("U_codpro" = :Periodo || 'LBS' AND "U_codcon" IN ('LIQUIDO','DESADE'))),  (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE "U_codcon" IN ('AFPFON','AFPPRI','AFPCOM') AND (("U_codpro" = :Periodo || 'REG') OR ("U_codpro" = :Periodo || 'LBS') OR ("U_codpro" = :Periodo || 'PRA'))), (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE "U_codcon" IN ('SNP','IMPUESTO','ESSALUDV','ESSALUD') AND (("U_codpro" = :Periodo || 'REG') OR ("U_codpro" = :Periodo || 'LBS') OR ("U_codpro" = :Periodo || 'PRA'))) - (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE "U_codcon" IN ('DEV5TAA') AND (("U_codpro" = :Periodo || 'REG') OR ("U_codpro" = :Periodo || 'LBS') OR ("U_codpro" = :Periodo || 'PRA'))), ((SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE ("U_codpro"
= :Periodo || 'REG' AND "U_codcon" IN ('LIQUIDO','DESADE'))) + (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE ("U_codpro" = :Periodo || 'PRA' AND "U_codcon" IN ('LIQUIDO','DESADE'))) + (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE ("U_codpro" = :Periodo || 'LBS' AND "U_codcon" IN ('LIQUIDO','DESADE')))), (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE (("U_codpro" = :Periodo || 'REG') OR ("U_codpro" = :Periodo || 'LBS') OR ("U_codpro" = :Periodo || 'PRA')) AND "U_seg8" = 'H') + (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE "U_codcon" IN ('ESSALUD') AND (("U_codpro" = :Periodo || 'REG') OR ("U_codpro" = :Periodo || 'LBS') OR ("U_codpro"
= :Periodo || 'PRA'))), (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE "U_codcon" IN ('VACPROV','GRAPROV','BOGRAPRO','CTSPROV') AND (("U_codpro" = :Periodo || 'REG') OR ("U_codpro" = :Periodo || 'LBS') OR ("U_codpro" = :Periodo || 'PRA'))) + (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE (("U_codpro" = :Periodo || 'REG') OR ("U_codpro" = :Periodo || 'LBS') OR ("U_codpro" = :Periodo || 'PRA')) AND "U_seg8" = 'H') + (SELECT SUM("U_valeven") FROM "@A1A_HSPC" WHERE "U_codcon" IN ('ESSALUD') AND (("U_codpro" = :Periodo || 'REG') OR ("U_codpro" = :Periodo || 'LBS') OR ("U_codpro" = :Periodo || 'PRA')))  FROM "@A1A_HSPC" a WHERE ("U_codpro" LIKE '' || :Periodo || '%');  END;

If you bring me data

I put it that way because the period can be 201807EMP, 201807LBS and 201807PRA

Thanks

    
asked by Dannylo Ramos 11.09.2018 в 21:23
source

0 answers