on 01-22-2015 7:46 AM
Hi Experts,
Please check below code and suggest to me.
BEGIN
col_tab = CE_COLUMN_TABLE("SAP_ECC"."VBAK");
out = CE_AGGREGATION(col_tab,sum("NETWR"),["VKORG","VTWEG"]);
END /********* End Procedure Script ************/
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 9 (at pos 303)nSet Schema DDL statement: set schema "SYSTEM"nType DDL: create type "_SYS_BIC"."VIJAYG/Z_AGGR_SVIEW/proc/tabletype/VAR_OUT" as table ("VKORG" NVARCHAR(30), "VTWEG" NVARCHAR(30), "NETWR" DECIMAL(15,2))nProcedure DDL: create procedure "_SYS_BIC"."VIJAYG/Z_AGGR_SVIEW/proc" ( OUT var_out "_SYS_BIC"."VIJAYG/Z_AGGR_SVIEW/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_AGGREGATION(col_tab,sum("NETWR"),["VKORG","VTWEG"]);n n t nEND /********* End Procedure Script ************/n
Thanks.
Br,
Edukondalu
Hi Ed,
since col_tab is a variable, you need to use : with the variable name as given below.
And also your out variable is var_out as mentioned in the view definition.
var_out = CE_AGGREGATION(:col_tab,sum("NETWR"),["VKORG","VTWEG"]);
Regards,
Safiyu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.