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.
