Skip to Content
0
Former Member
Feb 20, 2009 at 07:18 PM

Native SQL

33 Views

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.