Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

appending table -

Former Member
0 Kudos

FORM sub_get_kna1_1 .

IF t_vbak IS NOT INITIAL.

SELECT kunnr "Ship to party

name1 " Customer name

ort01 "City

pstlz "Postal Code

regio "Region

FROM kna1

APPENDING TABLE t_kna1

FOR ALL ENTRIES IN t_vbak

WHERE kunnr = t_vbak-kunnr.

ENDIF.

1) in the above code what do the key words appending table stand for ? t_kna1 is an internal table which already has some data.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

few more records are appended to table T_KNA1 when the conditions in the select query are satisfied.

9 REPLIES 9

Former Member
0 Kudos

Well..

In this statement the new entries fetched through this SELECT statement will be appended to the t_kna1 table in addition to existing entries.

If the 'appending table ' is not given the previous entries will be deleted and the new entries alone will be there in t_kna1.

Note - The structure should be same to avoid dumping

Cheers,

Kothand

Former Member
0 Kudos

well the selected information is beeing appended to table t_kna1 as a new record.

Former Member
0 Kudos

few more records are appended to table T_KNA1 when the conditions in the select query are satisfied.

Former Member
0 Kudos

Hi

I think the appending statement means, it will append to exisitng t_kna1 data, it will not over write

Regards

Madhan

Former Member
0 Kudos

your question itself has the answer..!

t_kna1 is table which already has data and they are appending the additional data with this select query.

means: t_kna1 will have previous data + current select query data.

use F1 option in APPENDING TABLE. u'l get better understanding.

regards,

padma.

Former Member
0 Kudos

hi sushanth singh

appending keywords used to insert a new records along with the already existing records..

whereas into table keyword is overwrite the existing records

Regards

Selva

Former Member
0 Kudos

Hi Sushanth,

Appending means that the entries will be appended to the existing entries in the itab t_kna1.

regards,

Advait

Former Member
0 Kudos

Hi

Good

Appending table statement use to append the data in the after the last line of the internal table, if the internal table having 5 lines of data than it will start appending the new records from the 6th line.

Check the below line for futher clarification on APPEND.

http://help.sap.com/saphelp_nw70/helpdata/EN/fc/eb36c8358411d1829f0000e829fbfe/content.htm

Thanks

mrutyun^

prince_isaac
Active Participant
0 Kudos

This message was moderated.