06-03-2010 8:52 PM
can anyone explain me how to know which table the below code is reading data from Database.
DEFINE sel.
when &1.
sort s_t_select by fieldnm.
do.
fetch next cursor g_cursor into id.
if sy-subrc eq 0.
import &2 from database &3(bw) id id.
I want to know how these macro will fetch data from database.
In the below code i have shown how these &2 and &3 have been built.
CASE s_estruc.
sel 'MC03BF0' mc03bf0_tab mc03bf0setup.
ENDCASE.
Regards,
Mayank
06-03-2010 9:49 PM
Hi,
This the result of your program with macro:
CASE s_estruc.
when 'MC03BF0'.
sort s_t_select by fieldnm.
do.
fetch next cursor g_cursor into id.
if sy-subrc eq 0.
import mc03bf0_tab from database mc03bf0setup(bw) id id.
ENDCASE.
The macro "copy" your code to the indicated position, replacing only &xx.
In your case, if s_estruc = 'MC03BF0' the program will do the fetch and the import. The selection from fetch is outside this code...
Best regards,
Leandro Mengue
06-03-2010 9:49 PM
Hi,
This the result of your program with macro:
CASE s_estruc.
when 'MC03BF0'.
sort s_t_select by fieldnm.
do.
fetch next cursor g_cursor into id.
if sy-subrc eq 0.
import mc03bf0_tab from database mc03bf0setup(bw) id id.
ENDCASE.
The macro "copy" your code to the indicated position, replacing only &xx.
In your case, if s_estruc = 'MC03BF0' the program will do the fetch and the import. The selection from fetch is outside this code...
Best regards,
Leandro Mengue