topic Re: Append is not working in Application Development and Automation Discussions

Append is not working

Former Member — Thu, 16 Aug 2007 07:17:56 GMT

Hi Experts,

I ve two table t_output_data1 and t_output_data and in the t_output_data1 table i have 2 records. But when i am trying to append these records to t_output_data table then its append only one records.

Can u please help me .

regards,

Satya

Re: Append is not working

Former Member — Thu, 16 Aug 2007 07:21:54 GMT

Use this code.

APPEND LINES OF t_output_data1 TO t_output_data.

Please mark points if the solution was useful.

Regards,

Manoj

Re: Append is not working

Former Member — Thu, 16 Aug 2007 07:23:25 GMT

Hi Satya,

Loop at table t_output_data1 and append into the second table t_output_data.

Reward points if answer is helpful.

With Thanks,

Chinmay

Re: Append is not working

Former Member — Thu, 16 Aug 2007 07:23:37 GMT

loop at the t_output_data

like this

loop at t_output_data.

t_output_data1-field1 = t_output_data-field1.

t_output_data1-field2 = t_output_data-field2.

append t_output_data1

endloop.

try like this then it will append all the records to the next internal table

if u don't put like this then it will get the last record to be displayed

reward if usefull

Re: Append is not working

Former Member — Thu, 16 Aug 2007 07:27:28 GMT

loop @ t_output_data1

MOVE t_output_data1 TO t_output_data table

append t_output_data.

endloop

reward points is useful

thx

Re: Append is not working

Former Member — Thu, 16 Aug 2007 08:03:27 GMT

Hi,

these are syntaxes for append statement.

1)This syntax is for append the records from one internal table into other with loop.

LOOP AT tbl_bsak.

CLEAR tbl_bsak_belnr.

MOVE: tbl_bsak-bukrs TO tbl_bsak_temp-bukrs,

tbl_bsak-gjahr TO tbl_bsak_temp-gjahr,

tbl_bsak-augbl TO tbl_bsak_temp-belnr,

tbl_bsak-monat TO tbl_bsak_temp-monat.

APPEND tbl_bsak_temp.

CLEAR tbl_bsak_temp.

ENDLOOP.

2)the following syntax whcih it moves all the records from one itab to other without lopp.

APPEND LINES OF tbl_bsak TO tbl_bsak_temp.

3) the following syntax is used to append the records from Database table to internal table which it contain alread records.

Suppose tbl_bsak contains some records againg you need to add some more records into the existing tbl_bsak.

SELECT * FROM bsak

APPENDING TABLE tbl_bsak

FOR ALL ENTRIES IN tbl_bsak_temp

WHERE bukrs EQ tbl_bsak_temp-bukrs

AND gjahr EQ tbl_bsak_temp-gjahr

AND belnr EQ tbl_bsak_temp-belnr

AND monat EQ tbl_bsak_temp-monat

Reward with points if useful

Regards,

Vijay