Hi Experts,
Need help in rewriting the below Open SQL to Native SQL using DB cursor for opening, fetching and Closing to capture the runtime errors occured.
If not itab1[] is initial.
Select gl_sirid ryear poper rprctr sgtxt ps_psp_nr
from glpca
appending table i_itab2 package size 1000
for all entries in itab1
where kokrs = itab1-kokrs
and ryear = p_year "Parameter
and rprctr = itab1-prctr
and rvers = c_per_ver "Constant with value = '000'
and racct in s_racct. "Select-option
endselect.
endif.
Thanks in Advance.