appending table -

[Former Member]

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.

[Former Member]

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^

[Former Member]

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]

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

[Former Member]

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

[Former Member]

Hi

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

Regards

Madhan

[Former Member]

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]

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]

Hi Sushanth,

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

regards,

Advait

[Former Member]

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]

This message was moderated.