after APPEND wa to itab . the data is not appended into itab.
my requirement is to make a relationship among 11 tables to make a database for my project. I break those tables into 3 to 4 tables and applied join on them and at last i got THREE internal tables. now I want to fetch the data from each of the 3 internal table and store them in a single internal table.
when i tried to apply a LOOP on one internal table and append the wa to the main internal table, the data actually not appended in the main table..
SELECT sanalysis_id tmasterprocess_id ucountry_name vetvxformat_id w~process_comments
wcountry_comments wetvx_remarks INTO CORRESPONDING FIELDS OF TABLE itab_analy
FROM ( ( ( ( zanaly_process AS s INNER JOIN zmast_process AS t ON smasterprocess_id = tmasterprocess_id )
INNER JOIN zcountry_data AS u ON scountryid = ucountryid )
INNER JOIN zetvx_table AS v ON setvxformat_id = vetvxformat_id )
INNER JOIN zcomm_table AS w ON scomments_id = wcomments_id ).
IF sy-subrc <> 0.
WRITE:/ 'No Records Found'.
LOOP AT itab_analy INTO itab_analy.
APPEND itab_analy to itab_final.//// here is the problem..i don't get any data from itab_final..
*MODIFY itab_final FROM wa.
WRITE:/ 'what happend',itab_final-analysis_id.
thanks in advance for help...