Skip to Content
0

Use of Stored Procedure in SPS11 & 12 Onwards

Jan 16, 2017 at 02:44 PM

109

avatar image

Hi,

Im little confused about usage of stored procedure from SPS11/12 onwards. Here it goes

i) Though scripted calc views are available but SAP is recommending not to use anymore and have give a migration tool as well to migrate all scripted views to table UDF.

ii) i can not utilize my procedure into graphical calc view. i guess this is because a procedure can have multiple result sets and we can map only 1 resultset to calc view projection or aggregation node. So i have to use table UDF only if i have to pass resultset to graphical view.

iii) A table UDF can not call procedure though vice-versa is possible.

Considering the above could anybody please let me know where and how can we use stored procedure. Of course im missing a big part here but please advise me on this.

Thank you

SQL
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers