Skip to Content
0

How to get data from one Procedure output table SQL SCRIPT in HANA

Jun 25, 2017 at 06:16 AM

40

avatar image

Hi Experts,

I have create one procedure it is getting result:- two internal table, based on both internal table i wan to create new internal table by using SQL SCRIPT, by doing this want to put all load in data base layer.

Example:-

method get_sale by database procedure for hdb language sqlscript options read-only using ZCL_AMDP_NESTED_SALES_PROC=>get_f_sale_data ZCL_AMDP_NESTED_SALES_PROC=>get_f_deli_data .

et_sale = select * from "ZCL_AMDP_NESTED_SALES_PROC=>GET_F_SALE_DATA"( iv_vbeln => :iv_vbeln );

et_deli = select * from "ZCL_AMDP_NESTED_SALES_PROC=>GET_F_DELI_DATA" (iv_vbeln => :iv_vbeln );

Need HERE

endmethod.

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

0 Answers