on 01-22-2015 6:54 AM
Hi,
the small ce script is not executing and getting below error.
please advise.
BEGIN
col_tab= CE_COLUMN_TABLE("SAP_ECC"."VBAK");
out = CE_PROJECTION(col_tab, ["VKORG","VTWEG","NETWR"],"VKORG" = "1000");
END
Message :
Internal deployment of object failed;Repository: Encountered an error in repository runtime extension;Internal Error:Deploy Calculation View: SQL: sql syntax error: incorrect syntax near "out": line 6 col 8 (at pos 313)nSet Schema DDL statement: set schema "SYSTEM"nType DDL: create type "_SYS_BIC"."VIJAYG/Z_VBAK_SCALVIEW/proc/tabletype/VAR_OUT" as table ("VKORG" VARCHAR(15), "VTWEG" VARCHAR(15), "NETWR" DECIMAL(15,2))nProcedure DDL: create procedure "_SYS_BIC"."VIJAYG/Z_VBAK_SCALVIEW/proc" ( OUT var_out "_SYS_BIC"."VIJAYG/Z_VBAK_SCALVIEW/proc/tabletype/VAR_OUT" ) language sqlscript sql security definer reads sql data as n /********* Begin Procedure Script ************/ n BEGIN n n col_tab= CE_COLUMN_TABLE("SAP_ECC"."VBAK"); n out = CE_PROJECTION(col_tab, ["VKORG","VTWEG","NETWR"], ' "VKORG" = ''1000'' ');n n END /********* End Procedure Script ************/n
Thanks.
Best Regards,
Edukondalu
Hi,
above syntax has couple of issues
1. please don't user "out",it is reserved word.
2. ":" is missing before col_tab
3. put filter condition in single quoted
4. remove double quotes for 100
correct syntax:
var_out = CE_PROJECTION(:col_tab, ["VKORG","VTWEG","NETWR"],'"VKORG" = 1000');
I hope it solved your problem.
regards,
sai Krishna.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, It worked fine
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.