Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers