Sep 03, 2020 at 03:33 PM

Syntax error while creating Calculation view script based on end help

104 Views

I am getting this error when trying to deploy a calc view Can someone help me?

Repository: Encountered an error in repository runtime extension;Model inconsistency. Deploy Calculation View: SQL: sql syntax error: incorrect syntax near "END": line 8 col 1 (at pos 312) Set Schema DDL statement: set schema "HANA_TPV" Type DDL: create type "_SYS_BIC"."TPV/Z_TESTING_MJE/proc/tabletype/VAR_OUT" as table ("KUNNR" VARCHAR(10)) Procedure DDL: create procedure "_SYS_BIC"."TPV/Z_TESTING_MJE/proc" ( OUT var_out "_SYS_BIC"."TPV/Z_TESTING_MJE/proc/tabletype/VAR_OUT" ) language sqlscript sql security definer reads sql data as /********* Begin Procedure Script ************/ BEGIN var_out = select SAPSHD.KNA1.KUNNR from SAPSHD.KNA1 END /********* End Procedure Script ************/