Hi,
DATA : BEGIN OF I_DISPLAY OCCURS 0,
REC(400),
END OF I_DISPLAY.
based on date
select StudentNo S_Course from Course Record
into i_Course Record
****if parameter
where date eq p_Date_join
****if select-options.
where date in s_Date_join.
-
select StudentNo S_Course from Student Details
into i_Student Details
****if parameter
where date eq p_Date_join
****if select-options.
where date in s_Date_join.
-
select StudentNo S_Mark S_Subject
from Student_results
into i_Student_results
****if parameter
where date eq p_Date_join
****if select-options.
where date in s_Date_join.
*********************************
DATA : FNAME(255) TYPE C VALUE '/data/sapdata/eu_ums/astdetails'.
CONSTANTS : C_COMMA TYPE C VALUE ','.
********Fields to insert
I_FINAL-StudentNo = 'StudentNo.
I_FINAL-S_Course = 'S_Course'.
*
INSERT I_FINAL INDEX 1.
CLEAR I_FINAL.
*
LOOP AT I_FINAL.
CONCATENATE
I_FINAL-DOCNUM
I_FINAL-STATXT
into I_DISPLAY-REC SEPARATED BY C_COMMA.
APPEND I_DISPLAY.
CLEAR I_DISPLAY.
ENDLOOP.
OPEN DATASET FNAME FOR OUTPUT IN TEXT MODE.
LOOP AT I_DISPLAY.
TRANSFER I_DISPLAY TO FNAME.
ENDLOOP.
CLOSE DATASET FNAME.
Do this for all tables.
Don't forget to reward if useful
Bluesky
