2007 Aug 16 8:17 AM
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
2007 Aug 16 8:21 AM
Use this code.
APPEND LINES OF t_output_data1 TO t_output_data.Please mark points if the solution was useful.
Regards,
Manoj
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.
<b>APPEND tbl_bsak_temp.</b>
CLEAR tbl_bsak_temp.
ENDLOOP.
2)the following syntax whcih it moves all the records from one itab to other without lopp.
<b> APPEND LINES OF tbl_bsak TO tbl_bsak_temp</b>.
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
<b>APPENDING TABLE tbl_bsak</b>
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
2007 Aug 16 8:21 AM
Use this code.
APPEND LINES OF t_output_data1 TO t_output_data.Please mark points if the solution was useful.
Regards,
Manoj
2007 Aug 16 8:23 AM
Hi Satya,
Loop at table t_output_data1 and append into the second table t_output_data.
<b>Reward points if answer is helpful.</b>
With Thanks,
Chinmay
2007 Aug 16 8:23 AM
Hi
loop at the t_output_data
like this
<b>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.</b>
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
<b>reward if usefull</b>
2007 Aug 16 8:27 AM
loop @ t_output_data1
MOVE t_output_data1 TO t_output_data table
append t_output_data.
endloop
reward points is useful
thx
2007 Aug 16 9:03 AM
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.
<b>APPEND tbl_bsak_temp.</b>
CLEAR tbl_bsak_temp.
ENDLOOP.
2)the following syntax whcih it moves all the records from one itab to other without lopp.
<b> APPEND LINES OF tbl_bsak TO tbl_bsak_temp</b>.
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
<b>APPENDING TABLE tbl_bsak</b>
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
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |