cancel
Showing results for 
Search instead for 
Did you mean: 

Not able to capture procedure data in to column views

ashutosh_shrivastava4
Participant
0 Kudos

Hi Folks,

I am not able to capture procedure output in column views. I am giving one simple example.

Below procedure is taking field

VBELN as an input parameter and output parameter is VBAK table.

CREATE PROCEDURE "TestProc" (IN ZVBELN NVARCHAR (10),OUT Z "VBAK")

READS SQL DATA WITH RESULT VIEW "VBAK_TABLE"

AS

BEGIN

Z = SELECT * from "VBAK" where VBELN =:ZVBELN;

END;

Calling Procedure--->

CALL"BEST"."VBAK_TEST098" ('0000016861',z=>?);

I can see the attached Procedure values.

but Coulmn views "VBAk_TABLE" is showing below error--

Error--column store error: search table error: [34023] Instantiation of calculation model failed;exception 306106: Undefined variable: $$zvbeln$$. Variable is marked as required but not set in the query

Please suggest ..

Thanks.

Accepted Solutions (0)

Answers (1)

Answers (1)

pfefferf
Active Contributor
0 Kudos

As your procedure has a parameter, the generated result view has a parameter too (consider that it is a view and not a persisted result of the procedure result). Because of that you have to supply the parameter when you do a query on the result view. E.g.

SELECT * FROM "BEST"."VBANK_TABLE" ( PLACEHOLDER."$$zvbeln$$" => '0000016861' );
ashutosh_shrivastava4
Participant
0 Kudos

Agreed.can you suggest the syntax to write the result view with parameter / condition ?

Thanks.

pfefferf
Active Contributor

Already done. Just read!