Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

after APPEND wa to itab . the data is not appended into itab.

Hi all,

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'.

ENDIF.

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.

ENDLOOP.

thanks in advance for help...

Former Member
Not what you were looking for? View more on this topic or Ask a question